Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,658 Topics
  • 11,710 Replies
3658 Topics
A
AlexTNew Participant
posted in Development & APIs
Find Records for an invoice and group them for each invoice item (to be created in a separate table

Hi everyone, I want to use airtable as a CRM and activity tracking tool. My logic is: We are working on a project - project table Each project contains 1-n project items - project item table, each record linked to a project Activities are tracked on a project item level (date, effort, related project item) - activity tracking table, each record linked to a project item Now i want to automatically create invoices for my projects for certain invoice intervalls. For this i need to find all related activities (easy, also with an automation) and group them for each project item, in order to create the respective invoice items (tracked activities per project item within the invoice intervall). For this I have created a seperate “invoice item table” in which i currently also have a seperate automation, that gathers all activities for the respective items within the intervall. my core question is: can i combine and automate the necessary steps in a script? Find all activity tracking records (

60
A
J
Jens_Schott_Kn1New Participant
posted in Development & APIs
Using a script to add values from one field to another

Non-developer type here! My team is using Airtable as a task management tool Each week we run a report, which includes a long text field (“Details Field”) with details on the work performed on a specific task during that week. To retain a record of the content that’s appeared in the Details Field, I wonder if it would be possible to write a script that would copy and clear the values of the Details Field and cumulatively add them to a field (“History Field”). The History Field would then eventually contain a list of all the updates that’s been put into the Details Field over time (and ideally with date stamps to next to the text that was copied at a given time). Thanks so much for your feedback on this! Jens

6531
J
H
Heather_MarsdenNew Participant
posted in Development & APIs
Script or Feature that Would Allow a "Click to Show Password" Effect in a Field?

Hi everyone! I would like to have a Login Vault on Airtable accessible to a client, but for more appearance of security we’d like to have the Password field entries all show up as *********** and were wondering if there is a script or another way to allow a “click to reveal password” action or “click to copy” option if not the first?

102
Zack_S
J
Jerry11Inspiring
asked in Development & APIs
Use Button Field to Move Record from One Table to Another Table

Hi all, Hoping someone could help me correct a script. I have a base with multiple tables in it. There is a table called “Projects” and another table called “Potential Photoshoots”. I’m trying to use a script to move a single record from the “Potential Photoshoots” table to the “Projects” table. It should then delete the record from the “Potential Photoshoots” table. This all should happen automatically when a button is clicked. NOTE: The button field name and the button label are both titled “Move to Projects” and it exists on the “Potential Photoshoots” table. I’m new to Airtable and not very proficient with scripts, but I’ve been doing research and playing around to try and learn. I was able to work out the following script, but it doesn’t move the specific record whose button was clicked. From what I understand, that is because I need to use an input.recordAsync call. I think I understand where that should go, but it seems to cause other errors in the script when I add it. I also r

10612
Alexey_Gusev
K
Kranthi_KiranNew Participant
posted in Development & APIs
How do I get list of all the tables in a base

Hello everyone, I’m building an app that picks data from Airtable. All the listed APIs expect the table name as an input. I’m looking for an API to get a list of all the tables in a base. Is there any API, or any workaround for this? Thanks

44412
Hannah_Wiginton
A
Arwel_BrownNew Participant
posted in Development & APIs
Multiple Linked Records keep overriding

Hi guys! I’m attempting to fill in a field with linked records from another table. The values being entered are flight names based on flight confirmations. As flight confirmations go, they often have multiple flights on them. For some reason, even when using the method outlined in the scripting reference, my values are still overriding. Annoyingly, I can quite literally see this happening by watching the table after running the script - so I know the extra flights are going in the right place, they just don’t want to play nicely with all the other flights! The code snippet that’s updating the flights is below, hope someone can help! if (flights !== undefined && flights.length > 0) { // INSERT FIRST FLIGHT let updateRecord = await passengerFlightsTable.updateRecordAsync(record, { 'Flight Name': [{ id: flights[0].getFlightID() }] }); flights.shift(); // get rid of first flight so one-wayers are accoun

20
A
M
Matthew_ThomasInspiring
asked in Development & APIs
Using `UpdateFieldOptionsOpts` when updating field options

I’m trying to overwrite a Field’s options with a list provided dynamically from data that is imported. I have successfully updated the options to use the previous values in addition to the new set of values (similar to the example the documentation provides). However, the use case for my app is to start from scratch: delete all existing records (and ideally field options), and import a fresh set of data with field options that match the new data. The documentation points to UpdateFieldOptionsOpts as a way to do this, but after trying a few combinations, I have not gotten it to work. Any thoughts from the community on what I might be doing wrong? Here is some sample code to demonstrate the issue: let choices = { choices: [ {"name": "Option 1"}, {"name": "Option 2"}, ] } if (field.hasPermissionToUpdateOptions(choices)) { await field.updateOptionsAsync(choices, {"enableSelectFieldChoiceDeletion": true}); }

530
M
M
Martin_WrightNew Participant
posted in Development & APIs
JSON POST headers

In a fetch for JSON POST adding these two headers: let response = await fetch(url, { method: 'POST', body: JSON.stringify(data), headers: { 'Content-Type': 'application/json', 'Accept': 'text/plain', } }); returns a TypeError: Load failed message. But the target API needs both headers specified. Each header individually does not error, but the API doesn’t respond. Any help appreciated.

81
M
P
Pedro_PaisKnown Participant
asked in Development & APIs
Outputting specific fields in table

I’m trying to test a very simple script, but I can’t seem to output specific fields to a table, no matter which fields I specific in selectRecordsAsync, the output is always the same: fields id and name. My code: let table = base.getTable("Procedimentos"); let query = await table.selectRecordsAsync({fields: ["Procedimento","Descrição"]}); output.table(query.records); What am I missing?

151
kuovonne
S
Sched_kodeParticipating Frequently
posted in Development & APIs
How to use script to send record to stripe

how to use script to send record to stripe? who can

20
S
J
Jesper_HolmstroKnown Participant
asked in Development & APIs
Deleting row with button script in a task list

Hey everyone Having a bit of problems with this script. I have a tasklist and at the end of the record I have a delete button. When I press the button I want it to delete just that record. But when I use this script it seams to delete just any of the records in the list except the record I want to delete. Can someone pls advise? // Delete a record in the Tasks table let table = base.getTable(“Tasks”); let query = await table.selectRecordsAsync({fields: }); let recordId = query.records[0].id; await table.deleteRecordAsync(recordId); console.log(“Deleted a record!”);

161
Justin_Barrett
A
AmirHesam_PiriNew Participant
posted in Development & APIs
Jalali Calender

anyone know how to use jalali calender in scripting app airtable?

121
Justin_Barrett
J
John_QNew Participant
posted in Development & APIs
Access Record Activity / History

Is there any way to access the history/activity on a record I’m looking for a way to see the rowActivityInfoById for a record so I can audit what fields are being changed over a certain time period. I’m ok with coding it up, I just need to know I can retrieve the activity anywhere. Any help would be much appreciated.

2667
J
A
AmirHesam_PiriNew Participant
posted in Development & APIs
Jalali Convert date in scripting

I want use scripting app for convert gregorian calender to jalali calender. I have a field named as ''date" for Gregorian and an empty field named as"Jalali" for result of code. for convert I want use of this code: // let day = new Date().toLocaleDateString(‘fa-IR-u-nu-latn’); console.log(day); // But I don’t know how to put field names in the code! and also I want the result, entry in jalali field.

101
Alexey_Gusev
H
hayden_mitchellNew Participant
asked in Development & APIs
Update a certain field identified by a variable

Hello! I hope this is a simple question for you all, I need to be able to update any field with a certain value. is there a way for me to make the field name that I want to update into a variable so I can change which field I want to edit? var varField = 'fieldnameOrID' base(TableHere).update(RecordHere, { varField: "done", }, function(err, record) { if (err) { console.error(err); return; } }); this is something like what I would want to do. any help?

67
H
R
RSkInspiring
posted in Development & APIs
Unable to fetch record using filterByFormula

Hi, I have written a function that fetches the table value based on the table name and primary field number = Uf79266972d007f2a3886bf73676860 async function sendContent(number, studentTable, contact) { const records_Student = await base(`${studentTable}`).select({ filterByFormula: `${contact} = '${number}'`, view: "Grid view", maxRecords: 1 }).all(); var td = await totalDays(number, studentTable, contact) records_Student.forEach(async function (record) { studentName = record.get("Name") console.log("Name = ", name) }) } sendContent(number, "Students", "UserID") It gives the following error AirtableError { error: 'INVALID_FILTER_BY_FORMULA', message: 'The formula for filtering records is invalid: Unknown field names: uf79266972d007f2a3886bf73676860', statusCode: 422 } But, If I pass number as 50373. and call sendContent(number, "Students-2", "ChatID") It retrieves the name successfully. Any idea what is causing this issu

333
Justin_Barrett
G
Geoff_BrayshawNew Participant
posted in Development & APIs
About adding two markers to Map using 2 postcode fields

Require Map script to add two markers from two separate fields in table. Im successfully using the script Add image from Google Maps This script populates an attachment field with an image from Google Maps using a field with an address

10
G
S
ShinKuNew Participant
asked in Development & APIs
My RegEx is not working in the String.Search function

Hi, I would like to ask what is wrong with this script below. What I’m trying to achieve is search a particular word on a given string and make sure that the word is not misspelled by not having any additional letter or numbers at the beginning or end of the word (Special characters are allowed. Case sensitive search). What happens with this script is, it fails to search for the given word even if nothing is added before or after the word. I have tried my RegEx on online testing tools and it actually works fine. If you guys know any alternative for my scenario please do let me know! Thank you very much. let subcategoryName = currentSubcategoryRecord.name; let keyword = new RegExp(`[^a-zA-Z0-9]${subcategoryName}[^a-zA-Z0-9]`); isProductTypeExists = checkRecord.search(keyword); if (isProductTypeExists == 0) { //Product exists! } // -1 is returned for no match found.

203
Justin_Barrett
S
Saksin_CCMNew Participant
posted in Development & APIs
API Error on " filterByFormula "

Today Airtable give me error on “filterByFormula” it was working fine earlier. Anyone had same problem like me.? reply : Error parameter validation fail Thanks.

135
kuovonne
A
Airtable_admin11Participating Frequently
posted in Development & APIs
TypeError: newRecordId.getCellValue is not a function

Hi all, I’m trying to link my a “parent” record to new created records in a script following this source. But I keep on getting the error “TypeError: newRecordId.getCellValue is not a function”. The code can be found under " /Link the new record (child) to the parent record/". Thanks for the help in advance… it’s very much appreciated! let inputConfig = input.config(); let table = base.getTable('Progress General Indicator 🚫'); let projectsTable = base.getTable('Projects 🖌'); let indicators = inputConfig.linkedIndicatorIDs; let projectID = inputConfig.projectID; let recordID = inputConfig.recordID; let linkedIndicators = inputConfig.linkedIndicators; /*Create new records (children)*/ for (let indicator of indicators) { console.log(`Adding indicator ${indicator} to the new record.`); console.log(`Adding project ${projectID} to the new record.`); let newRecordId = await table.createRecordsAsync([ { fields: { /*'Projects 🖌': [{id: p

176
Alexey_Gusev
Y
Yonatan_LangerKnown Participant
posted in Development & APIs
Script Coding - Project/Task Creation Script Example

Hi everyone, I found this very good script template, and need help with some adjustements please. “Collaborators” used to be a dependency field, called “Followed By”, but I would like to use this field rather to assign collaborator names, that are stored in a separate sheet called “Collaborators”. The purpose of the Base is to automatically assign tasks and collaborator names to classes. Here is the code: // when a new asset is created, // there are a certain number of tasks that must be completed // these tasks are dependent on the type of asset // Given a list of project and task templates, // when a new asset is created and has a project template assigned // we can then create corresponding set of tasks for that asset // define some of our initial variables // these are the basic table, field and view names to define to create the script const project_table_name = ‘Classes’; const new_project_view_name = ‘New Projects’; const project_template_link_field_name = ‘Project Template’; co

22
Y
V
Vihar_KuramaNew Participant
posted in Development & APIs
Appsmith - Open-source, Low-code Platform for Building Internal Tools, Crud Apps, Dashboards, and More - Now Ships with Native Airtable Integration 🎉

Hello there, I’m Vihar from Appsmith, and I’m here to share a major update on Appsmith’s latest release (1.7.10) with the Airtable community. Today, our integration with Airtable comes out of beta and is available for everyone :tada: ! You can now build custom UIs and interact with applications built on Airtable with minimal configuration. Appsmith is an open-source framework to quickly build any custom business software like admin panels, internal tools, dashboards, and more with pre-built UI widgets that connect to any database, GraphQL or REST API, controlling everything with Javascript. While it is possible to use the default API interface to connect to Airtable, we wanted to make it easier for you to directly connect to your Airtable account and create applications faster than ever. This new data connector introduces several features: Integration is located in the “Datasources” section. Connect to your Airtable account with either an API Key or a Bearer Token (OAuth 2.0). Cre

241
J
R
Ryan_MizakParticipating Frequently
posted in Development & APIs
AirTable Script

I am trying to create a script in Airtable to give me the sum of a row in a table, but I am new to JavaScript. Any help would be most appreciated, thank you

119
Kamille_Parks11
G
GJ_SequeiraNew Participant
posted in Development & APIs
Adding Tasks from one Table into Another Table - field labeling

I’m using code found from this post and am struggling to figure out how to get past an error of “Error: Field “fldJl8IjqgJizFULv” cannot accept the provided value. at main on line 29” The goal: Separate a list of records into separate records to input into another table along with assigning fields of “Projects” and “Status” What I’ve tried: I’ve performed the script successfully with creating a record with the task name for each task, but when I try to define other fields I end up getting the error mentioned above. Here’s my code so far. Any help is appreciated! I’m so close to getting this, just need a bit of help to the finish line console.log(Hello, ${base.name}!); let inputConfig = input.config(); console.log(The value of ProjectType is ${inputConfig.ProjectType}); console.log(The value of ClientName is ${inputConfig.ClientName}); console.log(The value of TaskName is ${inputConfig.TaskName}); // pick tables from your base here let projects = base.getTable(‘Projects’); let tasks = b

205
TheTimeSavingCo
D
Deron_WitmerNew Participant
posted in Development & APIs
Scripting - Get Selected Record

We’re using a view to contain company distribution groups. When a user filters into view, I’d like to add the Active Directory user with that email address to a given M365 group. All I need to be able to do is grab the email address off of the selected record within the script > HTTP call. Is it possible to get the selected record (the record that filtered through and caused the automation to happen) so I can provide the email address off of it to my Power Automate flow?

1304
Alexey_Gusev

Badge winners

Show all badges
Terms & Conditions