Ask the Community

Hello, I am starting with Airtable Scripting.I need to use the content of two cells as input text for a function that formats the text in a specific way.Using this way I only get the value of the first row [0], but this needs to work for every row. It is triggered once a row is added and/or modified.   if (record && record.records.length > 0) { const inputText1 = record.records[0].getCellValueAsString("Index"); // Replace with the actual field name const inputText2 = record.records[0].getCellValueAsString("Script"); // Replace with the actual field name // Combine the content of the two cells const inputText = inputText1 + "\n" + inputText2; const jsonOutput = convertToJSON(inputText, sentencesPerSection);​ 

I published an interface and when I open it in Chrome on an Android smartphone everytime I scroll with my thumb, the detail page opens and makes it impossible to bite the entire list.Records should only open when tapped, not on a swipe!

Hi, Currently I use Airtable to send emails. Is there a way to track if Email has been opened? Also, is it possible to update row field if email was opened? E.g. adding :white_check_mark: if was opened to field Thanks for the suggestions!

Hi again,everyday I love more and more Airtable! I had to admit that... 🙂But... I stuck on KEY function of builded app... KEY FUNCTION 🙂I have a list with products, min/max are numbers, and defining working range for product:name | min | maxabcd | 100 | 200efghi | 145 | 455......I have to add a search field in interface where user can type a number, and table will be filtered to products in range. For example typing 70 - gives no results; typing 120 - gives abcd; typing 190 - gives abcd and efghi.HOW TO DO THIS?If not in Airtable - can you recommend any no code tool for building this (with Airtable as backend).RegardsTomek

Hey guys,Just trying to work out a simple Formula to create a day count until a certain date (based on one of our fields) without including weekends. For example. We have a customer due date for an order which is put into a field, just wanting to have a field that calulates how many days we have for production until that date. So far I have: DATETIME_DIFF(  {Due Date},  TODAY(),  'days')Which works fine but is including weekends. To combat this, I did try:WORKDAY_DIFF(  {Due Date},  TODAY(),  

hi, when i use the field #number, the number always look like this 1.00but i i want to put my numbers as 0.01 how can i do that? because everytime i put 0.01 they change it to 10 

Hello,I program a film festival and we use Airtable to organize the submission we receive. This year we have two different programming teams that should watch half of the submitted projects. I wanted to create a formula that would calculate the total of duration of the films (we have a field for the duration in HH:MM:SS), divide it in half and then assign each half for team A or team B. Is that possible? I have tried to add some simple SUM formulas but I'm still a beginner in all of this. Thank you!

I have a shared table that is accessible to users who are not using Airtable. They can view the table using the link I provided without any issues. Within this table, there's a "notes" column where I want to refer to another record by saying "please see here," with "here" being a URL link to another record.As an Airtable user, I can click the link and access the other record, but non-Airtable users encounter a block. They are prompted to request access to the entire database, which I'd like to avoid. Is there a way for non-Airtable users to access the record URLs in the comments section without the need to create a new column for linked records?

Hi Community,I'm trying to purchase a Teams account but I am part of an entity that is not allowed to pay taxes. The form I'm sent to has a space for a credit card and says I'll be charged "applicable taxes". I'm not actually sure what happens when I hit 'submit' after entering a credit card, is it charged then or is there some other page I get sent to? I expect the former.Is there a way to pay for Airtable without paying taxes?

I’ve created a gallery view that I want to embed in a company intranet page (SharePoint). I want people to be able to see the values and click on the links and buttons that I’ve included, but I don’t want them to click on the record and have it open, as this will likely confuse them and it shows information that they don’t need to see. I’m guessing the answer is no at this point, but is there any way to disable opening the records? If so, can the clickable fields still work?

Is there a way to set up Pitchbook and / or Asbhy integrations or APIs with Airtable? If so, any recommendations on what's the best way?

If I upgrade, When would it be effective? right away? or will I need to wait till the next billing date.The support are not responding on the email :), so, your assistance is greatly appreciated!

I am looking to remove the comma separating the two lists. Here is a picture to show an example.    Is there a way to do this?Thanks!

Does the Desktop version of Airtable allow me to save files to my computer instead of everything saving to the cloud?

Hello everyone,Trying to come up with a formula using Chat GPT (and some tweaking) to create a formula field type that displays a subscription's (record) amount in a cell based on budget status and the payment schedule.I want to create a formula that checks the following conditions:The Payment Schedule is "Annually."And one of the following is met:a. Budget Status is "Projected" and Renewal Date is within the specified range.b. Budget Status is "Actual" and Purchase Date is within the specified range.If these 2 conditions are met, it displays the {Subscription Amount}. If none of the conditions are met, it will display "Conditions not met".Here's the code:  IF( AND( {Payment Schedule} = "Annually", OR( AND( {Budget Status} = "Projected", {Renewal Date} > DATETIME_PARSE("2023-01-01"),

HiIn my base I have a very simple table, the records primary field is a number, each new record is the previous number plus one. All the other fields are formulas or links to other tables that fill in automatically. Each week I need to create a new record in this table at a given time, I want to do this with an automation. I want to find the most recently created record (not recently updated as other fields will update at different times) find the name of the record +1 to it and name the new record that value. Is this possible? Maybe with a script, which is a bit beyond me. I can't seem to figure out a way to do it. Thanks for the help.

There are two tables and two automations involved in a workflow.1. When a record enters a view in the first table(the sync table), it will be updated in the second table (1st image)2. When a record is updated in first table(the sync table), it will be updated in the second table (2nd image)Both automations find a record where Ticket No. contains IDAn issue is there is an error from both automations (see an image below). The record is found by mapping Ticket No. with ID, but not updating.However, many of records are run successfully with the automations (meaning most of the records are found and update to the second table). Only few rec

I have a base in Japanese and want to use Japanese field names but when I tried to put together a formula, it does not work.  Is there a work around for this issue?

In my "CRM" database, I am building out a reporting table that gets rollups of IDs from other tables (i.e. interactions, etc) and am trying to get one array of IDs that I can count to determine the number of unique IDsInteractions TableOne to Many Contacts, lookup field of Contact Record IDs from "Contacts" TableProjects TableOne to Many Contacts, Lookup Field of Contact Record IDs from "Contacts" TableReports TableRollup of Contact IDs from Projects, Rollup of Contact IDs from InteractionsMy formula below doesn't get all the IDs. I don't know if maybe there's some nesting going on. Any suggestions for combining these arrays? properly? COUNTA(ARRAYUNIQUE(ARRAYFLATTEN({Interaction Contact IDs}, {Project Contact IDs}))) Each of my rollups in Reports has this formula ARRAYUNIQUE(ARRAYFLATTEN(values)) 

I'm using the Airtable API to create a new base and a new table (called 'Raw Data') within it. All of my singleLineText fields are working fine, but when I add a final field named 'Last Modified' with a type of lastModifiedTime, I get this error back from the api call:error: {   type: 'UNSUPPORTED_FIELD_TYPE_FOR_CREATE',   message: 'Invalid options for Raw Data.Last Modified: Creating lastModifiedTime fields is not supported at this time'}I haven't been able to find anything in the API docs or by googling about this. I would appreciate any help.     Thanks,     Rob

Hi,Looking for some guidance.  In a record, when you select the print view option, the view seems to have shrunk and now the fields overlap.  I know you can use a print extension but we use the print view option in the early stages of creating records for review purposes.  It has always worked before.  Is this a bug?  

I have a base with two tables: the first is a basic table with a list of records that change somewhat frequently. The second table has a multi-select field whose options should be whatever records are in the first table-view.I'd love to have a script that goes to the multi-select field in table 2, deletes all of the options in it currently, and then replaces the options with the records in table 1. The idea would be to put that script in an automation that runs once a day at midnight, ensuring the options in the multi-select field are always up-to-date.Any idea how to write this script?

I am going crazy trying to narrow down this error. I'm trying to automate payment creation based a date, number of payments, amount, and a linked record. I will eventually layer in frequency as well. Below is the code that I currently have but I keep getting ReferenceError: table is not defined at main on line 12.   let settlementPaymentsTable = base.getTable("Settlement Payments"); let config = input.config(); let numRecords = config.numRecords; let dueDate = config.dueDate; let paymentAmount = config.paymentAmount; let matter = config.matter; // Function to create a new record function createRecord(settlementPaymentsTable, dueDate, amount, matter) { // Create a new record with the due date, payment amount, and matter ID let record = settlementPaymentsTable.createRecordAsync({ 'Due Date': dueDate, 'Payment Amount': amount, 'Matter ID': [matter] }); } let i = 1; while (i <= numRecords) { // Create a new rec

My vendor requires me to use JotForm to submit new client data and then returns a copy of the completed form to me along with a PDF of the same data. I need to enter that same data into Airtable and wonder if there is a way to scrape/import that data from the email or PDF sent to me from the vendor.

I want to make it simple for users on my CFL prediction website to search through my Airtable content. I'm considering using the Search app. Is this the right choice, and do you have any tips for setting it up effectively?any Idea?Any help is appreciated!