Ask the Community

I need some help with an automation.When a particular record in table A is updated, then inTable B the contents of (Planned Move-in and Planned Move-out) in the fields (Move-in and Move-out)

How do you write data separately to all the records you find when you automatically find multiple records？the follow example find 2 records, then the next action step run fail, what can I do so that the updated action is written to each of the two records found?

Dear Sir,I need help in creating rankings of products based on its quantity.We have a table with 3 fields. Name of Fruit, Quantity, Ranking. We want to rank the Fruits as 1,2,3,4... based on the quantity of that fruit. Whenever the quantity of any fruit changes, the Ranking should update itself.Any help will be appreciated.Thank youNavin

 In a few of our bases, we have either password protected the shared grid view, or we have disabled the share view link completely. However, we're finding that a different URL for that same grid view is still being accessed, even though there is no link associated. This means people with a link are able to see the contents of this grid view. We're also finding that this URL is different from the original link that was associated with the base.Is there a way to view what links are tied to the base? Has anyone else experienced this issue? We are trying to get these links offline. Hope this makes sense. Please let me know if any clarification needs to be given.

DescriptionThere appears to be an issue with Rollup Fields when used in conjunction with Linking Records and date columns. The problem occurs when the Rollup formula becomes more complex.How to ReproduceCreate a Rollup Field that references a date field in Linked Records.Set the Rollup formula to MIN(values).Result: Some records correctly display dates (as expected, since not all linked records have values in the corresponding date field). Change the Rollup formula to a more complex one, such as: IF(MIN(values) = BLANK(), "-", MIN(values))Result: All records now display "-" instead of the expected dates. 

Hi guys!Losing my mind trying to figure this out – I thought it would be a super simple formula but just cannot get it to work. Here's the lowdown:I'm mapping out placements for an editorial website – there's a carousel that will feature 5 articles each week, rotating between 12 different articles. I want to be able to count how many times an article has already been used in the plan.So, I've got a table here that's grouped by each week (ie. "1. 9 Nov"). Below is an example screenshot showing the first 3 weeks (but there are 7 in total):A breakdown of each column:Name: The name of the week (so it can be referenced in "List of placements")Article: This links to another table with a long list of hundreds of articlesPlacement: A single select field with

Hi,I wonder if I can somehow give a copy of a Base to another user?I have a blank Template base (with just the column names and formulas and such) and I would like to give a copy of this Base to another user. This other user is NOT part of my company or organization. I do NOT want them to be a 'collaborator' in any senses - I just want to hand off a single copy of the Base to them, and then they can do whatever they want with it, and not involve us at all (or our account at all). Is this possible somehow?thank you!-Ed

So I've been developing an Airtable base for months to track & log operations. Since there are so many moving parts, creating google calendar invites are a must for the employees who will be a part of the operations. I've been reaching an error with the Google Calendar automation to create events, which I will show in a screenshot. I cannot seem to find what the limits are to find a workaround, some days I can only generate less than 10, other days I can generate around 50. It is never consistent, and I've been trying to find resources to figure this out - but I have not yet. If anybody has any workarounds, or knows the usage limits, that would save me so much trouble. I don't want to use any third party automation software, I would like to keep everything in Airtable Automations.  

The record limit for the free plan is 1000. I am only at 500 records.  

I’m trying to use a find/update zap to automate a record update in Airtable, Some empty fields need to get new data, some get updates and others need to be cleared. The Zap correctly adds the new and updated data, but I can’t figure out how to DELETE data from the fields that I want emptied (which are date fields). With other numeric fields, it’s easy to just set the update value to “0”, but this doesn’t seem to work for date formatted fields. I’ve tried 0 =0 -1 0/0/0000 0000-00-00 =BLANK() Null Creating an empty dummy field and setting the value equal to that No luck. I asked Zapier first, thinking they might have some special formula or syntax to use for this kind of thing, but they told me it’s restricted on the Airtable side and overwriting with blanks isn’t permitted. I thought I’d ask here in case anyone else has come up with a solution/hack to clear/empty/erase a cell or make it “null”. Thanks.

In the form I have a data record field where all free rooms are displayed. All occupied rooms are not displayed. However, if I have a reservation for the future, the assigned room is immediately marked as occupied even though it is still available until the specific reservation date. So far I have no idea how to solve the problem.

Hi there!I have been trying to get an automation to look at a view in Airtable and list up all the records with their hyperlink in a Slack message every Wednesday.The outcome would be something like:´Here's a few entries you can pick from:SW-0001 (hyperlink to record)SW-0002 (hyperlink to record)SW-003 (hyperlink to record)I have tried running a code but the list won't show (added images what I got for reference).Does anyone have any idea how to solve this?

Is it possible to subsequently edit an existing data record using a form, for example to change a status. without making the change directly in the table?

I would like to insert a link in my automated email to an interface page that I've just created and published. But it doesn't show up in the "Use data form..." popup - see screenshot?

im having trouble with grouping and field visibility fields in list interface.i have a mega table with all users, tenants employees suppliers. i created tabs. but as soon as i groupe the tenant tabs by their property building it groups it for all other tabs. same for fields. lets say i want the email in tenants but i dont want the email in suppliers, i cant its across the board

Being new to airtable and not wanting to pollute the forums with silly questions I can look up myself, I've been trying to go to the online help to solve my own questions.  Unless I'm missing it, most of what they provide is an organized set of articles which is to be frank, frustratingly useless to this old school gray haired developer.  I was hoping to find a simple itemized list of terms with reference/example type information, almost like a dictionary. Every other programming language has this kind of thing, and you can easily find terms that sound like what you want with a quick description (reference style) and a few examples.  Does this kind of thing exist, or is it just the article format?  I know I can pay for teams and do the AI thing, or go ask chatgpt, but I'd rather just do it old school and research it quickly.Thanks.

Hello, in a form, i ask people to select some items of a multiselect field. them i would like to create a new field with the complementary -> all items except the selected ones). do you know if there is a way to do that ?

Hi all,I've been searching a solution for creating (adding) an automation to table that is created via API call.Simplified process would be: 1. User adds a new project (to another system) [OK]2. This invokes process that creates AT table (to existing base) with all the needed colums etc. [OK]3. Turn automation on (via API), that sends data to another system when a "Status" field is set to "DONE".I know that I can achive this using a webhook, that listens field changed, but.. As the automations are already there, it would be more elegant process from maintaining perspective.Anyone countered the same, or found some other way to achive this?- EW

Does anyone know if it’s possible to access a list of a bases Automations (and corresponding steps) via Airtable API? If not now - does anyone know if it’s on their roadmap? Desperate for it :pleading_face:

All:I have imported data from an excel into an existing table in a base.  The existing table is called "Income Account Transactions."  There is another table called "Profit & Loss" that links to Income Account Transactions table. It  calculates data from the table.  The imported data is not calculating into the Profit & Loss Table.  What am I doing wrong?

Hello!I am appreciative of any help on this one! I have spend way to many hours of Youtube trying to figure this out. Problem: Cannot import a CSV file to a synced tableScenario: I have a new table that is synced to another base (that part is working perfectly!), but when I try to build out the new table it will not allow me to upload a CSV because the table is being synced. I have 450 columns (fields) that I need to add that have already been mapped out in an excel file. I would LOVE to save hours of manually creating each field and have it upload into the synced file. I'm not worried about it updating the records (rows), I really just don't want to have to manually add each column. Is there any other workaround I can try?!

i'm trying to make a formula to pull out the last name from a field that sometimes has full names in it & sometimes does not. i found this formula in a very helpful Airtable blog:TRIM(MID(SUBSTITUTE(Employer," ",REPT(" ",LEN(Employer))), (3-1)*LEN(Employer)+1, LEN(Employer)))this worked for me when i was parsing a field that always had "Title First Last" as the number of words. however, my new field sometimes has a middle initial. i changed the formula to (4-1) to account for the middle initial, but it doesn't work for names without a middle initial.i'm guessing there's a way to tell the formula to look for the word that is the right-most word separated by a space, but honestly i don't even fully understand this formula, so i'm not sure how to modify it.Here's an example of data in the original field & the output:

I have a table of 100 members of our makerspace. There's a ROLE field that is multiselect that has Lead, Board Member, Officer, etc.  9 of the members of the "Member" table have "Board Member" and I have a subsequent view called "Board Members" that filters to show all board members (and that have an active status).I want to have an automation on another table (Applications) that would send a gmail to each of the 9 members in the "Board Members" view/grid. Does anyone have an example of this?  FWIW, I want to include a url of a fillout form including the RECORD_ID() of the application record as well as a parameter of the email address to pre-fill the board members identifying information so when they approve/comment on the form we can identify the source board member.Thanks in advanceJeffPS: I know that on the free plan there are limits on sendmail to non-airtable emails, but that gmail might work instead.

Can someone give me some advice on how to update the yellow columns as shown in the example below?I have a fillout form that the approvers can update the approval status of the applicant. On saving and the record gets updated, I'd like the counts updated.  Would I do this on an automation of a record update of the member approval table?  

Hello to you all !! I’m facing an issue. I’m totally new on airtab and I’m trying to create a data base. I have a table where I will put a name of a project and a mutiple select fied with the companies that are in the project. I would like to create a data base for those companies and to be able to do so, i need to find a way to create an automation thats is going to take every company from the multiple select field and create one independant record for each one of them in my database table. I would love to do this without a script because I’m on the free subscription. I would really use your help. Thanks in advance and have a great day !!!