Other Questions

I have a list of classes. They are numbered (primary key) and have an associated class date. There is one class per date. I also have a list of registrants. They link the registrant name to the assigned class number, date and instructor. I can group and view my registrant list by class number and add registrants in this view. But, when I group registrants by class date I find I cannot enter new registrants - date appears to be a calculated field. It would be easier for us to see the “July 6th, 2021” class in a grouped view and add registrants that way. Any suggestions? Thank you in advance.

Hi Community :slightly_smiling_face: I would like to send daily reminder emails to our customers in an HTML format. There will be three variables in the emails: A URL link to their daily tracker (which is unique to each customer). An inspirational quote which changes daily. Set to send at 7PM daily, as per the customer’s time zone. I currently have set this up using Airtable/Zapier/Gmail, but there seems no way to automate the changing of the quote daily, I have to go in and manually change each customer’s every day. In addition, as I want to be able to send this to up to 50 customers, the Automations function on Airtable will not allow this as it is exceeds the limit. Would Integromat be more useful than Zapier in this instance? Any help would be greatly appreciated.

Hello Airtable wizards, TL;DR How can I make this “view” ? I am new to airtable and just jumped on building a new directory like site. I was able to make one directory embedded inside my wordpress site as a “card view” type but now I want to have this “slim” one row like view. Can’t find this instructions inside training video section. Anyone ready to give me some hints how can I do this? Should I use “grid” view instead of gallery/card or sth. else? Thank you

As I have orders in my orders table I want to scan the orders by the scanner and update the status to scanned please guide me on how to achieve this.

This is a really simple question, but is there anyway to restore historic data? We had a form in AT that had drop down options. We had people fill out the form. Then, someone on our team changed the options in that drop down and we lost historic data that people had filled out. Is there a way to find their answers or when we changed the drop down options did that data disappear forever?

I tried CSV import app. When I do, the app only uploads to one tab at a time and that does not work, see the video for a problem and please suggest a solutions.

I am trying that after updating a record in one table (Example: Table 1) this creates a new record in another table (Example: Table 2)

Hi community, I am a begginer and french… but I’ll try to be clear and apologize if my question is basic. Context : I want to follow the global time spent on each project by month. I have the time by day and want to sum(values) only for the month in the first column. It may be easy but I can’t find the way :frowning:

Hi, i didn’t found an answer on this thread : Integromat and Duration field Development and integrations Hey, guys. I have an issue with an integration of mine. I’m extracting a time from a string from Google sheets and then putting that time into Airtable. I want to put it into the duration field, but it will not accept it. Does anyone have any idea of how to format this correctly or work around the duration field paramaters? Thank you! I tried to enter an integer for the duration field but it says the value cannot be accepted… do you know why ?

Hello! I have been organizing the content of my company’s information for a few weeks and got to the point where I could set up a customer table from my list. When I choose what information is going to be present, and then group the information, even though the essential groupings are identical, Airtable is breaking the information up. You can see the attached screenshot (with names redacted) for an example. Customer Relationship and Market Sector are the items that I am grouping by and this is what happens: Is there some sort of metadata that could be causing this issue?

Hey guys. Is there a way to add lines (horizontal or vertical) in the Page Designer app/block? What about a way to add custom page sizes in inches instead of just pixels? (I’d like to add support for 11X17 sheets.) If there isn’t support for these, is there a way to submit a feature request to Airtable? Thanks! Landon

Hello! I’m looking at this Help article about using multi-step Zaps to find and update records in AT: Airtable Support Using Zapier's Multi-Step Zaps to find and update records Zapier is a third-party service that connects Airtable to many other apps and services. This article is specifically designed to teach you how to design Multi-Step Zaps for the purpose of creating ... …and I’m wondering if it’s possible to use the Search Formula field to ask the Zap to look at TWO fields to identify a record in AT instead of just one? My problem is that there’s no ONE unique field that would allow the Zap to locate a particular record; I need it to consider TWO fields. For example, it can’t just look at Content Type OR Due Date, because neither of those is a unique field in the view; it needs to look at Content Type AND Due Date to identify the one correct record. Is this possible? Thank you!!

Has anyone interfaced Calendly into Airtable? We need to have our presenters book their rehearsal times thru calendly, then have that data synch up with the presenter’s name in AT. Can it be done? Is this an IFTT opportunity or something else?

Hi there. I have setup an airtable form, which I have embedded on our website. Is it possible to put a Facebook tracking pixel on the form submit button so I can see whether our advertising is working or not? I would be really grateful for any advice. Thanks, Rosie!

I am trying to make a pallet packing list for an order. I have already made for smaller orders. But I have one order that is spreed on to 4 pallets. I have been using paged desinger to make the packing list I have the order in tow tables, one with the ower all data and the other with the product data and how many bottles I pull that data into this page design I need to divide this up to so I can have information on each pallet grouped together. Now I have made one more table that has the pallet layers on it, I am not sure that is the right way to go about this so all ideas are welcome Regards Eva M

I’ve got 2 fields set as ‘Last Modified Time’ types, and updating those based on another field being updating. However the timezone is GMT, even though I have ‘Use current timezone for all collaborators’ turned on. Any suggestions?

I am trying to create a section but my Airtable does not allow me. Now all my views were moved to “more” and they are grouped with a bunch of random views. Help! I need to be able to create my own section!

Hi everyone, is there a way to change the first day of the week when I open the “date” filter? Here in Italy the week starts on Monday

Hi, thanks for any assistance. I’m working on quantifying the time that I am spending on each of the steps in my production line, and am using a datediff formula to compare the last modified date to the start date, divided by the quantity of the steps i have completed. It works great to give me an average of each of the steps, but I would like to be able to also get a “lap” time for the current step. In other words, if i have done the step 10 times in 15 minutes, that means it is 1.5 minutes per step, but i would like to know that the last iteration took 1.4 minutes, vs the previous one was 1.6 minutes, etc. The goal is to know both the average and then the last one, so i can keep track of how i’m doing. Whatever formula i am trying to create is not able to compare the last modified time of the current iteration to the previous one. Any ideas?

Hey, I am having trouble with a formula using multiple IF statements with OR and FIND. Essentially, what I want to do is assign certain statuses to a single text-based column called “phrases”. The column contains a variety of food types that are embedded in sentences. I want the following functions in one formula column: -If a cell in the “phrases” column contains the word “strawberry”, “grape”, “apple” or “raspberry”, then assign that record “fruit”. -If a cell in the “phrases” column contains the word “avocado” or “squash”, then assign that record “vegetables”. -If a cell in the “phrases” column contains the word “rice”, or “quinoa”, then assign that record “grain”. -If a cell in the “phrases” column contains the word “milk” or “yogurt”, then assign that record “dairy”. -If a cell in the “phrases” column contains the word “butter”, “olive oil”, or “fat”, then assign that record “oil”. -If a cell in the “phrases” column contains the word “chickpeas” or “lentils”, then assign that reco

Hi all, I’m asking this question, knowing that it can probably be done with a Pro account. But the thing is it’s the only thing I would need a Pro account for, changing “Submit” to an equivalent in French, in 2 forms. So, Is there any way to change just that without paying 20$US per month (more like 28$CAN here)? I don’t mind at all paying for an account if I will use many features. But just for that, its a bit much. Thx for any insight or answer!

I’ve connected a check-in check-out template to a Softr page and we can update inventory from either side, which is great. However I’m trying to add a new item which has a quantity of 24 however, when I jump over to Airtable there aren’t 24 individual records. Is there a way to configure the base so that when we add a new item with more than 1 quantity the base automatically creates a record for each individual item? Thank you!

Would it be possible, or is there already a way, to view 360° photos through Airtable?

I am on a plus account and want to sync this job board. Airtable - [Public] 80,000 Hours job board vacancies I am only able to make a copy. Why is this?

Hey, Webclipper is great but it keeps the browser scrollbar when I take a page screenshot. Is it possible to not have it ? Also, is it possible to choose the size of the image that is taken and upload into the airtable base? Thanks