I have a Facilities Walkthrough table where each field represents an area. For example:Store, 1.1 - Tables, 1.1 Issue, 1.1 Image, 1.1 Owner, 2.2 Awnings, 2.2 Issue, 2.2 Image, 2.2 Owner, etc.12, yes, scratched top, <image of table>, dave, , , , , In...
I have a Formula Field that creates a custom URL from my airtable. In the past, if a piece of data was missing in the airtable that was referenced in the Formula field … the data would just be empty. Now though, it’s throwing an error unless all of...
I have two tables: database & authorityMatrix .
When a new record hits database, it has a field called: cost
In the authorityMatrix, I have a table with names, emails, and approvalAmounts. The approvalAmounts are the highest Costs that person can a...
I would setup an automation to run the script whenever a new record is created.Table 1 - FacilitiesWalkthrough (has the data)Table 2 - Remediation (where I want to put data when it exists)
Thank you for the information. I don’t think I did it correctly, as it’s still kicking back an error. Here is the custom URL:
'https://form.jotform.com/xxxxxx?’
& ‘brand’ & ‘=’ & ({Brand})
& ‘&email’ & ‘=’ & ({Email})
& ‘&name’ & ‘=’ & ENCODE_URL_C...
