Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4817 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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!

Posted

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 & "\")" ]

This topic is 4817 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.