Ask the Community

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 !!!

I'm working on a tracking system for a coral restoration project. To report coral bleaching to my Bleaching Report table, a user selects a date and all structures where bleaching was observed (linked to my Structures table) like so:Bleaching Report table:I would like to add a new record for each structure along with the corresponding date to a different table, like so:Structure Bleaching table:I tried setting up an automation which triggers when a new record is created in Bleaching Report to create a new record in Structure Bleaching for every linked item in the Structures field, but it seems only 1 record is being created even when there are multiple structures linked in the field. Here is my automation setup:

I'd like to buy a book (or 2) on Amazon (or other) that I can use as a decent reference for scripts, formulas and other advanced topics and would love some suggestions. Given the ever changing nature of products such as Airtable, I want to make sure I buy something that is relatively recent that would have the newest features, or at least most of them.The basic stuff (field types, etc) are self explanatory to me, so hopefully a book that has more solutions than the core fundamentals of which I've mostly been able to learn with vids and the like. I know that the basics will be covered in any book, I just want to make sure the back part of the book with the advanced stuff is relatively deep in content, if that makes sense.

Hi All,I'm fishing for some ideas on how to structure my Project Tracking Base. Here's what I'm trying to do:I have Projects in a table, with a Project Manager, and Team members assigned from my People table. I do want to keep track of the role of each person on each project. This role can be different for each project they are working on, so assigning them to Departments or Roles in the People Table does not work.I'm hoping to not have to create another table (let's call it Roles for now), since it I think it will complicate the Interface. I want people to simply add team members to the Project in pre-defined roles.The other way of doing it (easier interface) means having a field in the Projects table for each role. Trouble with this approach is that new roles keep on being added (as needed on projects), and I can't be editing fields, forms, interfaces, etc. each time a new role is needed.Any suggestions on a better way to structure my base to acc

I'm building a task tracking app within airtable to use with Glide. I would like to do a rollup of total hours spent on each task bucket (four in total) for the current month, week and day. I cannot figure out how to do a sum of each task for those time frames as a numeric value and hours spent on each task. Any help appreciated.

I am attempting to create an automation when a record is created in a specific table that will see if that record exists in another table and if it does, update the record that was just created with a date out of the other record. I'm not sure at what point the automation is suppose to run for the new record being created, but it seems as though it is running too soon and not waiting for the piece of data it will use to look up the record in the other table. I hope that makes sense. If anyone has any ideas, i would appreciate it.

Hello everyone. I’m still new with Airtable but I’m trying to learn. I am integrated in a sports club, volleyball club. I’m trying with Airtable to make a table that updates results of games. The idea is that each team director can enter the results of a game in a simple way, and then get the complete list of results. Is there any template that does something similar? If you guys can help me I’d appreciate it.

Hi. I've got a base in AirTable which I need to be able others to update through a form in fillout. I only want specific fields to be updated by the form. In the case as shown in the screenshot I only want people to change the status and no other fields. When I chose to limit who can edit fields such as name, email etc to nobody but leave the status field as editable by anyone the form doesn't update that field. I only manage to update the status field when all other fields are editable but then it will obviously create an issue that will allow people to edit the base. The idea is that people would report status updates by the form and they would need to see certain fields of the form.  Could anyone point me to some resources on how to accomplish that? Thank you.

I have a base with different tables, each one linked to other bases. Is is possible to edit an attachment field? I am able to edit other type of fields, as for example, checkboxes, but not the attachment ones... 

Hi. I've searched for a solution for this, but no luck (yet). I tried THIS but it didn't do what I needed. In the referenced example it had a single action for each task, which assumed a fixed list, and my source will vary.I have 3 tables:Application (record trigger)Board Members (grid view of filtered table "Members") currently 9 records in view.Member Approvals (goal is to create 9 records, 1 for each board member and has application data.When an application record is created, it should trigger the "find records" on the board member view and create a record for each board member and include all the application data in it.  However, when I do this, it wants to create a single record and a comma delimited l