Brian_Pearson - profile

Brian_Pearson · Feb 01, 2023

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...

Brian_Pearson · Feb 22, 2022

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...

Brian_Pearson · Aug 29, 2020

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...

Brian_Pearson · Feb 02, 2023

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)

Brian_Pearson · Feb 23, 2022

Wonderful! That’s really helpful! Worked Perfect!

Brian_Pearson · Feb 22, 2022

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...

User Statistics

User Activity

Need some scripting help - copy values and field names to another table

Formula Field for Custom URL has changed behaviors

Get value from one table and insert it into another table based on a range of data

Re: Need some scripting help - copy values and field names to another table

Re: Formula Field for Custom URL has changed behaviors

Re: Formula Field for Custom URL has changed behaviors