Other Questions

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 o

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

I need to add a static logo image to several output documents. The block editor has the instruction: “Image URL Try typing { Field Name } to generate URLs using content from your base.” But nothing I do displays the image.

Earlier today I responded to a question from a new user here, explaining how she could hide a field on a locked view and keep the field hidden from non-creator users by making it visible only on a personal view configured by the creator. I then had to add that this is security theater (I think that’s the phrase we use these days) because in truth, any user with editor or commenter privileges can simply duplicate the locked view as a new personal view, which they can then configure to their heart’s content–including making visible the fields that the base creator wanted hidden. After posting my response, I began to feel uneasy, so I looked into this a little more deeply than I have before, and I’m a bit disappointed by what I’ve found. I’m praying someone here tells me that I didn’t look deep enough–that there are better answers to my concerns. But at the moment it appears that base creators have only a very limited, casual sort of control over who gets into their bas

I have noticed a change in the calendar view. Previously, the end date was adjusted according to the start date automatically. Somehow this does not happen anymore which results in multiple date conflicts. Exp: I want to change the date of the task from this week to next week. The task is scheduled for 1 hour. If I change the start it creates a conflict because now the end is before the start. If I change the end, the event lasts for 7 days now. Did anyone notice something similar?

Is it possible to create an automation that notifies/or record update when XXX days have passed since I created a particular record? I wish I could do this. (e.g. record update case) 1_created record & get the “created time” 2_2week passed from “created time” 3_some status automated change A from B

I’m struggling with the setup of a date field to be used in Airtable’s “Create records for multiple templates” script. The template table’s formula column has similar date formatting to the child table’s date column. Copying manually back and forth both works fine and the date is correctly recognized. The script fails with the below error. DATETIME_FORMAT doesn’t help, using it the formula field stops applying date formatting. j: Can't create records: invalid cell value for field 'Date'. Cell value has invalid format: <root>.0 must be a string, <root>.1 must be a string, <root>.2 must be an object at main on line 130 Any suggestions would be much appreciated. Thanks!

Hi everyone, I had a question about scheduling a recurring event on Airtable. As seen in the screenshot below, the way our recurring event ‘SoB Boost’ is currently scheduled, the way each event shows up in the table (a row below and a column to the right of the previous event) creates a downward slope that takes up a lot of space. Is there another way to schedule these recurring events that won’t take up so much space, or is this the only way to do it?

Morning, Noon, Evening, There has been a bunch of chatter about a front-end interface to be released soon. I remember seeing this functionality sneak peaked on an Airtable survey they sent out about a month ago. I regret not screen capping. Any way, what would you all like to see from a front end interface? What tools have you used whose functionality would be well appropriated by Airtable? What does your magic 8 ball tell you about a drop date? What have you all heard about it in general? I’m hoping for some more advanced data validation and cascading drop down functionality. This type of stuff doesn’t lend itself nicely to the current spreadsheet model. All the best, Steve