I need help creating an automation that runs when a form is submitted. This automation script needs to take field inputs from the form and pass them along to Zoho to create a calendar event. The important values are the title, creation date, user, an...
Hello, Recently I have got an excel with information about customers and their ordered products and quantities.I have added all the tables and fields in order to turn this information into airtable orders with line items.Is there a way to automate th...
Hi there,I have a series of quality assurance data for my Online School which has been populated using different google forms and is therefore stored in different google sheets. I am bringing the data into Airtable to use an interface to visualise it...
^ Sorry about that subject ... I don't know what I'm doing.So ... I have Table Vendor, and Table Transactions... the Name field in the Transactions table sometimes contains the same text as in the Vendor field (which is called 'Who' [i know ... awful...
Been trying to update a table (Table C for our example) whenever Table A and Table B get information without duplicating pre-existing records. I am hoping that I am able to do so simply through the automations in Airtable but so far im stuck since al...
Hi there I am hoping you can help me.I need to automate Clinician Fees in Airtable according to the Insurance company and whether the patient is a clinic (default fee) or practitioner's own patient (unique). Will it be easier to do an Automation o...
Hi,I currently have several dashboards for client fleets using Interfaces. On these I use the Field Summary to calculate the percentages of a fleet based on whether they are 'active' and within a servicing window. What I would like to do is automate ...
Hello, I've got a Base where each record is a person. I'm trying to create an automation that will share that record as a URL with each person (using their email address in one of the Fields), but not ALL the Fields in the record. I know I could manu...
Hi, non-dev hereI have been an avid user of Airtable and I'm enjoying it but there's some things like proper pivot tables and reports I wish were available.So anyway, I am currently trying to build a report that uses live data from one table to anoth...
Hi there, This might be something someone has already figured out in this community, however, I was unable to find anything - so it might be impossible with out some sort of script?To start this off I use Airtable for project and task management for ...
Background: I'm currently building a surfboard reservation system and have been running into roadblocks trying to stick to the free plan because I can't utilize the advanced calendar features. I have two tables currently, 'Surfboards' and 'Reservatio...
Would using this documentation: In the updated code, we first get the select field using table.getField(timeFieldName) and then update the options using the updateOptionsAsync method. We spread the current choices using ...selectField.options.choices...
Hi Fellow Community Members, I get these inventory summary sheets from my vendors that I first have to run a macro on in Excel to transform the summary to individual records to update my inventory in airtable. The sheets are for dresses so each row h...
We're exploring Airtable as a project management tool to be used internally and one of a must-have features is sending alerts to Slack or email, so that respective team members get notified when there is a certain change to the project status, activi...
Hi everyone,I'm using Airtable as a database for my microlearning platform, which delivers courses over messaging channels like WhatsApp. Each base in Airtable corresponds to a different organization, and within each base, there is a "Students" table...
Hello!I am somewhat new to AirTable and LOVE it! I'm currently working with the Pro subscription.I have a base where the first 2 columns (Primary Field and column immediately after) on a grid view carry through on all 7 tabs of the dataset. Each tab ...
I'm a new Airtable user and I'm trying to replicate some functionality I had in my previous spreadsheets integrated with Looker. I have two tables: Categories (with fields ID, Histórico, Categoria, subcategoria, and Centro de Custo) and Transactions ...
Hi Airtable community,My script is taking too much time to complete and going over 30 seconds limit. I would appreciate if you could review it and give me some tips. Here's the code:let emailSendersTable = base.getTable("Emails to clients"); let list...
What's wrong with this script? let tableName = "Table 1";let viewName = "Books (ChatGPT)";let openaiUrl = "https://api.openai.com/v1/completions";let apiKey = "sk-key";let table = base.getTable(tableName);let view = table.getView(viewName);let record...
I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the ...
