Quote variables vs. merge fields

lock
push_pin
done
Answered
1

Hi SuperOffice friends

Can anyone explain what the difference and use is of the quote fields; variables and merge fields? Ie. we have a variable for delivery terms {qdev} and a similar merge field <<quote/deliveryTerms>> What is used when? I would like to use the variables/merge fields in the quote details document.

Another question... The details document shows dates in 2 different formats. How can I ensure that dates are only shown in 1 format?

I read about the possibility to set the document culture in the templates our SuperOffice.docs. It says: it is possible to include the merge field Culture: in the template, specifying a .NET culture code, taken from System.Globalization.CultureInfo. For Switzerland, use "Culture:de-CH".

Do I just put in <<Culture:da>> somewhere in the template, or must I insert the culture in a merge field. And what is the settings for Denmark? (DA?) Can´t find a list...

I would appreciate if you have a document template I can look at. That would really be a big help...

19 Sep 2022 | 12:45 PM

All Replies (1)

Hi Susan,

You can find all cultures here Culture Names [C#] (csharp-examples.net) and probably on a lot of other places on the web.

For one of our customers I've added the culture value (mergefield) after starting the alternative in Quote.

«TableStart:quote»«TableStart:alternative»«Culture:de-DE»


When it comes to formatting date or amount values, you can use a format part within the mergefield.

Example for dates:
{ MERGEFIELD quote/expiration \@ "dd-MM-yyyy" }

Example for amounts:
{ MERGEFIELD alternative/totalPrice \# ",0.00" }

You can also use IF statements if you want to add some logic:
{ IF { MERGEFIELD line/ExtraField1 } = "0" "" "Material needed: { MERGEFIELD line/ExtraField1 \# ",0.00" } m/p m2" }

Above IF example shows nothing if ExtraField1 is 0 and shows 'Material needed: 50.00 m/p m2' if value in ExtraField1 is not 0 (for example 50).


27 Sep 2022 | 11:24 AM

Add reply