Ask the Community

Hi there! I have a big table with business founders, and I’m looking for a method for new records to auto-complete the gender field by searching the same first name in the table and looking up the gender. How can it be done using automation?

So, I love the fact that I can finally share interfaces and embed them into our services. This has finally given me the use case for them. First snag I have found though is that when I have a drop down, for some reason one of them keeps changing the sort for the records and I don't know what I am doing wrong. The dropdown is filtering a linked field. When I select the dropdown on the interface designer, it is in alphabetical orderWhen I select the dropdown post publishing, it is in alphabetical orderWhen I select the dropdown on the embed or make larger link, it is chaosIs there a way for me to fix the sorting of the dropdown item? I show the perfect drop down and the less that perfect one in the attachements. 

I just wonder can I use my data table in Airtable to link with my application? I mean I want to do SQL query to Data in Airtable and get some attributes and push it to the CRM tool attached to my Application. Is it possible to do these actions? 

Hi all, I'm trying to create an integration between Airtable and Typeform.On typeform, when connecting with Airtable, I can select the base and the table but when I select the table, the matching fields do not appear. (whereas it appears for my other tables).Do you know what can be the issue? Many thanks,

Looking to build some QC tracking logs which would have paper inspection reports from the field as PDF attachments. Ideally I would like for the field inspectors to upload their daily inspection reports via a form which would then notify our QC manager that has he reports to review. He needs to be able to open up the PDF and markup/check off/make notes/annotate various pages before approving or rejecting the report. I do not think this is natively supported (yet, boo, seems pretty useful) but is there a reasonable workflow to make this happen? Overall I am dealing with some fairly non tech savvy folks (construction), but would like to both get better visibility on the process as well as make the process as easy as possible for them. Any thoughts?

Hi,I have a table of projects which is being imported in. Each project has a project ID column, and a Project Parent ID column, since there are sub projects. I want to simply create a list which shows each parent project, followed by all of the sub projects. Nested Linked Records seems to only allow me to do this in reverse. Is there any other way I can do it. I can't really change the structure of the data, since it's being imported in from an API.Thanks! 

I'm looking for a way to communicate shift assignments to hundreds of individuals who are not members of my base. I use Airtable to manage poll workers. For their work assignments, I integrate Airtable with Make.com. When a staff member offers an assignment to someone, Make.com compiles data from multiple tables into an email.Each assignment has a set schedule. Schedule details have been included in the email in a bulleted list. The source for that list is a long text field with RTF enabled. The schedule descriptions are often complicated and a list is not the best way to display the info. I'd like to incorporate a separate Shifts table that can be linked to the assignments. This would allow much more specificity in describing the work schedule. Ideally, this is what I would like to get out of this, and I'm not sure the best way to go about it:In the initial offer email, clearly list all of the shifts that the person would be required

When someone calls through RingCentral and their name, or number match an Airtable record, is there anyway for that record to pop up?

Hello everyone, I work at an NGO and I’m trying to put together a booking system so people from a specific program can set up a meeting with someone from the team through a form. I did everything, but I’m having problems with the Google Calendar automation. It works, but I don’t know why it creates the event two hours later from the time on the date field. I’m guessing this has to do with timezones? but I haven’t been able to figure it out :disappointed_relieved: can someone help me ? Thank you!!

I have a user that can't click an interface button which runs an automation. The automation primarily updates a field that is not visible through the interface. My user, who has access to the interface but not the underlying base, is unable to click this button. It is greyed out. Unfortunately I didn't get to see the error message you get when you hover over the button because another user 'helped' them and moved the workflow along.Is it the current expected behaviour that a user with interface only access can't run an automation that changes the base? Or is there something else going on here?

I imported (not thinking) over 1,000 .csv records into one of my Free dBases.What will happen to the excess records?

I'd like to build a field that returns the days until due if >0, or "Assign Due Date" if Nan, or "Passed Due" if <0.I am struggling to combine the IF statement with the following formula:DATETIME_DIFF({Deadline},TODAY(),'days')Any tips on how to accomplish this? 

Hi, community! I'm sure you'll be able to give me some ideas to figure out the best way to accomplish what I'm trying to.I have a base with 6 tables: Check-in, Market, Business, Operations, Traction and Finance.Forms with data will arrive in Check-in table. Since is a lot of data for the customer to fill in one time, we had to split fields in 5 forms which collect the real values of customer business and 5 forms collecting projection values.Customer will answer this every month, so we have an Evaluation Month field in every table. Also, and that's one messed up thing, they need customer be able to send data in more than one form. So this would work something like, on first month, customer knows 4 of the 8 questions, he will send a form with these 4 answers; then, when he gets the other 4, he will send another form with the other 4 answers. Please, consider we can't ask our customer to send only one form per month, despite this was the easiest way to solve the pr

Time zones are difficult to handle within AirTable. Here is an example that gives me a headache. I have a table (let's call this table Calendar) in which there is, among other things, a Date Field associated with an event occurring at a Location. Strangely (in my opinion), I cannot set the time zone in the Date Field in question.In another table (let's call it Locations), I have the list of Locations in question. I also have a Cumulative Field that aggregates all the event dates related to this Location in my Calendar table. However, in this Cumulative Field, I can choose the Time Zone. Naturally, I choose the time zone in which we work.The result is that the event dates in these two tables are in different time zones. The Locations table operates in the EDT time zone while the Calendar table operates in the GMT time zone.How can I make my CALENDER table work in EDT? 

Hey everyone. I have a public URL link that I'm trying to use to upload to an airtable attachment field with airtable scripting. This is my code (the URL is obtained from an API call response): "let existingAttachments = recordA.getCellValue('attachmentsA');let updatedAttachments = existingAttachments ? [...existingAttachments, { filename: fileName, url: responseData.pdf }] : [{ filename: fileName, url: responseData.pdf }];

Hi everyone,Everything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

Hello!I realize that Airtable most likely wants to push forms to be built via Interfaces, but of course, many forms have already been built by users in the standard table views. When going to a form view within the table (not Interface), we get a popup window that states the form has been upgraded and then two buttons: "Edit Form View," which lets us edit in the old form view option within the table, or "Go to form builder," which takes us to the interface version. The user responsible for this base is not interested in using the Interface version at this time and so they click "Edit form view." However, what is annoying is that every time the form view from the table is brought up, the popup has to be cleared yet again.We understand that there are two ways to approach this form now. The interface version hasn't been touched and is not shared, while the older version is linked to and shared.Is there something we'r

I'm developing a Block Extension. When I type block release I get"Error: Your Airtable API key is invalid. Please use block set-api-key to update it. Code: airtableApiWithInvalidApiKey"Since api keys are deprecated (I have deleted my key and can't create a new one) I have created a personal access token. But I can't get it to work with block release; running block set-api-key <my-personal-access-token> returns"Error: Invalid Airtable API key specified. Make sure you copied it correctly from airtable.com/account. Code: airtableApiKeyMalformed"How do I use my PAT with Blocks?  

I am trying to updated a linked record via Siri Shortcuts. I keep on getting error “value is not an array of record ids” The update is done vie Get content of URL. Request Boyd JSON. I figured out the id of the record that I am trying to link to. I tried setting the fields text to the record ID but I still get an error.

Hello all ! im trying to send automated messages to whatsapp when a record is matches conditions. Ive been trying to do it via Twilio, but having a hard time, any suggestions? 

Hi everyone,I have a table where I import record from a Salesforce reporte.g. https://support.airtable.com/docs/airtable-sync-integration-salesforceEverything works fine, but I would like to have a button that redirects me to the salesforce record when clicked.The JIRA integration has something similar.Has anyone found how to do this?

Interface designer pages can now be shared publicly. 😁😁😁 This feature is still in beta, and comes with a warning that some hidden data may be exposed.An example that Airtable gave in the docs explains that even if a chart in an interface page shows only combined values, it is possible that individuals could find the specific numbers behind those totals by examining network logs."Consider the dashboard below that shows data for 28 deals in the pipeline. The chart shows the sum

Can anyone figure out why im getting the following? My goal is when a record is updated with a CSV file, I want to convert the CSV file into a list of records that I can then use elsewhere. This is in conjunction with an automation.CONSOLE.LOG"Script started"CONSOLE.LOG"Record ID from input config:"undefinedCONSOLE.ERROR"No record ID provided in input config."CODE BELOW SHOWN BELOWconsole.log('Script started');let tableName = 'Fabrication Package Members';let attachmentFieldName = 'Assembly List';// Function to parse CSV text in

I saw what looks like support for type script in airtables online IDE but I couldn't find any documentation on it. I'd like to get rid of some of these type errors that are populating my code.  

I have 5 supervisors that I am wanting them to "review" workers for each shift of an event.  Ideally, I want a way for the supervisors to be shown a blank table where they write their own notes for 6 different fields for each worker without seeing the notes that other supervisors have written.I don't care if they see their old notes...or if their entries disappear from their view altogether after filling in the data.I would need to be able to see the entire table with everyone's entry.Is this a possibility?