Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this g...
Thanks @openside for your famous post "New Script: Same Table Linked Records Backlinks".Is there a way to use this in automation so that whenever the Parent task is updated, the child task runs? How would you need to modify the script?
Hi,Looking for some scripting help. I am manually copy and pasting values from a Lookup field to a Multi-select field on the same table and want to know if there is a way to create a script that could do this process for me. Example below:Want to co...
Hello Airtable Community,I'm working on a script in the Airtable Scripting App that processes a table with 1700 records. The script is designed to fetch records from the table, generate tracking links using the Impact.com API, and update the records ...
Hi, I am trying to find a workaround to Airtable's limit of 20 syncs coming into one base at a time. I have two bases, and I would like around 30 tables from the first base to sync with the second base. Can anyone recommend the best approach, in ligh...
Hi there,I am trying to figure out a way to automatically select linked records via another field.I have two types of records:Property listings that are in a project(condo building or gated community) and listings that are NOT.Project properties I'm ...
Hi allI've just got into scripting, and have fallen at the first hurdle. I thought this would load an array of all my records as objects, with each field in the object with its value as a a key value pair. let table = base.getTable("Contacts");let qu...
Hi folks,I have a dataset that I want to import into a CMS for blogging.In order for it to import and display correctly, the field in Long Text needs to be in Markdown - Code Block format so that it can hold a large chunk of HTML rich text.Is there a...
Hi all i am struggling with uploading woocommerce image from airtable url. Now airtable doesnot provide ".png" on the url.Is there any ways i can upload it using REST api curl method?
My team of 7 disciplines uses airtable, each having their own base. Each discipline has the same structure, but different syntaxes to describe their tasks. Every time I create a new tool or script I have to set it up in each base. I could really ...
I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by a...
HelloI am developing a Airtable Script and I am looking for extracting actual file object which is part of the attachment field in a table. I got the object using record.getCellValue("Attachment field"). This object has information like URL, Filename...
Hey everyone,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 fr...
Hi all,I'm trying to get the sender's url (within a strip) for an incoming webhook call so that I can response to call only from a specific domain. I'm wondering how do i do that? Thanks!EDIT Feb 24: I also need to get the sender's url for other re...
I am receiving a cryptic error when attempting to create a record using the code below:// Change this name to use a different table let table = base.getTable("Touchpoints"); //let ctable = base.getTable("Contact"); // Prompt the user to pick a recor...
I am attempting to setup a workflow for a Callback system for my Sales calls. My plan was that when a record in my Callback List View inside my Touchpoints table was updated to have the Call Result column be set to Voicemail select - that it would au...
Hi,The following code crashes and I don't know why: let table = base.getTable("Touchpoints"); let cTable = base.getTable("Contact"); let record = await input.recordAsync('Select a record to use', table); let callBack = await input.textAsync('Wha...
I am creating a new record triggered by a script with the following code: let newRecs = {};newRecs[0]['id'] = 'recDYGIT7fj80tTAH';await table.createRecordAsync({'Start Date/Time': billTillDate,'Contact': newRecs,'Notes': 'New Record note'});I am gett...
I will be processing a very large number of social media posts in both image and video format. Due to this I will inevitably run into storage issues very quickly. I have image URLs set up like this within my table:https://ik.imagekit.io/sq64zigvs7/tr...
What are the acceptable colour choices for single/multi selects in scripting?I've been creating new fields via a script and now I want to make a multi and single select, which is fine, I can do that much like so: await table.createFieldAsync("new", "...
