Other Questions

Hello, I have created a property management base where I have multiple properties and for each property, I have multiple tenants. In the “Tenants” table I have all the information of the tenants (rent, deposit, move-in date etc.). In addition to that, I want to enter monthly rents received by the tenants and also their electricity bills. I have thought enough but not able to figure out a way to do the same. Please help me out with this one.

I have a scenario where i lookup a list of values for an item in a google sheet and want to add them as complementary values in one multiselect field for the item in airtable. in the shown example these are 12 category values coming from gsheet, which should all be added in a multiselect field for the user in airtable. The lookup in google sheets and the JSON creation and parsing work as expected - I get a JSON with the categories like the one in the screenshot below: The update in airtable works as well - as long as I have the JSON list elements mapped individually as single entries for the multiselect field, like indicated here: The problem with this approach is, that if my Gsheet Lookup and resulting JSON send less list elements to airtable than I have specified in the integromat flow, the extra fields will be sent as “null” and this causes an error in the Scenario. This is exactly the same problem as described in this post 10 months ago: Mapping Multi-Select Fields with Integrom

Hi all I’m running a survey through Airtable forms and would like to make sure that the same person (read, device) only takes the survey once to make sure results are reliable. Is there a way to do prevent people from taking the survey more than once from the same device? Thanks Alice

I have a gallery and I added a filter with two condition, so if column one has a specific value or column two has a specific value. That works fine, but now I want to also only show records within the past week that match either of those conditions but it doesn’t seem to let me use a date filter combined with an “OR” condition. It will let me do date AND column one, but after that it only lets me add more “AND” conditions. Is this just not possible? Is there another way to do this?

I have a series of single selects, and I want the “default” blank to be red. Or will I need to have an automation to put a red warning right now the filtering in the calendar is set by the {Videos Status}, however I want the default to RED to stand out but I don’t have a way to set default either in the original field with the single select nor the filter. Any ideas?

When I update a record in a base, obviously the location of that record changes based on the way the view is being sorted. Is there a way to go straight to the new location when the record is updated?

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?