Solved

Hi there! I’d appreciate any ideas about how to handle this data entry need: I have a form (external users) where one of the fields needs to collect assessor’s parcel numbers. Users tend to input this in very inconsistent formats, so I wanted to make this a multi-select or use a linked record from another table to force consistent formatting. However, there are about 29k potential parcel numbers to select from, and Airtable is not handling a CSV upload of these numbers into a new table (it crashes out even though the CSV is <2MB). I’d take all kinds of solutions, including: A way to add 29k options to a multi-select A better way to upload a single-column, 29k row table to use for linked records A way to force a 000-000-000 format for a text entry field (however, I’d need a way to have multiple parcel numbers entered with this format in this field, as each record could have multiple parcels listed) Or any other clever ideas about how to handle this to cut down on post-entry data cl

I have a lookup field that I use to pick what Client the new record in my Activities Base is for called ContactsIt auto populates the field record properly when I select the new clientHowever because you can't have the first field contain a Lookup (DUMB BTW especially for rollups and such) I have to put a formula to use the data from the lookup field record to do the rest of my workflow for the clientIt is putting the information in "" (see graphic) (Client field)It did not do that when I just used the old fields of First Name /Last name when I concatenated them (Concatenate field) which used to be the way until we moved into a separate table for Contact informationIs there something I missed in setting up the Account name field or the Contact Field to prevent the " " (quotes) from being shown?

I decided at one point to create an extra table to keep some additional records related to another table. What I did is to create a new table and add a column linking to the original table. So there is supposed to be a 1-1 relationship between the rows. Unfortunately, this has not worked out because when I update the main table, the linked table does not get updated. So I want to merge the data from the extra table back into the main table. That is easy to do outside of airtable because it is a simple table join. I did it in R in a few minutes. However, I am not sure about loading the merged table back into airtable as I think it will lose all the links to other table I setup.The main table looks like:ID (a formula), Year, Semester, Course, ...The extra table looks the same but beyond the first few columns (which together uniquely determine the row), it contains different data, e.g., enrollments, etc.Is there a way inside of airtable to merge the columns from the second table into the

Hello everyone,I’m here to ask you about a specific use case for which my searches didn’t get me any good results.I have a table of video documents where there is a duration field, with length written in the format hh:mm:ss.I have a second field called duration format, in which I wish for 3 options to be available: under 30 min, between 30 min and 1h, over 1h.Is there a way to fill this second field (duration format) automatically based on the value of the first field (duration)?Thank you in advance for your help and answers!Best regards to everyone!Charlie

The column name is too long and doesn't move to new lines when I shrink the column. Can you suggest a way to move part of the name to a different line? Thank you for any suggestions!

Hi everybody I have tried the iCal connector to Google Calendar. It is a very useful feature and I was very happy when I saw it but, unfortunately, it looks like Google is not properly updating the information. The first time you make the connection it works fine but afterwards, if you make changes in the database, these changes are not reflected in Google Calendar. If you try to connect it again you must introduce something new in the URL provided by Airtable so that Google Calendar understand it is a new Calendar and does not use the cache. So, the calendar is out of sync as soon as you change any information in the database. Althouhg I think this is a Google problem (there are some forum about it https://productforums.google.com/forum/#!topic/calendar/ixQnzHmWDSk), it would be fantastic if you could do something about it because this feature is something we have been looking for. Thank you!

Hi all,I'm wondering: Do any of you Airtable experts have an idea how I could calculate how many Fridays (or any other weekdays for that matter) there are in a given month?

Hi there,I am getting this error message back, when I test my HTTP request flow in Webflow:{ "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Value is not an array of record IDs." } }Strange that it doesn't name the column. Strange that I am not writing any data with reference to other records into reference fields. It's a simple form with text fields, number field, an email field, a phone field and a checkbox.No matter how I manipulate the form, this message comes up. The request as such is successfull.Has anyone experienced this?

 Hi! Is it possible to list values in a numerical order from a Rollup field? We want to view this field attached in numerical order. Any solutions to this? Thank you! 

Hi,I have been waiting for 3 days for an explanation why I still work in the Free plan although I have made a payment for Plus plan.I had a Workspace Michel which I deleted because I thought that was the problem.Maybe it's just me but I'd like someone to look into this.Please answer.RegardsMichel

Hello,I am trying to transform my wide format data to narrow format. The data is input into wide format because I am using a softr form for employees to give feedback on how the production cycle went and it is much easier for them to fill out a form that transmits to a wide data format. However, for analysing the results and presenting feedback I want the data in narrow format. I am trying to create an automation to do this but it is not working and I have tried linked formulas but have not achieved the desired effect. In the wide data format, the different quality out comes are each a separate field and I need to transform this into a single select field in the narrow data format table. The numbers for each quality outcome must become quantities in the narrow format.The problems with the automation are: It triggers too fast and I get several empty records in the narrow format table so I have tried to delay the automation with a script but that does not work at all.Also, sometimes the

Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF statement but only the first IF statement appears to be working. For start date equal to or greater than the 15th it is giving me the 1st of the month and not the first of the next month.Please advise  IF(DATETIME_DIFF({Role Start Date},'days'<15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),0,'months'),IF(DATETIME_DIFF({Role Start Date},'days'>=15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),1,'months')))  

Group by field is not showing a "Summary" in the interfaces graphs. Instead, show each individual record. It seems that it is a bug since the last update of Airtable, since before it worked without problems.The correct behavior that I expect is that when hovering the cursor you can see the total grouped by status and not the value of each record.

I am trying to make a linking automation. Our records in Table 1 do not all exactly match records in Table 2. I am using an Long Text field to create a list of other numbers I would like the automation to look for when linking.The problem is that using the Find Records function has the options to find a record that "is"(which wont work because im using a list) or "contains"(which will find records that dont exactly match. EX: 2118-1 will match with 2118-1.1 or 2118-11) Is there any ways around this?  

Hi folks - I have an application review process set up in Airtable and we're using an interface as the review experience and then a series of automations to process the applications based on the scoring from the reviewers. We need a reviewer to be able to batch process multiple applications at once by clicking a button on the interface which then triggers an automation with multiple action steps (see the attached screenshot of the automation). The input for the repeating group is a list of records and when I tested that, it pulls the correct records. But for some reason, when the button on the interface is pressed, it only processes one record at a time and does not repeat the action steps for all records in the list. Any ideas why this isn't working?

HiI am scheduling a festvial, and I need to create a way to "unshare" past events, so the beginning of the week doesn’t pop up on the last day.Is this possible?All the best, Uffe from KlaDa

I have a formula that worked but I decided to go and mess with it.I have a Date field that is the date of the task actionI have a Days to next action field to add to Date field to define next time to attempt the task (normally a callback)I have a Next Task Date formula field that shows the Date for the next task based on Date + Number of Days  - and it was nicely workingThe formula in the Next Task Date field looked like this - DATEADD({Date }, {Days to next action}, 'days')However I don't want the formula to put anything in the Next Task Date if the Numbers of days is blankHere is my current formulaIf ({Days to next action}=BLANK(), DATEADD({Date }, {Days to next action}, 'days'))It's failing and I can't figure out why.Thanks in advance for helping

I don't know if this is possible, but it will save a lot of time if it is. I have a donor database where each donor is known by their full name, ie. "Kate Jacobs". Is there any way that I can add a column with some sort of formula that could just pull the first word from that record? For the purpose of mail merge - I want to be able to do a FName tag, but currently will have to manually go through and rename all the contacts.  

I'm creating an inventory checkout database, based on a sandbox version created by another community member, and am trying to figure out a formula to indicate if items are overdue. Our default check-out time is one business day, and I've managed to create a formula that auto-populates the default due date, and a formula (below) that will indicate if an item is overdue, past that default dateIF(AND({Type}="Checking Out",IS_AFTER(TODAY(),{Due Date})),'OVERDUE') BUT the issue I'm encountering is that sometimes, we extend checkouts in special circumstances. I've created an "Extended Due Date" field, so that staff can manually create an extended due date if needed. However, I'd now like to figure out a formula for this Overdue field that would tell Airtable to first check the Extended Due Date field, and use that if it's populated, and then, if that field is empty, check the Due Date field. How would I do this? Thanks in advance!

Hey everyone,I have a temporary accommodation that people apply to.All of my applicants are stored on my Airtable in tab #1 (Applications) once they apply with form #1, which I use as my CRM.Once an applicant is accepted, I send this person form #2 asking for the exact move in/out dates and other valuable information using another form.Currently, I'm using tab #2 (Residents) within the same base to store that info and I'm wondering whether:there's a way to put all of the info from form #2 into the existing row that was created with row #1 orI should use another alternative, such as using a List view to combine both of these areasThank you very much for your help!Cheers,Marc from Barcelona

 Hello,I'm trying to connect Airtable to make.com and gets records to fill document with Microsoft Word Templates.The problem is returned data by Make.com. I'm getting something like this "recn3V..." instead of value from Airtable that should be a name of company. Thanks in advance 🙂

I can't get this formula to work.My table has 3 fields:Agreement SignedWYNTK SignedIntake FormEach field has a single select option, "Yes" , "n/a" or "In Progress".I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" =  "✅" If any one of the fields = "In Progress" then the STATUS field = "❌"   IF(   AND(     {Agreement Signed}="Yes",     {Agreement Signed}="n/a",     {WYNTK Signed}="Yes"     {WYNTK Signed}="n/a",     {Intake Form}="Yes"     {Intake Form}="n/a"   ),   "✅",   "❌")

Hello all!I am currently trying to make an automation that inputs the date into a cell of the time that is updated. Right now I can only see two options - static and dynamic. The first does not work since the input will not change with every update, and the second can only be based off of different cells. Is there an option I'm missing?Thanks!

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between one month ago and 3 months from now.  How would I go about making this?Many many thanks in advance.

Hello! I wrote a script that creates multiple days worth of events people can book at a time, but it takes into account some settings to determine how long those slots are, when the lunch break is so it wont create a slot then, etc. I'm also making an automation to create a new day's worth of these every day at midnight, so that after we run the manual script once we can leave the rest of it to happen automatically. I'm wondering if there's any way I could grab the settings from the manual script for use in the automation.