Ask the Community

Fingers crossed that there's a solution to this! I have data coming in from interface forms that is structured with headers like this:Name 1 / Email 1 / Address 1  / Name 2 / Email 2 / Address 2.... and so on, all the way up to 100! Yes, 100!We use this data to fill in PDF forms so it must come in as 1 row (at least with the app that I am using, I am using PDF Maker by Bustbrain labs).My question is, is there a way to split this data into multiple records like this:Name / Email / Address (header)Name 1 / Email 1 / Address 1Name 2 / Email 2 / Address 2Also, I need the data to sync, so that if there's an update on the 1st table where the data is in a single row, it will also update the data in the split records.I am open to a script, automation, syncing and duplicating tables, whatever I need to do to accomplish this. All the data I need is there, I just need it in a usable format!

I have an issue to retieve only specific fields from a aitable record const fieldsToRetrieve = ["BlogSL1", "BlogSL2", "BlogSL3", "BlogSL4", "BlogSL5", "BlogSL6", "BlogSL7", "BlogSL8", "BlogSL9", "BlogSL10"]; const response = await axios.get(`${BASE_URL}/appDP6faKvOeSxUKs/${queryKey}/${id}`, config);

HiI am a curriculum coordinator in higher education and have multiple bases/tables/forms that contain/gather information about course units in the curriculum. All information always relates to a course unit, e.g. Business Economics. All the information needs to be linked so I can always look up information in other bases/tables, but I'm not sure when to create a new base, create a new table in a base or create a new view. These are some of the data I have:Curriculum 'technical information': per course unit how many credits, elective or not, prerequisites, timing (SEM1 or SEM2) etc.Curriculum task allocation: information that comes from an export from our CRM which shows which lecturer will be teaching a particular course unit in which semester(s) to which class group. The unique key here is a formula field concatenating course unit - class group - semester - lecturer, e.g. Bachelor Thesis - Class Group 2 - SEM2 - John Doe. There should be a one-to-many relationship here, where one reco

I’m trying to make shortenings of company names using a regular expression, by taking taking the first letter every part of the name. Fx ‘Great Garden Centre’ → GGC I’m not sure if this is possible without a loop, but I’m also no buff at using regex. I’ve sofar I can only extract the first letter using this: REGEX_EXTRACT(Company, "\\b[a-zA-Z]") Is this possible without looping through every word?

Hello! I'm trying to set up automations so that each time a new form is submitted, an email notification is sent to 4 different email addresses. However, I get this error message: "Cannot email non-collaborators on the current billing plan."The problem is that the email addresses are from my bosses, who are the ones actually paying for the Airtable plan, so I don't understand why they are considered non-collaborators? I appreciate the help on this issue, I'm new to Airtable. Thanks! 

Hi all,I have a problem that feels like it should be simple but is giving me a huge headache, lol. Here are some past questions I found that seem to intersect, but I couldn't seem to find my answer in the replies: 1, 2 I replicated my problem in a sandbox base to try to narrow it down, but I'm still confused. Okay, two tables:1. Classes2. Staff. This is synced from the Data Library, and has the same sharing permissions on as all my other sync-able tables. I have creator permissions in both bases, and I'm the owner of the data set in the library. (I've also tried syncing directly from the base because the library is new to me, but it does the same thing):   Here is the Classes table. The goal is to link to the record to the Staff table, and then lookup the email from over there. I can successfully link the record by hitting the + in the Link to Staff field and manually scrolling until I find the matching name, but this is not a

Hello, im trying to improve my developer experience with automations in Airtable, have some questions:1. What type of linter is used? I tried eslint and prettier comments to disable linter, but it doesnt work2. What kind of formatter used? I want to change tab to 2 space instead of 4, but it always format with 4.3. What is the best way to have shared code between different Scripts?

Hey,I'm looking for an option in the Map - Geocode addresses or coordinates on a map extension to search for addresses.Currently we don't know the US map from top of our head and we want to search for an address to see which of our pins are close by

Hello! I have created a student database and while the linking between tables worked as recently as last week, the copy/paste function appears not to work anymore. Specifically, on the ‘Contacts’ table (see screenshot), any time a new record (student) is added, I would like to copy and paste that name into other columns which link to other tables such that the names show up in those other tables. For example, as seen in the screenshot, I would like to copy and paste the name ‘Kamala Harris’ to ‘Snapshot_link’ such that it shows up on the Snapshot table. However, I’m unable to do so-- I get a ‘Pasting…’ message and nothing happens. Currently the Name field is a formula, but it won’t work even if I make it a single line text.

Hi Community!I would like generate with a formula a random hex color code for each new record in a database. How can I do that?Thank you for your help!Stefan

Hey,Something super basic to do in any excel, python script etc. but how to get in in Airtable?I want to create some kind of ID for each customer. First customer has number 900100, and each new one (this is a child table) should get the number +100, so 900100, 900200 etc.Is there any way to do so? (ps autonumber is not an option as you can edit it, if something goes wrong and you add a row by accident it ruins the sequence)

How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits. 

Hi there, Can you help me, please? I am trying to run a script and it results that the record is not found, but it is there. I checked everything - the correct name of a table and view but it keeps giving this warning. Any tips?Thank you

We have an automation through Make.com which uses an API call to import data into Airtable. This has run for 18 months without issue. We are recently getting an error 'Field cannot accept the provided value' The data is a text string which begins with a hash e.g. '# 100'. The field is not a computed or linked field, it is a single line text field. I cannot see what has changed that this data cannot be accepted now. Any help?

Hi Everyone! I'm trying to design a judging system for a science fair styled event but I'm wondering if there's an easy way to do the judging assignment through airtable or if I can do it through Excel then transfer to airtable. Right now I have three tables: 1. Judges (All the judges are named and given a unique number) 2. Projects (Each team & their assigned table) 3. Scoring (A grid + form view where each judge can select their name + the team they're assessing through the form - I use linked records to group the teams and get final score). Is there a way you would recommend assigning each team 3 judges with team receiving any one judge more than once. Maybe there's some trick by using a number to represent each judge and the random formula... Would love any ideas. 

Hi all, I am building a base that should help me build diets for my customer. In one of the tables, there are all the foods I can use (800+ records), each of them with nutritional data, as the nutritional tables on the foods boxes, to be clear. In another table, I would like to link records from the food table, and summarize nutritional facts from each of them. This is easy, also with multiple records linked, using the rollup field. The problem is: I would like to add a specific amount of each food (a quantity, so to speak), and calculate nutritional facts from each linked records and summarize the results. For example: I would like to add an apple to my diet, but the food table has nutritional fact for 100g of apple and I would like to add 250g of apple in the diet table. If I have to link just one record, it would be simple, I add another numeric field and use it as a multiplier for the nutritional facts. But since I am not sure how many food items

Hi there!I have the airtable with employees' timesheets (start & end of shift, hours worked, location) and I want to automate (or by clicking something) the shift summary from a certain day (e.g. today). For example, I want to see the timesheet summary from today and see all the details there - name, start and end of the shift, hours worked, and location. How can I do it in Airtable and send it via telegram messenger or email?Thank you in advance!

Hello,I have two tables that I am trying to link together.One table is an instructor table called Instructors AY25 and the first column contains the instructor name and the other columns contain instructor information, including the catalog number for the course they are teaching.Another table is a course table called Courses AY25. The first column is a catalog number and the other columns contain course information.In the Instructor table, I have tried changing the catalog number to a linked field and linking it to the Course Table. This works and allows me to look up fields from the Course Table, but the new column that is created on the Course Table that should link back to the Instructor table is empty.Here's the instructor table catalog number:I have linked this to the course table:But the column it creates on the Courses table looks like this and is empty: I want the instructor names to pull into this column.  

Hi there, I've been trying to upgrade my Airtable account from the Free plan to the Team plan, but I keep getting an error message that says, ''We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us.'' I have tried refreshing the page and attempting the upgrade again, but I keep encountering the same error. Here's the screenshot of the error: I have checked with my bank, and my card has the required transactions enabled, so I'm not sure what the issue could be. Could anyone please help me resolve this issue so that I can upgrade my account?

I'm new, so apologies for any blatant errors. I'm trying to create a SKU in the table primary field using the SWITCH function based on other fields in the table. My initial try included a lengthy list of colors (all unique) and the 5-letter results (not unique) for output, and the formula failed to even load. Removing the color section, I was able to generate the appropriate results based on the other columns. However, after struggling with the color field and failing, I reset the formula to the original (no color), and now get #ERROR!. I cleaned up and sorted the color entries to perfectly match the fields, and now get #ERROR!, which is progress, I guess, as at least the formula loaded.Next, I added a lookup field for the color code I want in this table and changed the color SWITCH section to reference the lookup field, but I still get #ERROR!. Here's my new formula:SWITCH({Product Type},"Apparel", "APP","Accessories", "ACC","Blankets", "BKT","Brock", "BRK","Other", "OTH") &

Hi, I would like to request allowing the fields to become collapsible in the detail view.This is both on the web and on the mobile all.When I click to expand the record, I get the whole view of the record and the fields expand to show all contents in the fields. While this is great, it poses issues if text in the fields is long and if there are multiple fields with long text. The same issue (even worse) is on the mobile application for Android and iOS because there it requires tons of scrolling down to get to the field I need in the record expanded detail view. What would help is adding a collapsibility to fields. I do not want to hide fields from the view but if select very long fields can be preset as collapsed, whenever I view the record, that would allow me to scroll faster and find what I need and then click to expand the collapsed field if I need. 

Hi I was wondering if anyone would kindly help. I am creating a form from a grid view I have created. One of my fields in the grid view allows me to link with a master data base and pull all required info through using added lookups. This doesn't seem to be something that forms allows or am I missing something? Thanks for any advice.

I believe this is an automation question, but would be happy to learn any solutions!We use Airtable for a CRM that has 4 tables: City, Account, People, and Activity. (Cities have Account linked to them; Accounts have People linked to them; and People have Activities linked to them).When creating new Activity records, we have "Activity Tags" that are multi-select for our different organizational programs.We have already created a lookup field in the People table to see what Activities our various People have participated in. HOWEVER, we've found that lookup fields aren't the actual solution we need, because there are times where we need to associate a Tag with a People record outside of them formally participating in a recorded Activity.So, we duplicated the same multi-select list Activity tags (i.e., the programs we offer) to the People table (and named the new field "People tags") and also to the Account table (and called them "Account" tags).Is there a way via an automation or other

Looking for some help regarding a formula. Here's a little context of what I am trying to do. I am working on importing my teams marketing budget plans into Airtable, and so far everything is working well. As a final step, and in order to avoid have two column with repeated numbers for Actual Variance to Budge and Planned Variance to Budget, I wanted to create a formula combining the two numbers and then group by that column (and hide it), so that it is always present but it doesn't need to be repeated. The look that I am going for is ($ x,xxx,xxx.xx | $ x,xxx,xxx.xx)I ran into the same issue that I found a lot of people here have faced. Once I use the currency values in a text formula, I automatically lose the "$" symbol and the number separators. The symbol (even with my limited knowledge) is easy to put back, but the separators were not. I found this solution in the forums. I can't take any credit for it because I simply do not understand it, but it seems to work for a rou

Hi! I'm working with a customer who needs a general warehouse control for his business. I have created the base and all works fine. Here is my problem...When merchandise enters his warehouse, it goes into his inventory. Currently, he adds 1 or 2 products manually in a form(Writes 1st item, clicks submit. Writes 2nd item, clicks submit). The issue comes when he needs to manually input 5+ items. Is there a way, a form or a template, where he can add X number of rows, click “send“ and for them to load to a page? *As a reference, the input is in an “inventory“ tab that is linked to: product tab, supplier tab, invoice tab.