Other Questions

Hello there, How does it work with the privacy of Airtable? Can I trust that my data is safe at Airtable? With kind regards

I store price data in a Products table, and link to it in an InvoiceLines table (Many InvoiceLines from One Product). However, when a price changes (is updated) in Products the original price of that item should not change in those records in InvoiceLines that have already been created. Given the Lookup type doesn’t offer it, can you think of a way to achieve this? At the moment the only way I can think of, is to export data from one table and import to another?

What do I do to solve this problem? I’ve been trying to join in with my new colleagues but can’t accept their invitations. I get this message over and over with no instructions on why it’s happening or what to do next. When I type the Airtable message into the Airtable support searchbar I get over a hundred hits but none of them tell me how to fix the problem. When I go to Google for help the search engine autofills my question right away, which tells me that lots of people are having this problem. I wonder why Airtable does not help people in this situation, but I really need to know what to do next.

I am the owner on a team account. I have 2 creators and 7 editors. The 7 editors are not on the entire workspace, but rather on the bases I want them to have access to. I have one base I'd like to create, but I don't want my other two creators to have access to it (sensitive budget information). But I can't find a way to do that without taking away their creator status and I want them to keep that- they've been instrumental in building bases and will continue to do that. 

I am having trouble understanding the WORKDAY_DIFF and DATETIME_DIFF. Primarily I need it to return hours and minutes within 5 working days. Not just whole days with the WORKDAY_DIFF and not just total hours and minutes including weekends with DATETIME_DIFF. Example: Start a project at 4:25 pm Friday and finish at 9:40 am Monday, I would like my Turn Around column to say 2 hours and 15 minutes (2:15). I do not need it to round up to the nearest whole hour. I would appreciate any help you can give.

Hi. Corporately we are starting to use MS Planner, has anyone achieved any level of integration or linking with AT please? Ideally I’d like end users to be logging tasks in planner and they are automatically logged in AT. Regards Rob

Our organization is currently on the team plan and as owner of the team plan, I want to grant owner permissions to another user but it seems this is not available on the team plan.  Is that correct?  If so, why not?  Please consider improving user management on the team plan.  It is not very user friendly and limiting.  

I have an Airtable base with two tables: “PT” (where students submit a form to reserve a date) and “Available time on Math Classes” (which lists all possible date/time slots as text in the format “M/D/YYYY h:mm A” as a linked record). In PT, after a student picks the first date, I use a formula to calculate three more weekly dates. Then I add a filter to find each date in “Available time on Math Classes” and hide them, so whenever the students are willing to book a date and time the other students can't book the same date/time.Despite having matching text formats (and manual searches confirming these slots exist), the Find records step in the automation always returns “No records found.” I need help pinpointing why the automation won’t recognize an exact text match and ensuring these additional dates are properly found and marked as booked. Or I need a way tha

I am creating a scenario in MAKE to add a new record to my student database once a student is marked as enrolled in my admission database. Everything works well, but I am facing one issue. I am able to use the HTTP Module and “Upload to Google Drive” Module to add the student photo correctly to the student database. However, I have two other file fields in the admission database that need to be synced, and they contain multiple files. How can I ensure all those files are added without missing any to the student’s database?

Hi everyone,In Airtable, I created the a tables with 30 records and I have already sent comments for each records in Airtable. Then connect the Airtable and Tableau using web connector."Now, I want to display these comments as a separate column in  Tableau Desktop automatically and also wants  the newly added commenting records to show in Tableau desktop automatically without any third party tools".Could you share any detailed steps or alternative methods to achieve this?Thank you...

Hello,I'm new to Airtable, and have been struggling to find the best way to solve my problem.I apologize if there is a similar post for this problem, but I couldn't find any that helped me to solve mine.I'm currently designing a base with multiple tables where there is a repeated and fixed information that needs to be reflected in different tables and different tables have different purpose and calculation. Thus, I would like to know if there is a way to create a reference table where I can update the data once and have it flow to other tables as needed.To give more information about what I'm trying to accomplish, let's assume that there are 4 tables.Table 1 - Reference TableTable 2 - InvoiceTable 3 - BillingTable 4 - ReceiptIn tables 2, 3 and 4, there is a fixed amount that needs to be repeatedly reflected for different calculations called and let's assume that the field is named as 'Gross Item Price'. Instead of creati

Hi,I am looking for consultants to help with building a relational database in Airtable with our data. I am looking for private consultations and not courses. Please email nishanthi@redabbeylabs.com with details in addition to replying here. Thanks a lot!

Is there any setting to mess with or extension to install that allows you to have an attachment open, but not fill the entire browser? Unfortunately some of our uploaded attachments are scanned & handwritten PDF forms, but ideally I would like to be able to open the attachment easily in a side panel so I can both view the PDF and still access the grid view of the records and edit a few of the fields. For example, the PDF may have a date on it, name of who prepared the form, and a task all handwritten on it. It is uploaded to the table which creates an essentially empty record that just has an attached PDF and I need info from the PDF to fill out the rest of the record. Side by side would be ideal (some of the handwriting is beyond any type of attempt at image rec).

I have many different bases which will have a table that has attachments, and then linked records to other tables within the base which then lookup the original attachments. As of yesterday and all days prior, I could open the attachment in the lookup field in the linked table directly. As of today, I can still see the preview for the attachment being looked up, but when clicking on it the cell goes blank and it won't open. My attachments are mostly PDFs but I'm seeing the same "won't load a looked up attachment" in other bases with photos and word docs as the attachment as well. Looks like it is an issue in the web interface and desktop app, possibly not in the mobile app (android) though.

My record is an account with multiple individuals and I need a way to use SendGrid to send an email to multiple recipients on that account. I’ve tried using a long form with "email1@email.com; email2@email.com;" as the Email Address Field, but it only sends to the first email. However, the email that is received does show multiple recipients in the “to” field. Is there a way around this, or is Airtable just not parsing the subsequent emails. I looked at the SendGrid API and it looks like you need to compose your JSON API call with multiple “to” recipients and so I’m assuming that SendGrid is also only parsing the first email for actual sending. Really really important for us.

Hello, I need to figure out how to display multiple select options in a cell that is contingent upon another cell. I’m making a list of corporate goals, then under corporate goals I have department goals. I want my cell to display only goals that I choose from within the department goal category. I have one column for Strategic Goals, another column for Department, and another column that I want to use to display Departmental Goals. I want to be able to search within the Department to select the goals I want displayed within the cell without it showing me every department goal. Is this doable? Please help asap! Thank you.

Hi Airtablers! I have started a self-study to record day to day activities in my home-based caregiving initiative - taking care of my 91 year old Mom. I am using the default time setting in Airtable - 1/2 hour increments - is there a way to set it to 1/4 hour increments - ie. every 15 minutes instead of every 30 minutes? Thanks!

Hello,I'm looking for a solution that would allow me to build a front-end for my Airtable bases. I've already tried several solutions but I still have the same problem: I have a lot of buttons that trigger scripts (scripting blocks).I may have missed some features or solutions that offer this, but today if I have to migrate my scripting blocks to automation (to go through Interfaces) it will take me a lot of time. Solutions like Softr and others don't seem to allow this either.If you have a way of doing this without too many complications, I'll take it, otherwise I'll roll up my sleeves 🙂Thanks in advanceKevin

I have looked at a few of the prefix scripts but cannot find one that fits the bill for us.When a new record is created, our Ref field is manually inputted as:ABC2025-01 (Enquiry identifier - always the same 3 letters, Current Year, sequential number)Occasionally, the Ref field is filled with a subnumber, usually if a project gets split into phases. This is always manually inputted, so in theory the last project could end up being ABC2025-125-01.All we are looking for (hopefully) is once a new record is made, the Ref field is automatically filled with ABC2025-02, next record ABC2025-03 etcAny help appreciated  

We have an Airtable form to submit internal orders, and it would be very helpful for our team to have a field that shows the last record number before filling in a new order. Not to create the order number – we have autonumbers set up – this is because they have to add the current PO to one of the files that gets submitted in the form itself. Right now they’re going and checking the latest order number in the normal Airtable view before submitting the form, but if they can cut that step out it would be helpful! Is there any way to add in a view-only or read-only field? I looked at trying to integrate the interfaces with forms too and that didn’t quite get what I was going for. Thank you!

When we embed forms on our site, we write the title and description on the page for brand consistency across pages. I do not need the form title to be repeated in the embed portion. AT adds the form title by default in any shared view and there seems no way to delete it. Is there a work around?

Hi everyone! Newbie here still getting my head around Airtable. I am creating a form with 14 questions. The answer to each questions is a scale from 1-5, 1 being none of the time 5 being all of the time. When the form is complete I would like to be able to total the 14 answers for each respondent (so if someone answered 1 for each answer their total would be 14). How do I do this?! Many thanks

I am using record templates to create deliverables and tasks. I am setting due dates relative to the "current date".  For example, I want the deliverable to be due "1 day after current date". When the template runs, it adds 3 days to the current date. If the current date is 6/30/23, it will put the due date as 7/3/23 rather than 7/1/23. If I use current date alone, it puts in today's date. Does anyone know why this is happening and how to prevent it? 

Hi,I have a situation where a public user would need to fill out a form, be able to view ONLY that record with their responses (with additional dependent fields displayed), and then print that record in a nice-looking format.  I've explored other integrations, the public interface option, etc. but I can't find something that would work for the entire process.  Does anyone have any suggestions? 

When creating a Form view, it would be helpful to be able to specify a “Read Only” view for a specific field. I am using linked records to display data from other tables but in some cases, only want to display the pertinent data, with no ability to modify it, or to add a new record. Not seeing that this is possible at the moment.