Other Questions

I’m facing this issue all the time. In browser console, I can see this error: POST https://airtable.com/v0.3/notifications/fetchRecentThenMarkAllAsSeen 500 (Internal Server Error) Any advice?

Hi - I recently noticed that the URLs for attachments in my base are ‘sometimes’ exported with additional parameters that looks something like this: &userId=usrRGFsp5k3BVKxoz&cs=5df56hubdtrt3673b79d I’d prefer just the basic URL, and am also concerned that exposing the UserID is a security flaw - since I’ve shared these asset links, usually images, on a public platform without inspecting the URL closely. I am using the API (via pyairtable) to get these URLs. Sometimes the extra parameters are included, and sometimes they’re not. I haven’t been able to ascertain what is causing the different outcomes. Has anyone experienced this, or had similar issues? Thanks!

Hi team, Here’s the context 2 fields: Scheduled date: A Date field with ISO format, 24h format, it includes Time and uses GMT for all collaborators Date validation: A formula field that runs the following code: IF( AND( {Scheduled date}, NOW() >= {Scheduled date} ), "Ready", "In Review" ) Problem: When Scheduled date = Today, the formula returns Ready, ignoring the time. For instance: Case A Scheduled date = 2022-08-23 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns Ready :x: Case B Scheduled date = 2022-08-24 18:00 GMT NOW() = 2022-08-23 19:00 GMT The formula returns In Review :white_check_mark: Could it be that NOW() doesn’t care about time? or is it using a different Time Zone?

Unfortunately input.textAsync does not allow a default value. Anyone have a workaround for this? E.g., You can code a default value if user enters nothing, BUT…there’s no way to enter nothing (i.e., requires user to enter a value before proceeding).

I would like to ask the community about advanced linked records & extracting information for each specific record. Data Overview Table 1 ↓ I have a Zapier set up that creates a record each day into a table using a European date field type. Then I have created a linked field to Table 2 & 3. i.e. 16/8/2022 17/8/2022 18/8/2022 Table 2 This is a shared table synced to another base. This table includes projects, staff members & invoice amount. It’s based on the same European date field. This table has a linked field with Table 1. Table 3 This is a shared table synced to another base separate from Table 1 or 2. This table includes projects, raw materials & quantity used. It’s based on the same European date field. This table has a linked field with Table 1. I have set up an automation in Table 2 & 3 that when a record enters a view, it automatically adds the date to the linked field (Table

Hi people. Please is there any other way to make payment for plan upgrade(maybe bank transfer)? Our card limit doesn’t allow us to make such payment at once for the cost of the upgrade to the plus plan. Thanks

I would like to share multiple filtered views of a table on different pages. Would it be possible to create multiple shared views with each of them fixed on its specific filter? Thanks in advance.

Good day everyone! For gmail automation, in the Message section - is there a way to format fields that are inserted into the content of the message? Examples are below: I would love for the message to be easier for the client to read. Thanks!!

Hi, I Have a use case where i need to Extract transform and load the data from Google Cloud, need suggestions on how best this can be achieved. Thanks, Harshith

I’m looking for a solution that allows us to view a large number of records in the same was as groups in views work, but a lot larger in height. Something like this, assuming that “procedure” and “results” have lot of information: Group A Procedure A.1 Result A.1 Procedure A.2 Result A.2 Group B Procedure B.1 Result B.1 Procedure B.2 Result B.2 I looked into Page Designer, but it only shows one record at a time. Any ideas?

Hey All, I have a question about filters. Basically, I have records that have start and end time fields. To keep things neat and tidy, I have the main view set to only show records with a start time of “On or After Today.” This works until we hit 8PM ET (12AM GMT), when Airtable decides that, internally, it is the next day because it is on GMT time. This is an issue because evening events disappear from view with this filter. Is there a way to set up a filter so that these records will remain until it is the next day in terms of ET instead of GMT? Thank you!

I want to avoid replicate the same base filter 10X times on the same view I could not find a combination for that. Why is it limited ?

I have a table with all our deals that contains the following information Total amount of deal Start date End date I would like to split this up to a monthly revenue per deal for invoicing and reporting. Most of these deals have a duration of 1 year, but sometimes less. So for example, one row might look like this: 6000 1 January 2022 31 December 2022 I would then like to be able to build a report that has for columns (like a pivot table) for all the months from January to December and then an amount of 500 for this deal. Something like this is fairly easy in Excel, but I’m not quite sure how to build this in Airtable.

We are trying to automate email for master data with claim id with details from child database for same claim id - as detailed data resides in seperate child data base i am unable to create view , as claim id is dynamically getting changed for respective claim id in master table where trigger mail condition happens e.g. in master i have claim id - 100 and amount - 600 nd in child i have three records with claim id 100 and amount 100,200,300 digest on find records - condition picks up data but email rendering order is record id and so not put up as in order expected it is suggested to use find records with view i tried to set view but it asks for condition which i am unable to put up experts are requested to guide on this solution and what i am missing to plug in thanks for your time

Hi, If you want to only embed Airtable extension with table in, how to do this? For the moment i see a link up to the right in the embed grid or gallery with the text “extionsions”. When i click on that, the extension can be viewed. Embed interface is also not possible?

Hello. I’m trying to develop a tool to help obese teenagers track the calories they eat, at a health centre near me. I’ve got the first part right, but I’m struggling with the last part. I created a table with all the foods. Then I create a table for each new day, where they add what they eat each day. In table 3, I would like to create a new line for each day, adding all the calories consumed that day. I can’t manage to create a new line for each table, nor to add the total for the day automatically. Can you help me? Thank you very much

Hello wonderful community! I’m trying to work with a project plan. I’ve got my projects, tasks and assignees I’m working on building a table to show each assignee their “to do” list based on the project plan tasks 2 things - Is there a way to assign tasks to multiple people based on the person’s department? Second, is there a way to assign a whole project AND all of the tasks in that project to one person with some sort of formula or automation? I did find this and it is helping but hasn’t fully addressed what I’m looking to do.Assigning Tasks to Multiple People - #2 by JonathanBowen Thank you!

I am a new user and would like some help figuring out how to write this Airtable Js script. I am trying to change the status of a record base on two conditions in the Maintenance Tracking Table: Date: Older date or Time stamp Status: Upcoming Service Check If the record has an older Date and the status is Upcoming service check, I want to change the status to past service check. I am using an Airtable automation trigger called “when a record enters a view” .Your help will be appreciated.

Banging my head on the table here - I cannot seem to figure how to link tables that I have imported from another database, having converted them to Excel. I have something basically like this: Table1 Table1_Key | Table1_Field1 | Table1_Field2... Table_2 Table2_Key | Table1_Key | Table2_Field1 | Table2_Field2... Data imports fine, but when I create the link, it just doesn’t work. I’m sure I’m overthinking something here, I just cannot seem to figure what it is. Matt

I have a student assigned to a homeroom in the column “current homeroom”. I am adding a checkbox “Withdrawn”. I would like to do this: IF the student is withdrawn THEN move the value from “current homeroom” to “homeroom 22-23”. The result being: cell in column current homeroom: empty, cell in homeroom 22-23: previous homeroom teacher. How can I do this ? Do I need to use the remarkable integromat or can I do it without external tools just with formula?

I’d like to insert an image in my base guide. I think I’m using the proper Markdown syntax, but it’s simply not working. I get the impression from this page that this should be possible. It says You can also use Markdown within the base guide to add headers, links, emojis and images. It works here in the Community. Here’s the exact Markdown I’m using, followed by the result here. Can I get the same result in the Base Guide? 

Hi Does anybody know a formula to calculate an address from a google maps link?

I’m having some trouble migrating from FileMaker Pro to Airtable… I am able to export and import 99% of my data/contacts with out issue – mapping, organizing, etc. The only issue I’m running into is having the multiple mailing lists these contacts are attached to map to a single row. For example: John Doe (on FMP) is on mailing lists A, B, and C. When I import to Airtable, it lists John Doe as being on mailing list A, but then lists an “unnamed record” as being on list B, and another one on list C. It ends up being that all of the proper contacts are followed by unnamed rows with the remainder of their lists attached. I hope this is making sense… Is there an automation or formula I can set up to merge these into the above (correct) record? Or any tips for making my FMP output group these together, instead of having them as separate records?

Hello everyone! For my gmail automation, the first name isn’t displaying when I generate a preview of the email. Why is that? Is there a way to find out what restrictions there are when inserting fields?

Does anyone have a template suggestion or a template they use to keep up with employee vacations, PTO, injuries (workers comp), start date, status of employment etc. Thank you.