Passing global variables from a script into a calculation?

[skearton]

Hi,

How do I pass global variables into a calculation to create text in a field?

This is the part of the script where I set a field with text and global variables set in an earlier part of the script:

Set Field [project_PROJECTNOTES::Description; "New sales order " & "$$ProjectSalesID" & " created. (Quote status: " & "$$QuoteStatus" & ")" ]

This is the result I get in browse mode:

New sales order $$ProjectSalesID created. (Quote status: $$QuoteStatus)

Is it possible to do this or do I need to approach it differently?

Thank you for your help!

[doughemi]

Remove the quotes around $$ProjectSaiesID and $$QuoteStatus. Placing them in quotes indicates to FileMaker that they are literal strings, not variables.

If you need to show the quotation marks in the field, escape them by preceding them with a backslash:

Set Field [project_PROJECTNOTES::Description; "New sales order \"" & $$ProjectSalesID & "\" created. (Quote status: "\"" & $$QuoteStatus & "\")" ]

[skearton]

That was the trick! Thanks for helping me with that!