Other Questions

Hi, I have a table with some data (ID number, start time, end time etc.) imported from another app and I would like to have them updated when the original data from the source change. I’ve tried Integromat Upsert record module but without success. Is there a way how to identify the record by the value in column “ID number” that is imported from the original data source and update/rewrite values in columns “start time, end time etc.”

I am trying to plan various combinations of trips, people, and room assignments. For the sake of simplicity, let’s say there are: 25 trips this year 10 two-person rooms available for each trip. 300 people who may go on these trips. Many will go on more than one trip. I have tables for people, for trips, and for rooms. How/where do I combine these so that I can plan who goes into what room on each trip?

Hello, I am looking for the option that when trying to create a record, the system will autocomplete or suggest based on information already registered in other fields.

Hi, In column A, I listed all weeks number (from 1 to 52) in column B, I would like to have the correspondant date based on Monday. ex in 2021 Column WEEK: 52 Column Day = Monday 27th dec. How to set up this in airtable? thank you

Hi all, I´m trying to integrate Airtable with Appgyver using the Airtable API. I need to retrieve some fields from different tables based on an unique value (the company id) which is not the record id. Is it possible? Can I retrieve different fields from different tables based on the company id instead of the record id ? How can I do that?

Hi, as the title says, is it possible to remove the stickiness of primary tables while scrolling horizontally? It’s irritating because sometimes a field that’s hidden behind it seems to be having a blank title while it’s only hidden. So is there a way? I didn’t find the option to when I right clicked on it. TYIA.

Is there some trick to attaching files using the web Form on iPhone? I seem to be able to select them from my phone, but then there doesn’t seem to be a way to close the selection window without removing the file itself from the form submission? Thanks.

Hi, I have set up a sync between Airtable and gcal, but regardless of the duration of these events, (some are 2 hours, some are as long as 8 hours), they all show up as 1 hour in gcal. When I go back to Airtable, everything looks correct. (ex: 10:00 start, 12:00 end). I have tried re-syncing multiple times, but it doesn’t change. Does anyone know how to fix this? Thanks, /Krista

So … I have a base where two people add and withdraw from one bank account. The account is supposed to be 50/50 … but one person isn’t contributing as much as the other. I have all the data in, but I need a breakdown like a dashboard … that takes 50% of the expenses that both pay … and adds the expenses that only one pays … does that make sense? I have a base, but I’m hesitant to share it here, because it has a lot of financial data. If you think you can help, I’ll totally DM it to you.

I want to use a form to request entertainers. In the base, I have a lookup field for Event Contact (looking up in the Event Contact table). My problem is that when I put the Event Contact field on the Form, the requester can see all of the current contacts. I would like them to be able to enter their name without seeing other contact names. Is this possible??

I already know that the prefill form is used for text fields. Can the attachment field be used in the same way?

I have a table with an automation that runs when a record is updated. If I create a row by hand, the automation runs as expected, but when a row gets created via a Zapier automation, the script isn’t triggered? Is there something different about rows created via zapier vs creating them by hand?

Before the duration field was added, I was using “Start” and “Stop” fields with this formula: IF( AND(NOT({Start}), NOT({Stop})), "", IF( {Stop}, ROUND((DATETIME_DIFF(Stop, Start, 'minutes') / 60) * 4 , 0) / 4 , ROUND((DATETIME_DIFF(NOW(), Start, 'minutes') / 60) * 4 , 0) / 4 )) This gave me a nicely rounded decimal number for billing purposes. I’d like to use the new duration field to eliminate a step here, but can’t figure out how to convert that fields value.

I’m fairly new to customizing Airtable and would like to create a catalog in a pdf format with Airtable data. The pdf needs to have clickable hyperlinks. Does anyone know if there is a way to do this? Thank you very much.

Pretty much what the title says. We have a role in the company that is going to be split. One of the users / accounts was given “Creator” status, and we need to change it back to “Editor”. I’ve done that, but the account can still do all of the things that a Creator can do. Is there a known issue about this problem?

Hi, We have been using Airtable for a while to collect real time data from commercial units where our field agents checks the stock available. This is how it looks like: Date / Product / Commercial Unit … Each report has a deadline. For example: in row 10. For Biotech USA (product) at Hodmezovasarhely Interspar (commercial unit) the report has to be fulfilled each Monday and Thursday recurrently. For each product and commercial unit we have different fulfilment date that has to be checked. We must notice if we don’t receive a report in time. Remaining with the example above: Biotech USA at Hodmezovasarhely Interspar 09.20.2021. 09.23.2021. 09.27.2021. 09.30.2021. ETC. ETC. Any idea how to work this out? I will appreciate any support. Thanks, Andonisz

Hi all! I’m rather new to formulas and the like and was hoping to solve the following: If task in my “Status” Column is anything other than “Complete” or “Archived”, AND it is past “Targeted Completion” Date, then “Status” should read “Overdue”. Here’s how far (not far) I got: IF(IS_BEFORE({Target Completion}, TODAY()),“Overdue”)) Any help you can offer would be greatly appreciated! Cheers :grinning_face_with_smiling_eyes:

Dear Community, I am new to airtable, and it is working fine for me so far. I am trying to automate posting to Facebook Page, I have a field in my records that contains Date and Time components. When adding a condition, I noticed that I can only test the date component, but not the time. Which means I couldn’t so far set an exact time for my post. Am I doing something wrong?

I have the integration set up already, my issues is how to tell Zapier to look at the publish date and don’t publish until then. Example: It is now 9:03 a.m. I have a post that needs to go live at 10:00 a.m. The way I have it set up right now, Zapier just publishes it the second I add it to Airtable; if its new, it grabs and publishes. I would like it to not push until 10:00 a.m.

I am using airtable to track reservations at a vacation home. Each reservation is its own record with an “Arrival Date” and “Departure Date”. I would like to be able to add a field called “Prior Guest Departure Date” which can allow me to schedule tasks for the next guest at the end of the previous reservation. I can’t figure out how to lookup, or use a formula that can find the previous date relative to the date in the record. Any suggestions? I am happy to share more if you need it!!! In case it helps, I am using the dates along with filtered views to setup Zapier for messaging.

Hello, I duplicated a form and added new questions. The new answers are not showing up on the original grid view. What am I doing wrong? All the best, Greg

Hi all, I came across Airtable a few months ago and have been exploring this awesome tool since. I have been able to use Airtable to build some really handy tools for internal use in my business but I’m unsure how best I can leverage Airtable to build custom apps for my clients due to the lack of UI control. I spoke to an Airtable expert a few weeks back and he told me Airtable are releasing a front-end UI builder that offers more or less what third party apps like Stacker and Softr offers. I was told this is something Airtable are testing internally and will be launched to users in August. I have asked him for an update but haven’t heard back. Also heard the same thing in this podcast video, first 5 minutes. I have a whole bunch of clients and projects I’d bring over to Airtable in a flash if such a feature is released. Does anyone on here know more about this? Thanks Jay

Hello All, Just starting out with forms and looking for tutorials. My very first issue is that someone setup a form for me, which had the right questions and Ive tried to create a new one by duplicating it and now responses from the two forms are showing up in both, without being able to separate their source. Can you please advise? Can you direct to a comprehensive source of information on AT? Thank you

I have many fields in a table. I try to have GET API call https://api.airtable.com/v0/appXXXX/TABLE?maxRecords=3&view=YYY But it seems that the hidden fields are also returned. How can i only return the fields which are visible? I dont want to overcomplicate things by having many fields.

I have a formula field that takes 2 datetime fields and creates a “week overview” with them. But value of [Day] 11:59pm in the End Date field seems to round the day up to the next day, which is misleading. Here’s the formula IF(Start,IF(End,CONCATENATE(DATETIME_FORMAT(Start,"YYYY MM/DD")," - ",DATETIME_FORMAT(End,"MM/DD")," ",{Use Case}),"TBD"),"TBD") Result