Ask the Community

Hi there I have this formula below where I need to also round up by 5 or round down by 5 ( e.g. 4556, to 45560 or 2333 to 2335) ({Original Price AED} * (100 - Discount)) / 100 Could anyone please advise how I integrate the round formula within the above formula? Thanks, Nathalie

I'm creating a script between 2 tables: 'Engagements' and 'People'.Engagements is a list of event attendancePeople is a master list of peopleI have a script that, using the attendance sign up info (name, email), tries to find a matching person from the master list. (This step is part of a loop to go through each Engagement record.) let peopleTable = base.getTable('People'); // find a matching Person record let personQuery = await peopleTable.selectRecordsAsync({ fields: ['Person IDENTIFIER'] }); let foundNames = personQuery.records.filter((record) => { let name = record.getCellValue('Person IDENTIFIER'); return name == engagement.getCellValue('Person IDENTIFIER'); }); This works fine. Now I need to link all the 'foundNames' to that 'engagement' record.  The linked field is called 'Person' in 'Engagements' table: let numPeople = foundNames.length; if (n

Hi Folks,I have come up with a workaround for not being able to filter on query within scripting automations. Since you can query on a view but views can't be adjusted via the API either we use a view that has a checkbox and then check the box through update records and uncheck when done.  This is useful when you have a list of records from a linked field more than a dyanamic filter.  It is also still best to filter the records that are returned to ensure they do meet your criteria but greatly reduces the number of records returned.  First we use this async function to make the object for updates:   ​async function setAutomationFlags(table, recordIds, flagValue) { const automationFlags = recordIds.map(recordId => ({ id: recordId.id, fields: { "Automations": flagValue } })); await updateRecordsInChunks(table, automationFlags); }

For starters, I’m relatively new to Airtable and this is my first time asking for assistance. Please feel free to explain things to me like a 5 year old. I’m pulling data from multiple sources, Sheets being the main one. I’m looking for help with Airtable’s scripting automation for a field titled Contribution Amount. For context, this is for a freelance project for a company that offers cleaning service subscriptions. There’s three main tables- blocks, Subscribers, and Active Subscriptions (junction block of the first two). Each block has a cleaning Budget (Budget field) that needs to be achieved, subscribers on a block pledge an amount (Pledge Amount field) they are willing and able to pay, pledges are pooled (Total Pledge Rollup field) and the funding threshold (Threshold Milestone field) that the block has achieved is noted. When a block surpasses a funding threshold (Numeric Value of % Threshold field is used here so a percent is not) that value is

I have the same question from the individual with the post I am referencing that is closed but never answered. I would like to set up a gallery view where the user is directed to the link without having to open the card. Any ideas out there? Gallery view link directly from the card, without showing the popup (and requiring extra click on URL)

Hello, for the last few days we noticed that our scheduled per-day automations run on each Update (when we edit scripts and Update automation)Is it expected new behavior?

Hello!I would like your help to solve the following problem:We conducted a survey where people answered questions and received points. Now we need to filter the score value by colorThere are 3 colors for cells, which are colored when the following conditions match:Red: if a person scored a low number of points in 4 categoriesYellow: if there are no red blocks out of 4 and less than 3 green blocksGreen: There are no red blocks, more than two blocks are green out of 4Points: red if scored from 0 to 11 points in each categoryyellow if from 11 to 17 pointsgreen if from 17 to 25 pointsHow can automation be assembled so that colors are assigned automatically based on these formulas? Conditions in coloring are not suitable, since it only looks at 1 condition\Thank you very much in advance for your help

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?