I have a list of unique ID+count information in a rollup field. See sample data below.16389-0*4, 70895-0*2, 53429-0*2, .....Everything before the * is an ID, and the integer following the * is a count for that ID. I would like to strip everything pri...
I'm helping with a local food pantry and shifting their data mgmt from google sheets to airtable. They register clients in a 1-time data entry task, then each time that client visits, they record that visit. So I have a Clients table and ClientVisits...
Not sure of your requirements but is there a need to use a script here? Could you just use the native automation methods - Find Records in table1, then in a repeating group, use the create record action and use the data from prior Find Records step.
I think this may be possible by using the Script extension. Your script would need to ...capture the recordID of the active project (for later use in creating the task)prompt the user for task metadata in a new window, and capture the relevant data i...
Are you trying to do this a few times manually? Or are you trying to automate?If manual, I would...In your CSV import table, create a new column of type linked field. Choose your primary tableNext in your CSV table, click the header label above the p...
