Ask the Community

I am trying to format decimals in a formula to no avail: To the left is the number the 3rd column is what happens when this number is used in a formula (the end is cut off for numbers ending in 0) (e.g. 12.50 > £12.5 middle column is where I have formatted the number with this formula: so this was a solution found on another thread: IF({Refill / lowest price}, “£” & {Refill / lowest price} & IF(FIND(".", {Refill / lowest price} & “”) = LEN({Refill / lowest price} & “”) - 1, “0”)) However, if you now look at the middle column it works for the £12.50, but for any round numbers under 10 it misses the decimal place. (i.e. 5.00 > £50. Any help with tweaking this formula would be greatly appreciated! THANKS! :grinning_face_with_big_eyes:

HELP! I have a base with a table where I have collected submissions for an upcoming conference. There are fields for Speaker 1 Name, Speaker 1 Email, Speaker 2 Name, Speaker 2 Email, etc. I am trying to pull all the data from every record to another "Speaker Management" table. So I need all the Speaker Name fields (Speaker 1 Name, Speaker 2 Name, etc) to go to a singular field (Speaker Name) in this "Speaker Management" table along with the corresponding email contact for the record. The records are already there, but may update because I am using FillOut for people to update their submission content. I appreciate any thoughts!

My company is working to centralize our Zaps now that there's a service account feature through Airtable. However, we're running into the question if we should create separate service accounts with specific bases given access to (with the idea of least privilege), or just authorize a general Zapier service account that has access to all current and future bases?The latter seems to be a lot more permissions than necessary, but it is also easier. Would love to hear how others are approaching this. 

Hello Airtable community,I hope this message finds you well. I am currently experiencing an issue with creating a Vega-Lite visualization in Airtable, and I'm seeking guidance from the community.Problem Description: I am attempting to create a simple pie chart using Vega-Lite within Airtable. The goal is to visualize two categories, "With Tape" and "Without Tape," based on a "product_title" field.Vega-Lite Code: Screenshot attached. Issue: Despite trying various configurations, the visualization is not rendering. I have attempted simplifying the code, but no luck so far.Question: Is there anything specific to consider when using Vega-Lite within Airtable? Any guidance or insights into what might be causing the issue would be greatly appreciated.Thank you in advance for your assistance!Best regards, Lewis

Hey All, I built an Airtable base for a consulting client and their flow relies heavily on being able to print information from Airtable. I set them up with 6 separate Page Designer extensions for them to do so. They're having a consistent problem when trying to print a custom size paper.- it jams in the printer every single time. They've tried it on multiple printers and had their printer tech review as well. They're not having any issues printing when the page is a typical 8x11in size. The size dimensions for the custom page is 545x545 px and I've set the printing size also to 545x545px. When they try to print this page as an 8x11 it does print and there's no issue except that the content is only at the top of the page and they already have custom size printer paper they want to print on (not print and cut each page). Can anyone see why this may be happening? I've run out of all printing thoughts and they're a remote team, so I can't review the printer in person.&

Hi,I have a database with special dates of each month (Christmas, Halloween, etc). I'm using the DATEADD formula to add 1 year to a date field.For example, for Christmas I have the date 24/12/2023 and I expect the DATEADD formula to result in 24/12/2024 (field "Próxima Fecha" of my attached screenshot).However, I'm getting 23/12/2024 as a result. This happens with all the dates (gives 1 day difference).Is it a bug or I'm missing something?Thanks!

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a like that goes to the favorites page, user B and C log in and see A's likes and vice versa. After speaking with the no-code platform, they tell us that the solution must be found by Airtable because it's the backend -> I'll share with you what XANO is doing. The idea is the same principle, but with Airtable if possible: https://www.xano.com/snippet/qCmG9KcL/J I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a like that goes to the favorites page, user B and C log in and see A's likes and vice versa. After speaking with the No-code pla

Hello,I have this javascript that i want to add in my automation in order to transpose a table but i always have this error message "Exceed quota 30 table queries". How to solve it? // Get the "Forecast artikel" table and the "Transposed" tableconst tableForecastArtikel = base.getTable("Forecast Artikel");const tableTransposed = base.getTable("Transposé");// Retrieve all records from the "Forecast artikel" tableconst queryForecastArtikel = await tableForecastArtikel.selectRecordsAsync();// Array to store updateslet updates = [];// Iterate through records in the "Forecast artikel" tablefor (const recordForecastArtikel of queryForecastArtikel.records) {// Get the article name from the "Name" column of "Forecast artikel"const articleName = recordForecastArtikel.getCellValue("Name");// Iterate through columns like "Tag 1," "Tag 2," "Tag 3," and so on in "Forecast artikel"for (let i = 1; i <= 31; i++) { // Make sure to adjust the upper limit based on the number of columns in "Foreca

I am working on a budget base, where each month has it's own amount connected to a milestone. I'm wondering how I can link a multiple choice field which refers to specific budget lines, to specific fields in the same row, which indicate monthly amounts. So if the multiple field refers to e.g. 'A' and the monthly amount for December field is e.g. '200', how do I make it e.g. '200A', while at the same time in the same row, I want November field amount e.g. '100' to be referring only to 'B' in the same multiple dropdown field, making it therefore e.g. '100B'. Just keep in mind that the milestone amounts are always different, while budget lines have fixed value. Thank you!

Trying to figure a code flow so that i can move some automation away from zapier and have them automated in scripting. the 1pm in delay just make it doesn’t work for our team.

HelloI'm looking for a solution to automate the transmission of a document "report of an interview" to a client.I had the idea to use the lookup but I can only import the name of the candidate. I would like to add a report in pdf or text (information in a table 2) in addition to his name 

Hey all, I'm looking at creating an order for that take information for our tables for internal orders. I've attached  a picture of what we are trying to create. Any help would be great. I'm stuck on adding additional line that can pull all the details; it seems to just pull the item detail 

Hey all 👋The subject may be confusing.Basically, I have a column {Day}, {Day} is a single select field.The options in {Day} includes the following strings:mondaytuesdaywednesdaythursdayfridaysaturdaysundayI want a formula field that returns the date, based on {Day}.For example, this post is written on 13 Dec 2023, Wednesday.If {Day} is "monday" then the cell should return 11 Dec 2023. (last monday)If {Day} is "wednesday" then the cell should return 13 Dec 2023 (today)If {Day} is "thursday" then cell should return 7 Dec 2023 (last thursday)how should I write this formula?

Hi,I've been trying to learn and build a script with the help of ChatGPT. The script creates a report in Clockify and all works fine until I replace the value input variable from a fixed value to a feiled in the base from a previous step. The value is just a string but is actually a lookup from another table. I've tried to use a formula in another field and use that but both result in the error seen in the screen shot.I feel like I'm so close, any advise ?  

I’m really enjoying the new collaborator views on interfaces. But I wish buttons could pass the collaborator information of who pressed them, especially for automations and scripts.It solves the problem of multiple collaborators checking the same checkbox, getting the collaborator information from a last modified by field, and waiting for an automation to uncheck the same checkbox so someone else can do it. I don’t know if it’s a tall ask, but it’d really help me refine user-specific controls and automations. thanks!

Who knows how to achieve this? If you have two tables that are linked together where each record can be linked to multiple records in the other table...My question and goal is... How can I quickly see one table in a way that shows each/one record with the sub.linked records one per line below it? When all the linked records are just in one field bunched up, it's hard to see all of them clearly. Also, my text is 'long test' and I'd like to be able to see it all. How do I get to see this...? Table 1 parent record #1- table 2 linked record 1 (linked under parent table 1 record #1)- table 2 linked record 2 (linked under parent table 1 record #1)- table 2 linked record 3 (linked under parent table 1 record #1) Table 1 parent record #2 - table 2 linked record 4 (linked under parent table 1 record #2) - table 2 linked record 5 (linked under parent table 1 record #2) - table 2 linked record 6 (linked under parent table 1 record #2) Background: I have two tables ('Ideas' tab

I have a linked field in my Customer’s Table called services. On the interface page I want to show the notes of those services. Currently I have a Gallery View, but you can only show 4 lines of the field. Is there any way to show more information without having to click and open the Service? Or is there another way to show this data? Thank you,

Hello! I have a pretty basic formula that isn't working for some reason. Basically, I'm trying to see if a substring I'm extracting with a REGEX formula, and then trimming, is contained inside another string. Here is my formula: FIND({Formula Field of String to Search For}, "" & {Lookup Field of String to Search Inside}) The second parameter seems fine: I know that the lookup field needs the  ["" &] to force it to render as a string instead of an array, and that's working. The issue I'm having is with the first parameter, the string to search for.This formula field that the first parameter is referencing a REGEX_EXTRACT() on a long text field, that I need to edit (either using LEFT() or TRIM()). My goal is to then search for this extracted string in the string generated from the lookup field, using FIND(). However, no matter what I do, the first parameter it seems like it isn't accepted as a string within FIND(). I've tried UPPER(), CONCATENATE(), and the ""

Hi thereI have an Airtable base with 2 tabs: 1. Resellers: on which I keep the "Company" name and the "Website" of resellers I'm working with. Company and Website are my 2 fields on this tab2. Performance: on which I have some datas imported from a Google Sheet. Here I have 3 tabs : email_domain, total_mrr and total_projectsI would like to add a field "Results" to my Resellers tab on which I automatically render the total_projects from the table Performance for each of my resellers. The issue here is that the performance table is randomly ordered so there is a need to make a match between the Website from Resellers and the email_domain from Performance and to render the good value for each Reseller. I tried to set up an Automation or even find a way to do it through Make but I didn't manage to achieve that so far. I'm wondering if it's possible to make 2 cells from 2 different tables match to each others. 

I need to be able to write a formula that checks if the last modified date is after a specific date and time. Basically, I imported a large batch of data and I want to track whenever a change is made after the specific date and time of import. I'm having trouble referencing the specific date and time of import within my IF(IS_AFTER) formula. Here is what I have so far - but I know AT isn't reading the date and time I referenced. IF(IS_AFTER({Updated Post Initial Import}), '2023-07-14 120000', "Updated Post Initial Import")

When I’m adding records, and I need to add a record in a related table, I have the option to do so through the gallery view but not in the form view. I would like to have that option in the form view as well. How?

Hi! So here's my problem: I manage an intranet platform for a very large company and I use Airtable for our editorial calendar. There is a special section on my platform of regularly scheduled content that is user-generated. There are four business areas (mine makes five) and together we are responsible for providing this user-generated content on a rotation each week. So each week there are four slots available but five business areas. So how do I create a scheduled rotation so that each business area gets a regular number of slots and that the total number of slots for each business area is more or less equal at the end of the year? Super basic example below:Week 1: 1, 2, 3, 4Week 2: 5, 1, 2, 3Week 3: 4, 5, 1, 2Week 4: 3, 4, 5, 1

Hi, community!Please, I need help to understand what happened with an automation that I messed up and was sending e-mails in an infinity looping even after it was deleted from the base.It was initially built with "At schedule time" trigger and had two steps: 1 - Find records matching one condition: Where field A contains Yes2 - Send an e-mail to the e-mail found in the previous stepAfter I tested, I realized that I actually needed to insert the Send an e-mail step inside a Repeating group. The problem is I forgot to update the data that should be used in this step, so it kept sending e-mails to everyone that matches the condition in the first step. I fixed that changing data to Current item data in all fields in the e-mail step but it didn't work and then, I deleted the automation and it still kept sending e-mails.Now, it seems to have stoped, but I'd like to understand what happened here so if something similar happens in the future. Anyone with patience to explain how something

I have enabled Airtable's native password protection feature for my form created using the Interface Designer. When someone navigates to my form's URL, they need to enter the form password in order to access the form.How long can someone access the form after entering the form password? When testing on my computer and phone, I noticed that I can continue to access the form for about 24 hours after first submitting the form password without having to submit the form password again. After that time, I am prompted to reenter the form password. Does Airtable require the password to be resubmitted every 24 hours?

Is it possible to prefill a password for a form?Something like this: https://airtable.com/baseID/pag23482374823/form?prefill_password={password} This would be really helpful because sometimes I need to send a form with sensitive linked records to people who do not have base access.