Other Questions

Hey everybody! I’m looking for some help and guidance in regards to matching dates and then providing relevant emails that are associated with it. Here’s the situation: A user fills out a form on my website that lists dates and times that they are available (up to 7 dates) I have it zapped into a table. In the backend, I’m manually finding events and uploading it to a different table in the same base. I outline information such as the link to the event, and the date/time it starts. As soon as I put the start date of the event, I want it so that the email of the user that says their available during that time to show up and match, or some sort of organization system that gives me the people that are available for that event at that time. Is there a way to do this? Should I create another table? I added two screenshots for reference. This would be so helpful - thank you. One thing to keep in mind is that

Hi everyone, we love Airtable but are having some trouble setting up certain integrations. We use Process Street to document our workflow and have a number of checklists set up. However Process Street leaves many things to be desired, which Airtable does well. Our goal is to use Process Street to document processes (with checklists), and have those items Zap’d to Airtable for a high-level overview of where each project is. The problem is, I’ve been struggling to connect the P St checkboxes to the appropriate column in Airtable - the column I want the info to go to is not an option, just the record. I get stuck when I’m trying to select the field for the checked task to appear in Airtable. I’ve tried formatting the column differently and it doesn’t seem to help. Is there an intermediary in Zapier (like formatter) that could help? Any thoughts appreciated.

Hi everyone! I am writing on behalf of my organization. We have qualified for the charity discount, but I am struggling with the best way to set up our team. I am aware that if we upgrade this would be for 1 workspace, correct? And then this workspace’s bases would be part of the paid plan. So im thinking that I would invite all my colleagues as collaborators (users) so that workspace. So my first question is: if I invite my colleagues to the workspace, do they see all the bases that I have created? Or only the bases that are shared with me? And vice versa? I am also wondering, if I am a ‘user’ on a paid account, can I then create another workspace that will have access to the paid base features? Or would that workspace not have the paid features because its a free workspace? Thanks in advance!

There is a new “Views” column that comes up on the left now. I can toggle it off, but it returns every time I open something new. How do I PERMANENTLY toggle it OFF? It takes up too much space and for someone used to using views regularly, it is not needed.

I setup Integromat to watch an Airtable base for a new record and then send me an email notification. It scans the Airtable one per day and keeps on sending me notification daily for records that it already notified me about. Is there anyway to set Integromat to ignore records that it already notified me about?

we have 3 users in the company with old macs but latest chrom versions that makes long text field types trigger an airtable js that replaces text with nothing or random characters. that worries me as users with out doing much makes data loss. in the begining my guess was the user was doing something funny but its a fact it was not the user, as soon as mouse is over the field we start to get replaces by js…

Hi, I need to provide my management with quarterly and yearly roadmaps with months in column and projects in rows I usually do it in powerpoint but need and automated generation. Can Airtable do that ? Thanks in advance !

Hi there, i’m pretty new to airtable and trying to find some stuff out . On one base i would like a form for something like a order of our services. The order contains some sort of attachment like a plan as a pdf. Now i call the customer and make an appointment for our in house visit. If i put this appointment in airtable this should create a detailed Google Calendar event with the pdf which was send to us from the customer. I can’t figure out what exacly is the problem why i can’t find a good solution for this problem. Is this more of a Google Drive -> Google Calendar problem? Any suggestions for me? Thank you, Sven

Hey guys, I’m trying to basically update the field of every record while in select mode, since I need the recID, is there a way to be able to use .update while in .eachPage?

I would like to link my airtable calendar to a third party calendar app. I am willing to use either apple calendar or google calendar, either would be fine. But, I seem to have come up agains some limitations. With airtable/google calendar integrations, you can do these actions (using Zapier to link the two): creating a new airtable record will create a new google calendar event creating a new google calendar event will create a new airtable record updating a google calendar event will update an airtable calendar event With airtable/apple calendar integrations, you can do these actions (using an ical subscription link): creating a new airtable record will create a new apple calendar event updating an airtable record will update the associated calendar event The issue is with updating events. It seems, if I use google, I can update from google to airtable, and if I use apple, I can update from

hello Airtable Community, First sorry for bad English, hope you can understand me. For my hotel I need to create an automation between Airtable (our CRM) and Google Agenda, where every record (room booking, with important informations about customers) create an event in our Google Agenda. I have already created an automation with Zapier which create an event in Google Agenda every time I create a new record in my CRM. But, when I change a field (exemple : after create the record, I have to change the phone number of a customer in a field), it do not change the phone number in my event on Google Agenda. It’s a trouble for me because if me or a coworker insert a wrong phone number in a new record, the correction do not put the correction on google events, which is our main booking interface. Thanks for reading and helping me.

It seems .png files aren’t previewing in my base anymore, which is making the Web Clipper block a lot less useful now! Has anyone else had this issue? Right now I have to download the file and convert to JPG then reupload for them to preview, but .png files used to preview automatically for me.

I’ve implemented a page designer block. One of the fields is a linked field that I’ve got displaying as a table with multiple columns. There are so many rows that the data needs to go to a second page for some of the records. But, the block just truncates the data at the end of the report page. Is there a setting somewhere to change this behavior?

Hello community, Hope that you may help me with this one. I am trying to build a system that will help my with inventory tracking. So far so good, and there are many great templates and tutorials out there. HOWEVER, I haven’t figure out yet how to solve my issue: From time to time, employees take equipment from our warehouse for a specific project, and I want to keep track of everything. I thought about making a table for each time someone takes something, and then finding a way to reduce the amount of available items from the amount of items that went out from our warehouse. but - I have no idea how to do that. Making a row for each project is not ideal as well, because each project uses several items with different quantitates. Any suggestions or tips? THANK YOU!!!

Hey all, I have two tables that I need to link. Table 1 is a table which gets daily new info. In one column, I have to concatenate. This changes daily with the new information and therefore needs to stay as a formula. In Table 2, I have a sort of database of possible concatenation options with responding values. These two values need to be selected according to the newly created cell in Table 1. In Excel, this could be quickly done via a Vlookup, but I struggle to do this in Airtable. Has anyone had a similar problem and can offer a solution? If you need more info, please tell me. Thank you

Hello, I have a question regard to billing. Is it possible to set the owner in PRO account while other billing collaborators under PLUS account? Sincerely, Michael

Hi! I am building a CRM base (This is my first one!) One of the fields is “due date”. is it possible to mark a record that is overdue for 3 days? Daniel.

Hi all, I have tried for over 2 hours to get this to work, but can’t seem to. I am trying to update a barcode primary key field. but the closest I got was this error message: Type ‘string’ is not assignable to type ‘{ text: string; type?: string; }’.(2322)

Is there any way of moving completed records to a different table so that I can remove finished jobs but still be able to access them for invoicing reasons? A previous recommendation was to filter to exclude certain records but I can’t for the life of me see how to do this! TIA

Hello, When I add a new client, there are a series of about 40 tasks that need to be done and tracked. Is there a way to automatically create those tasks in airtable without having to re-create every single one? Thanks!

Hi I am setting up an Integtomat scenario to backup Airtable bases with Webhook and using Airtable API. I am using blobjson to create and make a call. I keep getting a syntax error. What is the correct syntax for JSON? I have an HTTP module in my scenario, bug I don’t know what endpoint fo I use on the HTTP app. I have two linked tables, so do I use “Retrieve Records” or “Create Records” in Airtable API? Thank you, Mary I can post more info., I sent just going out. Thank you!

I have two columns that I pull data in from to make a linked form. Third column (forms) needs to have “clients name - root form” like “Yoga studio - Yoga Waiver company”. This now links the form to the second sheet, where we keep the status on each project. One client/record often has several documents and each o them needs to have a separate status. Something like “Yoga studio - Yoga waiver Company” and “Yoga studio - Employee agreement” does anyone know how I can auto generate the third column?

Hi All, I have created personal views for users since multiple users are working on the data. They are editing/adding the data in their sheet only and the same is being reflected in the mother sheet which is a consolidated file of all the users data points. Now, we are facing the issue that there are some data points which are being shown in the Mother Sheer but are not reflecting in the user’s personal views. How is it possible? Can this happen if a user deletes the data in his personal view and the same is not being reflected in the mother sheet? What am I missing here Thanking you in anticipation for the help and support.

I have a question about the billing process and why collaborators are so expensive. I used to have a Pro account because I wanted to create a form with our own logo at the top of the page (this was the only reason we needed a Pro account). That said, it was a form for a singing competition. I wanted to bring in a few judges to see certain views created for them as a part of my base and judge entries using the table I set up. When I invited them in, I quickly realized that I was about to be charged $24/month PER JUDGE because I was giving them access to edit my table. I was shocked and so frustrated. $24/month (I didn’t want to pay for the whole year because the competition (free, no money involved at all)) was only a few months. Anyway, I was shocked that I was expected to pay for a FULL ACCOUNT for each of these collaborators. Why?!? Seriously, why?? If I have a pro account, and I invite someone to edit one page of that account, I have to pay for them to have a full a

Is it possible in Airtable to create some kind of company hierarchy such as: Company 1 (parent) Company A (child) Company B (child) Company C (child) Company 2 (parent) Company A (child) Company B (child) Company C (child) To try and help you understand what I have and what I want to achieve, I have simplified my base as follows: I have an Accounts table: I have a Projects table: I have a Tasks table: What would I need to do to find out (link) which projects/tasks Company 1 (parent company) are