Ask the Community

  Hi folksI am fairly new to automations so plz excuse my lack of expertise.I am working on an automation that requires copying some data from 1 table into another table in certain circimstances.One of the columns (DISCONNECT_PROMPT) is of single select type - both in the source table as well as destination table.I am using the below code to insert the data but the it fails when the single select column is empty/blank in the source table.Can you please help me identify a way to insert a nothing if the source field is empty?Thanks in advance await tabChangeHistoryLog.createRecordAsync({ 'ROUTING_PROFILE': airTableKey, 'PRIMARY_Q (Mandatory)': strPRIMARY_Q, 'PREFERRED_ROUTING_ELLIGIBLE (Mandatory)': {name: airTableRecord?.getCellValueAsString("PREFERRED_ROUTING_ELLIGIBLE (Mandatory)") || "TRUE"}, 'PREFERED_AGENT_SCORE (Optional)': intPREFERRED_AGENT_SCORE, 'LC_EXPIRATION_THRESHOLD (Optional)': intLC_EXPIRATION_THRESHOLD, 'IN_Q_REFRESH_RATE_IN_SECONDS (Mandatory)': intIN_Q_

Hi Everyone,I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I can see for example March 2024, how many future months I have in cover based on current SOH and the figures in the outbound forecasts.Thanks! 

I want to create a chart that shows record counts of a table over time.  In our case, we have a table of clients and want to show how the total number of clients has changed over time.  I have a "Created time" column and I can use the COUNT formula to get the current number of clients, but I'm not sure how to get that COUNT over time.Any ideas?

We have been using the free version of Airtable for awhile and wanted to upgrade our account to paid to allow for more boards. The creator of the account is no longer with our organization and we don't have access to that email address. So when we "request an upgrade" it goes nowhere and we are stuck.I have emailed support numerous times, emailed Sales numerous times and I am not getting any response. If Airtable only responds to accounts that pay - how can customers who don't pay right now upgrade? We are in an endless loop of having no answers.

I want to change the name of a selection in a single-select field. When I went to do that, the warning of all that will be affected came up: 2 syncs, 12 interfaces, etc. My question is, will this mean I need to go make changes to all of these or will it automatically happen? I'm hesitant to try it w/out knowing the consequences as it affects a great number of things, including automations that a developer set up for us. 

Hi community,I have a formula to combine emails from multiple columns, that generally contain multiple linked records (but not always).  This REGEX formula works really well for the first 3 columns, but is failing on the final.  Any help on what I'm doing incorrectly would be greatly appreciated!Goal: string together a list of email addresses from multiple columns, with a "comma" between them, but if a column is black, don't add ",". Current Formula is: REGEX_REPLACE(CONCATENATE(IF({Moderator Email}, {Moderator Email} & ", "), IF({ADM Primary Email}, {ADM Primary Email} & ", "), IF({Other Panelists Email (Primary)}, {Other Panelists Email (Primary)} & ", "), IF({Other Panelists Alternate Email}, {Other Panelists Alternate Email}) ), ", $", "" ) For some reason, the last {Other Panelists Alternate Email}. is not comma separated.  The result merges all 3 user emails into one long strain...... 

Is it possible to automatically submit a form? I’m creating a series of links that have the form input prefilled. Each can take me to the form with the info I want ready and waiting (which is terrific). At that point I have to click Submit. I’m using this for class attendance, so it’s a quick rundown of 25 entries at a time. It would be ideal to load the prefilled URL and have that submit automatically. Is that possible? TIA, Nathan

I have a requirement to embed the airtable form in our website and redirect to a url when the form is submitted. However, when clicked on submit button the redirect url is blocked by pop-up blocker(enabled by default on websites). I used the sandbox attributes but still no luck. Am able to open the form in a new tab but that’s not my requirement. I would like to embed the form in my current page. Is there a workaround available?

I am working on a form that has conditions. For example, if a person is filling out the form and they have 3 options1. Enhancement Request2. Update3. General SupportIf the person clicks the 'enhancement request' I'd like for that person to be redirected to anothe rform for a different airtable that asks all the questions about enhancements. Thank you for any help!

Hello,I'm using your form as an embedded form in my landing page. I would like to redirect to different URL based on my landing page environment (production, development).Is there a way to do this using window.postMessage() similar to Calendly? https://developer.calendly.com/api-docs/ZG9jOjI3ODM2MTAz-notifying-the-parent-window

I have created a redirect page for the user to be sent to once the form is submitted. Browsers seem to be detecting this as a pop up and just sending them back to a new form. Is there a way around this?

Depending on the data inputting into the form, I want to redirect to a specific link. I have three links, depending on the form data I want to be redirected to one of those links. window.location.href = URL and location.href = URL do not work.

Email fields in forms don’t seem to be validated very strongly. My form keeps accepting entries like “name. lastname@host.com” (notice the space). How do I prevent the form from accepting badly formatted emails like this?

I am building a client portal.The journey starts on Fillout where the clients will answer questions based on the service they wantAll the answers will be saved on an within a "Response" table on airtable  I added this Response table to the Softr's client portal template which includes other tables such as Projects, Tasks, Company, Users, etcNow in order to build a new client portal I'd have to manually enter relevant records into such tables, which can be time consumingWhat I'd like to happen is:After grabbing/analysing all the replies within the Response table either have a button or an automation that allows me to pass the relevant data to the different tables egAdd email details to Users tableAdd company names details to Company tableAdd client details to Projects tableIn order to then have pre-populated data for the actual client portal.Hope I am making sense but happy to do a loom video or zoom call if neededThank you all!

Hello all This thread is only to ask if anyone can confirm if this is possible… and if it is… then WOOHOO, I will sign up for a Pro account immediately and abandon my attempts at this in FileMakerPro!!! Scenario: I run a youth program with about 85 teenagers enrolled. Throughout the year we offer trips, excursions, courses, events, competitions, etc. In preparation for each event, I need to know how many kids intent to participate so I can plan for meals, resources, transportation, etc. Currently I am doing this via Google Forms. I create one form for each event, and ask the kids to fill it in if they want to participate. But that means that every single time they have to enter their first name, last name, email address, phone number, etc. Which is crazy, since I have all that info already. But by doing it this way, the Google Form fills out a Google Sheet, which becomes my roster of attendees for planning, attendance, contact roster, etc. Two days ago a friend introduced me

Apologies if the question sounds weird. Basically, what I am trying to create is a form that records user and their IT asset.What I would like to have is that when I select their ID (the AD Login option) on the form, if they have an existing asset, it should automatically be shown on the "Old Asset Tag" option. If they don't have an existing asset, it will not show up. Is it possible to actually do so with Airtable? Or do I need something else?(In case you are wondering why don't I just split the form into one for new records and one for update, it's because I need to show the "history" of the user and their IT asset. With this way of recording, I can see the "history" of what IT asset the user previously has or not.)

I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values.  In the Test copy column I have this formula:DATETIME_DIFF({Test Date}, TODAY(), "months")It calculates some of the values correctly but then other ones wrong and I am uncertain how else to do this calculation in Airtable. What I need is that if todays date is Nov 7, 2024 then any dates in Nov 2024 would give a value of 0, any dates in October 2024 would show -1 but you can see the dates on October 16 and October 30 show a value of 0. You can see this issue also on the last row of the screen shot where the date of Jan 2, 2024 should be 2 but gives a value of 1.     

Hello Airtable Community,I'm currently working on creating a custom extension in Airtable, but I've encountered some challenges and would appreciate any guidance. I have followed the prerequisites and setup steps, including installing Node.js, setting up a project directory, and running the commands “block init” and “block run.” However, I'm facing issues when trying to connect the extension to Airtable for a live preview.Here are some details:Project Directory: I've set up a new directory and used “block init” with my Airtable base and block IDs.Development Server: After running “block run,” I see the localhost URL, but Airtable seems unable to connect to it.Environment: I'm using a Mac with all required dependencies installed, including the latest version of Node.js and the Airtable Blocks CLI.If anyone has experience with troubleshooting these types of connection issues or can suggest further steps, your help would be greatly appreciated. Additionally, if there are any common config

I have recently starting migrating one of my apps to the builder hub for centralized distribution, and ran into an issue with Interfaces that leverage a button action to open a form.In the builder hub, the app functions perfectly fine - no issues at all.  Once the app is distributed, the url of the form instance within the target base changes, but the url in the interface button does not - causing a button click to reference the builder hub version of the form and thus perform lookups, etc. from the builder hub base in lieu of the base in the target workspace.It gets weirder though, as the managed app does know to store data in the correct base - its just lookups, filters, etc that do not function appropriately given anything inside the form leverages the base tied to the form itself. I did verify that the FORM URL changes upon distribution and the interface button action FORM URL does not.  While it could be a simple configuration change in the target base (as a wo

Hello fellow automation experts.Need help in updating a filed but this automation has kept me up all night.The senario is simple.I have a task table called " Email Task" where i want to update status of that task from "not started" to "in progress" based on its date.My automation is as followsHere is the condition to find the records:This step is working fine as seen below:now here is what i need help with. do not know what i am doing here but final step wont run.Thank you

I have brought in multiple tables to Microsoft Power Query via Airtable’s API which creates queries for the tables. The issue I have is that all linked records Display [List]. When I click on that field the record appears to be the Record ID for the linked tables Primary Key. I assume that this needs to be extracted and then merged with the corresponding table(s) by the record ID then just expand the column that is actually linked.Is this the only way and if not is it the most efficient? 

Hello all--I run a content company and we have many different types of content and about 1,000 individual pieces of content. I would like to create an AI field that would provide recommended or related content by reading in the table the segment title and description. When I've tried it, it recommends ideas for new content related to that title or description, not related content within the table which is what I want. I've tried asking it to read cells using the {} brackets, but it still just suggests content ideas unrelated to what's in the table. Any suggestions?  Thanks in advance!

Hi, I' trying to figure out something with the form.I need my salesteam to submit sales info in the form.Lets suppoer we have to submit 2 field:1) sale price2) costI would like that after the user typing the 2 infos above, a field called "profit" will show the result of the equation: "sale price" - "cost"Is this possible?I'm trying to insert not editable fields in the form, but I couldnt figure it..thanks

Has background color? how add font color and background color?

I would like to have Airtable email each respondent after a form is submitted showing the form questions and the respondent’s answers. I see how to send a pre-formatted email but not how to include data from the Airtable record and how to create a Google doc which would be fine if I could then get Airtable to email the doc.