Other Questions

Hi, Im new to airtable as I see it looks better than excel for doing table and database. I have issue with linking table that has one-to-many relationship. I have Movie Database with 3 tables; 1. Movie, 2. Genre and 3. MovieGenre. MovieGenre stores relationship of Movie and Genre. where 1 movie can have multiple Genre. The way I structure the table like below Movie_Table MovieID | Title 01 | Jurasic Park 02 | Indiana Jones Genre_table Genre_ID | Genre 01 | Action 02 | Adventure 03 | Fantasy MovieGenre Table MovieID | GenreID 01 | 01 01 | 03 02 | 01 02 | 02 I imported those 3 tables from excel. Now, what I want to do is to have Genre on my MovieTable, which populated automatically. I try to link Movie_table and MovieGenre, however

Is there a way to see the base level audit of who has done what? We have a large Base with specific filters and groupings set on different views, and someone keeps changing these filters and views. We’d like to know who is doing it so we can stop the behavior. This is not record level, it’s base level. Thank you.

Hello airtable community, When we use the airtable, we have a lot of fields. Lets say we have fields 1 to 10 and 1 is titled “apple” and 2 is “strawberry”. If there are too many fields, like 100, and there are like many charts in different folders, is it possible to search the title of the field? I don’t want to open the charts one by one, but want to find a way to search for the name of the field to quickly find the location. And is it possible to create a separate new folder with a chart that contains all of the fields and its data in one sheet? If we want to do that, does airtable allow us to do so? I would love to hear wisdoms from the people in this field.

I’m in the process of putting together Airtable for my agency. I used the registration form which I can embed on my Wix website. Then once it’s completed the information automatically goes into my airtable. Unfortunately I’m struggling to get it to work properly. I have the application form then it can be completed and submit. However the information is meant to go straight to the Airtable grid but it’s not working. I have done some research on Airtable and it says the following ‘Embedded forms use popups for redirects so you must allow popups on your site in order for forms to function properly’. I contacted Wix and they said to contact Airtable. The other option is to change from embedded to having nannies click a link to the form that opens a new browser page. I’m struggling to figure out how to do that. Any thoughts are welcome.

Hi! I’ve tried to read on my question since a lot of people also ask about it in the community but I’m still not very clear with the answer, so I will share my specific scenario to be sure. I’m setting up Airtable workspaces for a Company that will have 9 Pro users. By this, I initially assumed it would be $20/year per user. BUT… it got a little confusing with the different shared workspaces. So the 9 users are spread into 3 different departments: 3 users in HR, 3 users in IT, 3 users in Sales. Each team will have their own workspace. But there are some processes where the Sales Team needs to share certain Bases from their workspace to the 3 people in IT Team to complete a process. Does that mean, even though the 3 IT Team are already paid Pro users, there will be an additional $20*3 users for them to have Editor permissions in specific Sales Bases?

Hey Community: I built a pretty extensive base that tracks all the places a band has been. I want to be able to have a formula that will take this field’s output and make is a list. I will never know where the commas may fall for the names of the places. A sample result in my field is the following. , , , , , , , , , , “12-11-20 - New York, NY Rockefeller Center”, , , “10-27-18 - Bridgeport, CT BRYAC Restaurant & Raw Bar”, ,

To filter effectively I need to group records with the same records. Need a filter to show only records that fit certain criteria. IF QUOTE is blank OR SCOPE is blank My biggest obstacle is figuring how to run this filter based on records with the same WO#. If Airtable formulas were easy to write it’d look something like this: IF WO# is duplicated and Quote is blank or scope is blank- hide field. Any suggestions?

Has anyone else had a view fail to sync after syncing just fine for a long time? I have several views from several tables in a source base all syncing to another base. All but one are still fine. No matter what I do, that one table will not sync anymore! I’ve tried refreshing the sync, changing which view is synced, creating a new sync in the same recipient base, and even syncing that same view/table into other test bases, and it will not work anywhere. Airtable Support was baffled as well.

i just discovered that Airtable treats email addresses as case sensitive. when i tried to dedupe, it didn’t flag an identical email address because the record had been entered with different upper and lower case letters. is there a way to force it to view the email field as “not case sensitive” so that it identifies duplicate records?

I want to reorder fields in Airtable for all views. Is that possible? I currently only see the capability to reorder fields on the current view, which means I would have to manually reorder each view

Long story short, I’m making an expenses table, however, I don’t want to create a new table for each month. I’m trying to make a grid for May, and a grid for June. My problem is these grids seemed to be the same grid. If I add in any June expenses, that also goes into my May expenses grid. Is there a way to unsync grids? Or to have two entirely separate grids in one table? Any help would be greatly appreciated.

hi , I would like to get documentation on upload documents to Airtable using API in javascript.

Hey all, I am trying to generate a date in a formula field by using the data from two other fields. -I need the formula to read the datum in the {End Date (Current)} field, determine if it’s blank and then if it is not. want it to then calculate the date based off ANOTHER field {Days Notice to Cancel}. And if it is blank I want it to say “1”. So far I feel like the below formulas need to communicate but I am not sure how to combine them to make them talk properly. (however, any suggestions are helpful, even a whole other formula combination). IF({End Date (Current)}, “field is not empty” DATEADD({End Date (Current)},-{Days Notice to Cancel},‘days’) IF({End Date (Current)}, “field is empty”, “1” TYIA!

Hi there, I have created a table I would like to send to 10 to 20 different people. There is one column that has a checkmark option - this is the only option I would like them to edit (check or leave empty). There are more than 200 rows so it’ll be difficult to simply send out a google forms and concatenate inputs into a table. I was wondering if anyone would like to suggest a clean way to collect this data without having to create 10-20 different tables to send to each person? Thank you very much for your time! Warm regards, Michelle

I am the founder of a startup in the no-code domain, and we provide excellent integration with Airtable. However, we don’t have access to the meta API, affecting our users’ experience. We did put in a request a while back but haven’t heard back. Is there any way to get access?

Can anyone recommend a barcode generator I can use via an API and then save it to a field? I’ve been looking at the Generate Barcode Images in Bulk on Airtable - miniExtensions, however would like to try make a solution myself, as i’ll only generate new barcodes every know and then and not all the time, hence the $39 a month is slightly too exspensive for me atm. So I’m thinking if something would be possible with the scripting app?

Hi Airtable team, Hopefully this is a simple one for most of you… I have a single table (because I use the Org Chart app and it’s restricted to a single table). Each record has a status field and also has a field to other linked fields in the table and also has a lookup field for the status of linked fields I would like to: have a field that automatically looks at the status of the linked lookup field determine if at least one of the values = “To do” then set the status of the record in context to “To do” Any ideas? Thanks in advance Team! Paul

I have a date time field being sync’d from another base and I need to reformat that MM-DD-YYYY HH:MM into a true date time format from the string it comes in as, as a sync’d field. Any ideas?

Hi, See the attached, I have tried to export a table to CSV format, but few of the values have been changed and instead of the original values I have got 000. What am I doing wrong?

Is there a way that i can embed this to my client portal on my own website and have it set up to where my clients can view there individual column with out seeing anyone elses info?

Anybody have ideas on when the Matrix App will be enhanced to include Date fields? That is the ONE missing piece that I need for the app to actually be useful for me. Any suggestions on what I can do in its absence? :slightly_smiling_face:

Hey team Is it possible to build a twilio IVR that searches and creates records in Airtable? I have zero coding experience so any documentation and support is appreciated. Thanks

Hello, an animal rescue charity has told me their existing database provider has stopped their plans for charities so they need another platform. I think Airtable may be perfect for them. I have exported all the data from the old system and have it in two CSV files. I have imported the CSV files into two tables but unable to link the two together automatically. The two tables are customers & animals So each animal is linked to a customer by a customer_id record in the first column. I am looking for how to make these links work as there are a couple of thousand records, far too many to consider doing manually. Does anyone know how to do this? Thanks Paul

Hi all, Looking for help on this issue. Created a zap to alert me of a new record in a view. When it sends the message, it garbles my field data. Dates work, but any text fields do not. Any advice/assistance?

Hi all, I have figured out a lot of the rich features of Airtable in my free version but I can’t figure out how to send a simple email to one person. Think of this as direct sales. My sales person wants to send an email related to a conversation so the email has to be unique and it will only go once. How does she do that? OR, we want to send an email to all clients with a specific status but, again, it’s a unique email, not something that should happen on an automated basis. Can I select the status and do a group send of a unique, one-time only email? Your help will be extremely welcome. Janice