Ask the Community

Hello, I'm trying to use airtable to email callers templated information about products. I have a grid view where I can enter an caller's email, select from product list (a, b, c), then use the Button feature to trigger a SendGrid email that contains information about the selected product that is retrieved from a lookup table (a - info text, b-info text, and so on). This all works very smoothly except I would like to create a Form to enable staff to use this process without having to interact with the grid view. So I would like to somehow automate the pressing of the "Send email with SendGrid" button once the Form is submitted/record created. Is there a way to do this?Thanks for any ideas you have.

Hello everyone, I’m running a speed dating business and would like to automate the matching system. What I want is the following. After the speed dating, each participant will receive an airtable form in which they can each select any number of participants of the opposite sex that they want to match. If Woman1 selects Man1 AND Man1 selects Woman1, then a formula must be triggered and I’ll then use zapier or the email block to send emails automatically with each other’s private info. Any idea on how to organize that ?

 I'm trying to add a link to a calendar event created by automation. I THOUGHT markdown would work, as per this article. But when I test the automation, it seems the markdown just doesn't do anything.Am I missing something painfully obvious?

Dear communityI need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.Basically: #Beløb F + #Beløb S = f BeløbCan anybody help?Uffe, Klassiske Dage, Holstebro International Music Festival

Hi everyone,I have a user who downloaded the .dmg from Airtable, but when trying to open nothing happens. the machine meets the system requirements, but the user is unable to even launch t to start the installation. Any ideas?

What should I do if there is no response to the completed Airtable Services Partner form? We filled it out more than once, wrote to the mail, but still no response(( Has anyone encountered this?

Apologize for this possibly simplistic question, but here goes:I want to create a field that is a Category, that based on the category value selected, will ONLY display a list of relevant Sub Category values for the selected category. EXAMPLE (Simplified)1.  I have a field that is Product Category - it has two values: Mobile, Home.2. If you pick Home for Product Category, for the Product Sub Category, I would want to display the Home Sub Category values. (Wireless, Wireline, Other services)3. To take it one step further, I would also like the Product Sub Category could have  Product Sub Category 2, that would show ONLY relevant values based on the Product Sub Category. (eg. Home > Wireline > 5G Router, 4G Router, Extender, etc.)Is there a way to set up a table to have this hierarchical relationship. Do I need to refer one table to another, etc.?&nbs

I have a group of freelancer reporting weekly on how many hours they worked on various projects. Im looking for a way (either through a view or interface) to see a report of how many hours are worked, by each employee, on each project, per week. 

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 Applicatio

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 i

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 ove

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

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.nam

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,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:</h

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 Airta