i have this piece of codetry: # Step 1: Search for the record with the given unique ID print("stage 1") search_url = f'{url}?filterByFormula={{Part unique No 1}}="unique_id"' print("stage 2") search_response = requests.get(search_url, ...
Hi there.Can you help us solve this issue?After generating the GoogleDrive URL in GAS, we update certain fields in airtable API.The field type is “URL”.The code is below. I have already confirmed that the API URL, PAT, GoogleDrive URL and field name ...
I'm working with a client who has a seemingly simple requirement:"Send an email using Airtable data, then later reply to that email to chase the recipient - ensuring that the reply is in the same thread as the original"This is deceptively difficult t...
Could someone share the correct way to update a multiple select field using a script?I have one table where I receive data from form submissions. When a submission is received, I use data from the submission to update a multiple select field in a rec...
Want to:- Store a database of suppliers and their training records- Log their training and assessments- Create certificates- Create external views for assessors to update training records
There's an AT script called "find & replace." That's great - but how about if instead I find a string of text in a field, copy what follows up until a find another string of text (/BeginAddress Name, Street, City, Zip /EndAddress), then paste that s...
Do you ever wanted to query your airtable in SQL with no sync ? Now it is possible thanks to SQLify. Connect your airtable account, use SQL to query and create a PostgreSQL compatible DB. Would be happy to have your feedback, we are still in beta
I have an automation that runs a script to trigger a webhook in Power Automate. This correctly pushes the Expiring URL to Flow.My next step however doesn't work. PA seems to want a filename in the path URL. Airtable doesn't generate the URL like tha...
I'm using the AirTable API with Powershell, to lookup records in AirTable where a column value contains a special character ('#')For example, I'm trying to filter on AirTable rows for a Color column that contains a '#'.Let's say the Color value is 'A...
I'm trying to build an automation that uses a custom script to determine whether all necessary leads have been assigned to a record within the base. The teamsNeeded field (multiple select field type) determines the teams that need leads on the record...
| User | Count |
|---|---|
| 770 | |
| 624 | |
| 345 | |
| 232 | |
| 226 |
