QuoteWerks Support Portal

We have both accounts AND contacts in Zoho. A lot of our contacts do not have accounts though as they are general domestic clients not businesses. Intergrations appears to work very well for contacts linked to accounts. Always get an error message if there is no account linked to contact. Only work around we have found so far is to not create a new linked doc and not create/attach to deal. Any ideas?

Can anyone tell me if this is still the case with Zoho? Do we still need an Account or is there a work around?

TIP: you might want to use the "lower" function as part of the formula to avoid unexpected results due to case-sensitivity... "domestic", "Domestic", DOMESTIC", etc. 

lower(documentheaders->soldtocompany)<>"domestic"

Matt Rose,

ABSOLUTELY BRILLIANT AS USUAL!!!

Perfect :)

The formulas in green above are definitely correct.

Are you:

Hitting the formula icon at the top

giving the formula a name

entering the formula

placing it in the layout?

(instead of the SoldToCompany) reference

Screenshare if you're still unsure:

https://fastsupport.gotoassist.com/527264729

Exactly mate! 

Sold to contact etc all stay just the sold to company field changes.

We definitely can, I'm just not following what you want.

Are you wanting this to say the SoldToCompany value, unless you enter "Domestic". In which case you want it to say nothing at all?

The current work around I have is I have duplicated the report and removed the 'sold to company' field from the report and called the report "domestic" I was just hoping that i could have a single report with a filter.

Hi Mate,

No I just want to not see "Domestic" from the report header if it is the 'sold to company' Otherwise it all stays the same.

Peter

I guess I'm a bit confused as to what the goal is here.

Are you looking to omit the entire ReportHeader section if it ="domestic"

If so, simply try 

documentheaders->soldtocompany<>"domestic"

That will show the the report header, only if the soldtocompany does not equal "domestic"

Hi Matt,

What I entered is

That reads correct but i get a msg saying

This expression must evaluate to a TRUE/False Result, Please reenter

Have tried it with both a "domestic client and a company but get the same error.

Try this:

.if.documentheaders->soldtocompany="X".then."".else.documentheaders->soldtocompany

Thanks, Think have may sorted a work around.

I need a filter for a layout that says

If sold to company is "X" then lave blank. Can that be done?