Feb 24, 202310:46 AM - edited Feb 24, 202310:58 AM
I am new to this forum! I thought id just throw this out there to see who I can stump and if I can get some help. I tried writing this with chatgpt but I dont think it has the most recent coding and API’s in its database.
I am on the free version of Airtable.
The script I want to write is as follows.
First, the script gives a new entry or existing entry under the ‘ORGANIZATIONS table a random 6 digit number that no other entry will have and places it under the "Identifier Number" field which is a single line text. Once this entry has a number, it will never change.
As a note, it would be really awesome if the first two numbers could be the year the record was created (for example its 2023 and the first two numbers would be a 23).
Next,if any of the following fields match to new or existing entries: Street Address 1, Street Address 2, Zip, Organization Name. It will make sure all those above fields are correct and add the same “Identifier Number” to all the entries.
BUT, if the Street Address 1, Street Address 2, or Zip differ, then it will give an added .1 to the Identifier Number (xxxxxx.1, xxxxxx.2 etc) to be used to identify different franchised locations.
I also want it to keep specific parent and child records updated if a condition is selected. I am unsure if I can do all of this in one script!