Ask the Community

Hello,I'd like to ask for help in troubleshooting an automation. I built an automation that works correctly when I "Generate a Preview". BUT, when I go to actually use it, the automation does NOT work. I.e., it does not update my live/active Base in the same way that it updated the Test Record. Actually, it appears to have done *nothing* to my Live Base, lol. Is this a common issue???Specific Context for my Automation:Table 1 is "Applications" where Client Application Forms are received. Table 2 is "Sessions" which lists all of the available time slots for Applicants to sign up for.Table 3 is "SignUps" where SignUp Forms are received indicating a specific Application # is signing up for a specific Session. When someone completes a "SignUp" form it automatically includes the Session they're choosing as well as their Application # (through a Prefilled URL). I want the automation to add the Application # from the SignUp Form to the Sessions Table to finish the circle of Applicat

I am attempting to create a SignUp Page in Airtable. My current iteration is live at this link. The form does meet the basic requirements I have, BUT the design/UI is lacking, especially the "Select Your Session" drop down.Is there a way I can change the "Select Your Session" into a Grid View, List View Interface, or even a Radio Button List within this form? Context: I'm trying to accomplish the SignUp process on an Airtable form because in addition to giving people a list of time slots to choose from, it enables me to prefill the guest's application number on the form (and hide it from the guest). This means the guest's application will be automatically linked to their session when they submit the SignUp form.I don't know of any other way to accomplish this because, for example, an interface doesn't allow me to prefill the guest's application #. Ideas or input welcome! TIA,ML

hello,How can I create an interface from an Airtable list view?  

Using the NOW() function in a formula no longer updates the time reliably, even after refreshing the base. It only returns the original time that the formula was created, but then it doesn’t update reliably beyond that. I’m specifically referring to a formula that just has this as its formula: NOW() I’ve noticed that within the last few days, this brand new disclaimer was added to the formula reference page for both the NOW() function and the TODAY() function: ***The results of this functions changes only when the formula is recalculated or a base is loaded. They are not updated continuously. Forget that this sentence has several grammatical errors in it. :stuck_out_tongue_winking_eye: The real problem is that the described behavior is incorrect. (And the behavior has changed on us.) I created this formula: NOW(), and it starts off with the current time. But then, I refreshed my web browser over a period of 5 minutes, and the NOW() formula didn’t refresh at all. Then I re-read the

Hello we ran a survey over a few weeks and are wondering if it’s possible to know/sort by the date on which the survey was taken. We did not ask people to enter date manually, there is no date column - we assumed it would be recorded automatically.

Hey folks,We are implementing Airtable OAuth integration, and we are getting the following error: You have reached the maximum access authorizations for this integration. You cannot authorize this integration again until you revoke at least one of the authorizations Is there public documentation and explanation of this error? --Artur

Hello community, I have an automation that informs the user by e-mail if the deadline of a task is before the start date. Unfortunately, in my opinion, it is not possible to set a dynamic validation for fields that would prevent this.However, if the user wants to move the timeline for the task, he usually changes the start date first and then the due date. this triggers the automation. Does anyone have an idea how to prevent this? best regardsMirko

I am using Airtable to create an advanced social media calendar. It is used to manage 150 social media accounts - each account corresponds to a specific university.A student submits a form with pictures and a caption that they would like to have posted on their schools account. When the form is submitted, a record is created in Airtable. All records for all schools go into the same Table and are tagged with the school on which the content should be posted via a linked record. There is a second table that has the list of all of the schools.I would like to create a function or automation that assigns each record with a date and time to be posted. Each school instagram account can only post 5 records per day - for example one at 10am, one at 12pm, one at 2pm, one at 4pm, and one at 6pm. The function should be able to assign each record with the next available posting slot for that school. The posting times should also be determined per school, via the list of the schools in a separate tab

Hi all,I find it very strange that whenever I'm using the Gmail integration to send emails, when being received by the recipient it doesn't come up my name, instead it comes up the email address as the senderAnd when configuring the Send Gmail Action I don't see a field for "From"has anyone else accounted this problem?or know ow to solve it?Thanks

Hello all, I’ve been updating a Record in a Linked Table to point to a different Main Record using the below code; let _ins = input.config(); let main_table = base.getTable("Main Table"); let linked_table = base.getTable("Linked Table"); let main_rec = _ins._get_record; let linked_rec = _ins._get_linked_record; let linked_val = _ins._get_linked_value; console.log(`main_rec: ${main_rec}`); console.log(`linked_rec: ${linked_rec}`); console.info(`linked_val: ${linked_val}`); if (linked_val == "Not Listed") { console.warn("Not Listed - Clearing and rewriting entry"); await linked_table.updateRecordAsync(`${linked_rec}`, { "Linked Text": `Example updated ${linked_table} record text`, //"Main" : [{id:`${main_rec}`}] //Field is updated with expected record via recordID "Main" : [{id:`${""}`}] //Attempt to clear field is not working... }); console.info(`Updated Table "${linked_table.name}" record ${linked_rec} with "${main_rec}`

Good day.Looking to add to an existing form where we can rate each proficiency without having to create a field for every proficiency like this.  Typically, yes, there'd be a field for each proficiency with a single select, but does anyone know if there's a native Airtable way of doing the below?miniExtensions isn't an option right now. Thanks

I was trying to set up an automation that after 5 minutes of a scheduled date and time in a record email the person of the record but I can't find that option in the automation list.

Hi All! For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  I see that airtable automatically pushes out all dependent tasks automatically if a predecessor task is delayed (this is great!) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. Is there a setting or bit of automation I can add to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! Jack

Hi, Does anyone have a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depending on eg ISIN, etc. I just found quite old posts and only one newer video (How to Track Stocks in Airtable - YouTube), but the script link in the video is outdated… So any help with providing a script, etc. would be highly appreciated. thanks a lot, Chris

Hi,I want to have in one column the data from the remaining selected text, lookup and line items, fields which will be formatted in html. I managed to partially achieve the desired effect, by using the formula type But unfortunately data is not presented correctly. This is my formula. <li-code lang="markup"> "<table><thead><tr><td>Składnik</td><td>Zalecana dzienna porcja do spożycia: " & zdd_pl &"</td><td>*%ZDS</td></tr></thead><tbody>" & "</tbody><tfoot><tr><td colspan="&"3"&">*%ZDS - Zalecane dzienne spożycie. | † - Nie ustalono zalecanego dziennego spożycia.</td></tr></tfoot></table><h3>Składniki:</h3><p> " & wszystkie_skladniki_pl &"</p><h3>Alergeny:</h3><p><b><u>" & alergeny_pl & "</u></b></p><h3>Stosowanie:</h3><p> " & sto

I have 2 tables (Table 1 and Table 2) in a base (Base B). I have created 2 automations, the second one is not working.The records are created in Base A - Table 0 and synced to Base B - Table 1, so Table 1 is a synced table. The first automation works: When a record enters Table 1 (view X), a record is created in Table 2. The second automation doesn't work: when a record is updated in Table 1 (view X, all fields), update the record in Table 2The error is: The record does not exist. I wonder whether the problem is the fact that its a synced record. The record IDs in Tables 1 and 2 are exactly the same, but Table 0 shows a different one.Would anyone know how to fixt it? Thank you in advance. 

I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference between the displayed time and my computer clock.Weirdly, when I first set it up but hadn't yet changed the time zone from GMT, it was 2:59 a.m. but the field showed 6:03 a.m.Is this a known bug? I need this field to calculate the difference between when an item is due and the current time (that is, how many days/hours until it's due), and the time does need to be accurate to the minute.

I highly suggest adding Multi-Trigger capabilities to Automations. This would enable users to require multiple Trigger rules to take place in order for an action to run. To optimize this functionality, users should have the option to run their automations in three ways: Only if ALL trigger rules are true If ANY trigger rules are true If custom formula is true (i.e.: IF TriggerA and Trigger B are true, OR IF Trigger A is true and Trigger B is false…)

We are currently using Airtable with WATI. We aim to streamline data collection, particularly about crop information and pricing. However, we are facing a specific challenge that we hope the community can help us address.We are creating an Airtable form where our team members can input data such as the type of crop and its corresponding price.Scenario: Imagine filling out the form, and they want to add information for more crops than the initial form offers fields for. Instead of having to predefine a specific number of fields for crops, we want users to be able to click a button or use a similar feature to dynamically add fields as they need them.Questions:Is it possible to dynamically add fields while filling out an Airtable form, or through a user-friendly feature like a button?If not, do you have any recommendations or workarounds for achieving this kind of dynamic field creation within Airtable forms?

I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% and for less than -5% but it won't score the percentages less than -5%. I've tried at least 4 variations on this and can't get it right. Does anyone know what I'm doing wrong?

I am using softr as my front end for airtable. I have about 200 users on softr, and I want each user to be able to see their overall "performance" metrics for themselves only on softr. I don't like the data visualization tools on softr as much as airtable. Is there a way to specialize the airtable embed interfaces so it filters the data to only be the email of the person logged in on softr?

Revenue = Quantity * Price7496.90 = 150 * 49.98Why is the number rounding up to 7497.00????Another Example: $205.80 = 25 * $8.23The value I get in my Revenue Cell is rounded down to $205.75.Here is the revenue formula vs. what it should be. The numbers are rounding weirdly.  

We are a publishing company and we publish individual pieces of content on multiple dates.  I have a different sheet that I'd like to have all of those dates be put together into 1 cell (see attached). Is there a way to do that so that if I fill in a date in the "Publish Date 1", "Publish Date 2", etc. cells, that it will automatically add them into the column on the far right that is referencing another sheet?  I did it manually in the attached screenshot just to show what I would like to happen. Thanks in advance!

Hi there, I am trying to use an automation with the following setup : Trigger : When a record is created (in Table 1) Action 1 : Find record (in Table 2), where Name = Field 1 from Trigger Action 2 : Update record (in Table 1), with Record ID = Airtable Record ID from Trigger In this action 2, I am trying to update several fields using field values from Action 1. However, I noticed that the automation is only working when ALL fields from Action 1 used in Action 2 are not empty. If at least one of these fields is empty, the automation will fail with the following error message : Failed to construct the value for “Fields”. I suspect that the Find Record action only bring fields with non empty data and ignore the others. Is it the expected behaviour ? Any workaround that doesn’t involve creating a formula field for each field that I am trying to get the value from in Action 2 (because I really have a lot of them) ? Thanks.

i have gotten the same error message several times in a row: Microsoft reported an error while processing this action:Microsoft may be experiencing issues with their API Any ideas on how to resolve this?