Other Questions

I am trying to add hours to a Date and Time field. The formula I’m using is: DATEADD({Flight Date and Time},-{Time Prior},‘hour’) I want the result to be the date and time, X hours before the original date ad time. Flight Date and Time is a date field with time showing in a 12-hour format, and it’s exactly what it sounds like—the date and time of a flight. Time Prior is a number field, and is the amount of time, in hours, I want the transportation to be on-site for the flight. For example, .5 means 30 minutes prior. 3 means 3 hours prior. So here’s what’s happening: Flight Date and Time: 11/10/2022 4:00pm Time Prior: 0.5 Result: 11/10/2022 9:20pm It should be: 11/10/2022 3:30pm (.5 hours prior to the time) Any ideas as to why this is happening?

How do I create report that shows data from multiple tables? This is frustrating. I have been looking for a straight answer. I tried a long time with interface, but not able to pull data from multiple tables. Even look for a Rollup field type, not working for that. Please help.

Is there a way I can create a custom Url for my airtable form? I currently have a website with godaddy and I’m trying to create a subdomain to forward with forward masking of my airtable form. However I keep getting an error message. Does airtable not allow masking or am I doing something else wrong? When I spoke with godaddy tech support they told me to check if airtable would “allow me to set up a subdomain via DNS settings and if they allowed forward masking.”

When using the Airtable field ‘# Number’ Airtable is rounding off my numbers to always end with 000 Why? I’m using the field ‘# Number’ to receive data from JotForm. The data I need Airtable to recieve is the ‘JotForm Submission ID’ which happens to be 19 digits long. A JotForm Submission ID could as an example be: 5044932613496971504 In my integration between JotForm and Airtable the number is synced into an Airtable # Number field and come out as: 5044932613496971000 Why? :-/

I do not have any settings in my android app. Anyone else experiencing this issue? It just shows me my email address, a build code and a link to “Libraries we use”

Hello, I am new to Airtable and want to use it to register information for assistants to an event however although I have managed to load the form builder can´t understand how to publish it. Am I missing something from this tutorial? https://support.airtable.com/docs/how-to-create-a-form-in-airtable

I am attempting to build an investment portfolio tracker. I have it built in Access but am attempting to build it in Airtable due to the lack of web integration in Access. I want to be able to access the database from my phone or any device. I am struggling a little bit with manipulating the data. I currently have multiple bases which consist of single tables of what I call raw data. They are excel exports of transactions. All of these tables are similar in nature where they have a timestamp, an amount, transaction type, and a description. Why do I have them all as separate? Each service uses different terminology, date formatting, and also has variations on the color of the value in the export. By color, I mean positive and negative numbers. For example, one service might say $5 was withdrawn, but another will say -$5 was withdrawn. I am using basic IIf functions in Access to handle flipping the sign. By differing terminology, one service may say “withdraw” while the other s

Hi there, Discovering the incredible power of airtable here so there might be a simple solution i’m just not seeing. If that so, sorry in advance. I have already hundreds of views in my first table and would like to avoid doubling the number of views there. In all tickets i’ve read with similar questions, this is almost always the solution but maybe i missed one. So in Table “SKU” that i use for pricing, first column is my sku name and i would like that column to sync with the first column of my other Table “CSV” that i use to import products to my website. I tried linked records but it seems first column will not allow it. Also, from what i understood, link record will not add a line in my Table CSV if i create a new one in my Table SKU. Right now, I just copy-paste in other bases the SKU but if i can Sync that would be awesome as I would save a lot of time by not duplicating information manually. Can i do that? If yes, how? Thanks in advance AT Community! :slightly_smiling_face:

I am working a field trip application to organize field trips for my school. Airtable is definitely game changer for this! I met a problem on my budget tab: For each grade I have a total budget I can select the trip record from another TAB on a column named TRIPS for each grade The TRIPS cell can allow multiple records from the tab TRIP (if my grade 1 are doing 3 trips, we can select the three trips) I pull the total cost from all those trips. I need to show the remaining budget for each grade by a simple operation: budget - (total costs of all trips) But the problem is that the total costs for each trip are all in one cell. What should I do?

Hello, I’m wondering if it’s possible to limit the fields shown in the Kanban view when a card is expanded? One similar post said that it pulls data to create the Kanban view from the grid listed at the top of the list but that doesn’t seem to work for me when the card is expanded. E.g. I want one Kanban view to show different fields when the card is expanded than another Kanban view, or rather, hide certain fields. Thanks in advance!

Hello everyone My company and I have problems regarding a synced field in our database. When this database was created I guess there weren’t any problems with editing, but now when we go to the source of truth, and when we try to edit metrics, the new metrics doesn’t show in the database. We’ve tried to press "update sync configuration, but yet again nothing happens. Does anyone else experience this problem or have solved it before? See the picture for reference.

Hi, my google api account has billing activated and I don’t see any reached limits on the Google side. Still I’m getting API limit errors on the Maps Block when trying to geocode 4000 addresses (after every 200 or so). Any idea why this is happening? Also you would think if there are such limits on the Google API even on paid accounts then Airtable should be able to slow down the requests. This way you always need to remember to refresh the browser again and again. That’s bad UX. Frank

Hi everyone, I’m using the map block, and have about 5,500 lines to map. At first I tried doing this without setting up billing in Google Developer Console, so naturally I hit the daily limit of ~600 or so and work stopped. So I went and finished my account, added good billing, deleted old expired cards (I read somewhere this can be an issue even if not primary), and went ahead and refreshed the map… stops after a few hits. Still won’t proceed. I waited hours (figuring maybe it takes time for Google to realize your billing is set up), and no dice still. I tried creating a new API Key, then using that new key now that billing is complete in Developer Console, no dice. I checked quota settings in Google API, it’s unlimited per day and 5,000 per minute, yet I can’t get more than ~3-5 out of my remaining ~4700 to complete each time I click to retry. I opened a ticket with Google but I haven’t had a response yet to the details I submitted, they did ask me for code to check why this is happ

Is it possible to enter a stock symbol such as AAPL and get the price update as is offered in other spreadsheet programs? Thanks

Hey all, I am using Airtable to count the number of weeks each staff member is working as we work on different time strings. However, some of these time strings include holidays (e.g. Christmas and Easter). Is there a formula I could use to count weeks but exclude certain date ranges? For example I work 25/07/2022 - 13/01/2023, however, 26th Dec til 8th Jan is a shutdown period so wouldn’t count as 2 weeks of work time. Thanks so much in advance!

Hi! I’d like to use the Batch Update extension to sort fields for certain things, but so far it seems I can only sort by the main field. In my case, the field I would like to sort links to a table featuring members. I have the name of each member as the main field. However, I want to be able to sort it by the date each member joined – which I have filled out in a separate column. This way, the members are automatically sorted by seniority instead of me having to do that manually every time. Is this possible with this app, or do I have to write my own script (or edit someone else’s!) to accomplish this? I can do it manually if I have to, but I’m talking thousands of records, and sometimes there are well over 30 members. Since the members change over time and aren’t all in the same records, I can’t just copy and paste things, either. Cheers!

Can I transfer my workspace including all bases from my pro plan to another person’s pro plan?

I am creating a base that will track my staff’s required training classes. The classes vary in their renewal times, some only have to be taken once, some are required to be taken yearly, every 3 or 5 years. I created the following tables: Staff - contains Name and other pertinent info. Classes - lists all the required classes and their expiration times in number of years: 1, 3, 5. I created a table for training records and linked the staff and class names to this table, along with training date (date the staff took the class) and if it is the newest record (as there will be multiples.): This is what I would like to happen and I don’t know where to start: I would like to set up an automation that sends out an email when a staff is within 90 , 60, and 30 days of the class expiring. This would entail taking the Training Date from the Training table and the expiration time from the classes table using a formula to add the years to the training date and return the expired date. Then tak

I am struggling to to create a new table that pulls data column by column from two other existing tables. I how do that? I need to set it up to pull data to Klaviyo.

I have a base with 5 tables. Just in the past day, the tabs showing the different tables, in the iPad and iPhone apps, seem to have been replaced with an icon you click on to bring up the list of tables, so you can select the table from that list. I much prefer just seeing the tabs along the top or bottom of the base and select from there. Did I mess up a setting, or did Airtable change how this works? I don’t see an announcement of such a change, and a browse of tutorial topics for Mobile still refers to visible tabs in the base.

I am a tour bus operator, I started using airtable to keep records of my fleet, drivers, and reservations (three tables), but since then I’ve added sales, expenses, work orders, banks, and other workers. I need to collaborate with three users/departments which currently use forms to intruduce information, but depend on the clunky workaround of creating an automation and another form to select what to edit, and I need to limit their access to some tables. Since sync works only one way, creating another base feeding from my existing one doesn’t solve the problem, but I was wondering if anyone has tried duplicating and dividing the main base and then invert the direction of the sync so the new divided bases are the ones feeding the main integrated one.

Thanks in advance for your help

Thanks in advance for any assistance!

Hi guys, I’m having a slight issue with a synced table. It has added 6 blank records that don’t exist on the source table and that weren’t there after the destination table was created/before the sync. There’s definitely nothing to delete (first thought was pesky blank records that have been created accidentally in the source table), and I have run the sync multiple times in case there was anything that needed refreshing (even though there were never any blank records in the source table). And I can’t delete them on the destination table. I also don’t want to risk breaking the sync, as these have a lot of linked records within the destination base that I can’t risk losing. Any thoughts?

I currently import my calendar date, times, attendees, etc to Airtable. My goal is to try auto calculate my charges based on my time spent with clients. Currently it imports all events with all attendees. However I want to remove my colleagues email addresses from the list so I can allocate the a lookup to the email address to get the timing correct. Is there a way to import address and just exclude certain addresses? Or can I remove the address once imported and just have the client address? Any help would be appreciated.