Ask the Community

Hi there!  I'm hoping someone can guide me to a tutorial or has some great design ideas:  I have a base that calendarizes a huge list of events across multiple departments.  I have an interface page set-up with a record picker that displays relevant events.  I would love for each department to be able to review the list periodically and either suggest edits to existing records, or request new ones be added.My reason for not having them directly edit the records is because I want to (a) be sure that I know about changes, (b) can resolve conflicts if different team members varied info (that happens!) and (c) am concerned about data integrity when many of our users aren't regular airtable users! Is the best solution here to just allow users to make edits directly & just create some level of automation/notification when edits are made?  Or; I had thought to just request users to make edit suggestions by adding a comment to the

Hi all, I'm very curious if this can be replicated on Airtable interfaces. From my experimentation, the filename of the image keeps coming up and I can't remove it. How do I develop this? Or is this just "non in-application screens"?

I am trying to achieve the following:A "Points" table that stores usernames and points associated with themA "Leaderboard" table that aggregates all points for the users, i.e. sums up the points for each userI set up the Leaderboard table first where I defined a "Username" field as the primary key and a "Total" field as a number field. Worked fine.Now I wanted to setup the Points table so a Username field points back to the primary key "Username" of the Leaderboard table, like this: { "name": "Points", "description": "Points table to track points per user", "fields": [ { "name": "Id", "type": "singleLineText" }, { "name": "Username", "type": "multipleRecordLinks", "options": { "linkedTableId": "tbl..." } }, { "name": "Points", "type": "number", "opt

So my goal is to automate image enhancing via form submission.When my table receives the form submission, most of the time, it will receive multiple images ("rawFiles").Once it receives the data, it will send a webhook to Make.com where it all goes through the automation.My issue is "rawFiles" only receives data as a string and not as an array. I would like to pass this data as an array so that my webhook in Make can process it properly.Here's my current script: let inputConfig = input.config(); let webhook = 'https://hook.us1.make.com/s3i0oapoqp08n8wxigxpv7jl826k24lw'; let queryParams = `/?Record ID=${inputConfig.recordID} &Raw Files=${inputConfig.rawFiles}` const returnedPayload = await fetch(`${webhook}${queryParams}`); And attached is a screenshot of my test in Airtable.I'm not good at coding/scripting, so any help or direction will really be appreciated.

Hi - the iframe code that is generated when you want to share a view makes it look like the background can be changed, but it is always grey regardless of what I do with the iframe code. Has anyone been able to change the background color? Thanks. <iframe class="airtable-embed" src="https://airtable.com/embed/shdfgsfgs0I?**backgroundColor=blue**" frameborder="0" onmousewheel="" width="100%" height="533" style="border: 1px solid #ccc;"></iframe>

I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) = AField 2 (single line text) = BField 3 (single line text) = C Table 2 also has one record with a multi-select field. The values areField 1 = C, D, E, F My OR formula should check if any of the 3 values from the record (Table 1) is included in the multi-select field (array) of the record in Table 2.  OR( FIND(Field 1 (Table 1), Field 1 (Table 2)), FIND(Field 2 (Table 1), Field 1 (Table 2)), FIND(Field 3 (Table 1), Field 1 (Table 2)) )  When I add "C" to Field 2 (Table 1), then it's correctly counted.If I add C in Field 3 (Table 1) I don't get an error, and the formula ju

I have an Airtable automation that uses the AI module to summarize text fields for each record in a view. A repeating group iterates through that list. In Make, those newly updated records are processed through a Word template to output a report. I'd like to figure out a way to trigger them with one button press.There are three ways I'm aware of for triggering Make, but I can't figure out how to make any of them to work.Webhook doesn't work (I think) because I need it to happen sequentially, with the Airtable automation running first.Record update: my original plan was to update the status of a report record that Make was watching after the Airtable automation looped through the whole list, but it doesn't look like you can add another action after a repeating group. So I also tried a script within the group that would count the loop iterations and compare to the list length, and at the end of the last iteration, would update the record. But I don't think

Hi guys, I built a CRM on Airtable. Each contact's details sidesheet features a 'LinkedIn Links' block. This block contains a 'Chat' button that redirects to the LinkedIn's conversation with the person. I'm trying to set the conditional visibility of that button: have it shown only when the `LinkedIn Chat URL` on my base is not empty.Problem: I can't find the field among the displayed fields. And yet:1. the page is linked to the right table, 'Contacts'2. the 'Contacts' table does have the `LinkedIn Chat URL` field (formula type)3. filters can display formula-type fields. E.g. the field `Full Name` in my case.

I know this issue has been discussed before, but there doesn’t seem to have ever been a solution discovered, so I’m bringing it up again in case anyone’s found an answer in the last 1.5 years. The problem: occasionally/often, when an attachment is uploaded to Airtable via a Make.com automation, Airtable will immediately delete the file after upload. In the record history, it will say that the user who created the record also deleted it, but that’s not the case. Here’s a Loom video illustrating. Important notes: I’m using the Share Link Google Drive module to get the share link. The automation itself doesn’t seem to be the issue. Airtable will occa

Hello, i'm calling an API but i'm getting different results if i'm using Android or iOShere is my call:https://api.airtable.com/v0/appOwBv51ih******/teamtim****/?filterByFormula=FIND("Maurizio Polverini",{Nome})=1&sort%5B0%5D%5Bfield%5D=ID&sort%5B0%5D%5Bdirection%5D=ascAndroid response (it works well as everything is sorted "asc" by the column "ID") - as you can see everything is well sorted starting from fields{ "ID":36:--------------------------------------{"records":[{"id":"recHkGRBjaYe3ohuO","createdTime":"2024-11-09T08:19:32.000Z","fields":{"Nome":"Maurizio Polverini","Created":"2024-11-09","Device":"Android","Entrata":"9:19","Uscita":"9:20","GPS":"Estensione GPS non attiva","Ore Lavorate":0.016666666666666666,"Mese Nome":"novembre","Anno":"2024","ID":36,"Giorni":"09","GPS Uscit

  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 (Opt

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

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 ha

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 d