Ask the Community

We're having an issue with analysing some data/ representing it in charts in Interface designer.We have survey data and one of the questions is a multi-select field. When you try to represent the answers as a pie chart/ percentage, you get strange answers, 41 out of 45 people picked a particular answer (as one of their options) but the pie chart says it is 9.5% rather than 91% of people who gave this choice if that makes sense. I guess it's calculating it as a percentage out of all the options ticked by everyone rather than out of the responses... I can see the data better as a bar chart but this just gives the number of responses, not the percent choosing that option if that makes sense.I can figure out the answers using count/ roll-up fields in a totals table if needed but this feels quite a complex solution, does anyone have a better idea of how to get the answers we need? Ideally in one chart rather than lots of individual percentage calculations but maybe that's j

One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.Thx.

Hello,I have 3 tables Beijing, Shanghai and General in the same base. I want to auto copy/paste records from the first two to Table General when any records input in them. I created 2 automations with same triggers when a record enters a view and same actions to create record in Table General for Table Beijing and Shanghai respectively. I have 2 questions.Question 1 - Automation BJ ran well but empty lines created without any data appearing. Input 2 lines of data in Table Beijing,A

Hi!Recently a form I made had several of the fields overwritten when I added another form to it. The field went from a text response to a file upload, deleting all the text responses. I can see the deleted responses if I go to the individual row items and look through the version history. Is there anyway to undo the overwriting on the field level?

I am creating a raffle ticket lookup system to enter in sold raffle tickets and then find the ticket winner info once a winner is determined.I start the process by entering a phone number and a starting ticket number along with how many tickets were purchased. This creates an array of every ticket that person purchased in a field.In another table, I have basket 1, then enter the winning ticket number. I created an automation that searches the arrays - when the ticket number is found it updates the record for the persons telephone number. Then a txt message goes out to the winner. This worked great for a few weeks. Now, it updates the winner with every entry - so every phone number from every buyer comes in. 

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.Is there a way to use a formula for this?

Hello,I would like to know how to add tokens to the message body for an automated email which are from a different table than the single table linked to the button in the trigger. Is this possible? I have 2 linked tables: POs and line items. I need the automated email to contain a list or grid of the line items and info from the PO table about the supplier and the PO#. Or, is there some way to format the grid in the email so that it doesn't get scrunched up like this? I need the numbers to align with line items exactly.Thanks in advance for any suggestions! 

Hey guys. I’m trying to simplify a de-dupe routine. Scenario: I have a significant amount of records I’m importing. Many have identical IDs but have one multiple-select field that is different. I need to merge those into one record to combine the multiple selects. My manual process has been to do the following: Copy/paste new data in. Run De-Dupe App manually, checking every record. This works, but it’s super time-consuming. I need to automate the process. Is there any batch process to handle this? It’s always the same result. Needs to merge against the ID. All other fields remain the same, the only change is the multiple-select field. Ideas? Thanks.

Hi,I try to set a link within the same command, that created a new record. The createRecordAsync command works as long as I set all other attributes, except the one with a link (the red line). As soon as I add the red part, I get the error message - see screenshot. Can anyone help me please with that? let newrecord_miete = await table_tacs.createRecordAsync({                     "TAC_Date": per_positive_tac.getCellValue("TAC_Date"),                    

Hi, we have a Table 1 with many fields. We want to use the same fields for Table 2, with different data. Often we want to change some of the fields, such as formulas. So, suppose I modify the formula for my "Average Cost" field in Table 1. Is there a way to make the formula change identically for my "Average Cost" field in Table 2?

I am looking to purchase a digital kiosk for Airtable apps that runs on Android 7.1. Can someone tell me if interfaces run on Android 7.1. I've recently learned that interfaces do not run on an iPad so just checking.

Hello, I've looked around for an answer to this but haven't found one yet, apologies if I've been looking in the wrong place or the answer is obvious.My airtable has a list of filename prefixes in one field and a corresponding number of files in another. The prefixes are formatted something like this: item-01, and then there would be a file count that can range up into the dozens. What I am hoping to do is use those two fields to create a file name list. So if the file count was 2, I would want a list that would go something likeitem-01-001.tifitem-01-002.tifThis data would then be output to a "filenames" tab in the airtable. Is this doable? I am not good with formulas so I've been trying various solutions using linked records and automations but I haven't had any luck. Thank you for reading! 

hello everyone, I have a question that i can’t change the order of my wokspace. It’s just can arrange depend on my “Created date”? btw i use the app not the web airtable. if someone can help , I’ll Appreciate.

Hello - I could use some help with a formula or automation to get what I'm trying to achieve to happen.We have job numbers that are coded as follows:23 = year1 or 2 = office identifier0001 = job number for the yearExample: 2310023 What I need to happen is the next sequential 4-digit job number to be added to the year and office identifier each time a form is submitted to create a new record, and it needs to reset each year so that on the first '24 job, it starts over at 0001. Does this make sense?

I am in year 2 of using a pro license of my Airtable workspace. My organisation is based out of Mumbai, India and since the end of last year our central bank does not allow us to make payments that do not require a two factor authorisation.Luckily our payment went through the first time around last year as we made the payment prior to this rule being enforced. This year when we had to pay for the annual subscription renewal we used a colleagues American bank card to make the payment as to avoid any issues - this card was used by another team in the organisation to successfully make a payment for an Airtable pro license a couple of weeks ago. This was the second American card we'd tried to use. Both were declined and we can't figure out why. Airtable support hasn't been of too much help and we risk losing a lot of data. Any and all suggestions welcome.PS: We are trying to update an account with approx. 7 collaborators

I’m looking for a way to take a duration field (eg 1:32) and show it as “1 hours, 32 minutes” like with text. I’m imagining there might be a formula I could use, but I’m not sure the best way to go about it. Any thoughts would be great!

After creating my tokens i cant see my api keys and i have tried everything Now im trying to create an Oauth and i cant seem to get the hang. i'm Trying to get my bot to input data into airtables and also get information from the same table but i have not been able to get it to work on make.com i already figured out how to get it to my google sheet via make.com but im not able to call back information hence my need for airtables

I am currently able to generate invoices for my tenants by filling in the table and using extensions to populate a pdf. However, I would like to be able to create an invoice like this and then automate a trigger that generates the next invoice a month later for each tenant. Does anyone know if this possible and automations to try? Thanks

Hello, I want to extract from the rollup field "noms des participants" only one of these data for which appear in the fields "Nom Prenon 1" "....2" "....3" "....4" ..... VUE https://airtable.com/shroD4pRoA52pXcg6Thank you for your helpFranck from FRANCE 

Hi everyone,Whenever I use the search function on interfaces pages with a view layout (list, grid, kanban, etc.) I tend to get errors such as this one. It's almost certainly correlated to the underlying table size (and the number of records displayed on the interface), but I'm surprised that the issue occurs on a relatively small table (~400 records). Has anyone faced a similar situation? 

We need to take applicants and manually approve them. We intend to do this by using a status dropdown field to kick off automation when changed from 'Pending' to 'Approved'. We are concerned about accidental human error selections triggering the automation. Is it possible to implement any of the following mitigations: Prompt a user, upon input, to confirm their input before committingBuild a pause into the automation, during which changing the status back to 'pending' will abort the automation. 

I have written the script below to select records from one table in my base and insert them as new records in a second table.  The script is working, however it times out after running for 30 seconds.  The process is selecting and creating about 200 records.   Is there a more efficient way of writing this script so that it happens faster and doesn't hit the 30 second limit?   I've read that maybe i need to create an array so that multiple records are inserted at once, but I am brand new to scripting and not sure how to achieve this.Any updates / changes / suggestions would be most welcome!Thanks    //Script Purpose: //1. Select fields "Client" and "Client Family" from all records in the table "Client Master" //2. Using these values, create new records in the table "Bank Recs" //Define source table let table = base.getTable("Client Master"); //define fields

Is there still no way to create a new option in a select field in an Entry Form?Or a workaround?

Can I create an automation (or formula field) to do the following?When a record is created in the "Deals" table,  if the Move-in date of that record is within the range of the start & end dates of a record in the "Payments" table,  link the new Deals record to the particular record in the Payments table.

I am trying to update the Airtable base with a google sheet trigger “When a row is created”. The second part of the automation- setting actions fails at the setting of record ID, Could not find a solution on what to link. The record ID dosent exist. Solutions please !