Other Questions

“This base is temporarily unavailable. We apologise for the inconvenience.” this is the error message received on a Pro plan workspace

Hey, What I’m trying to do is expire a record after 24 hrs. I have created a view and filtered it by “start date is after 1 day ago”. It works but I don’t know if it’s 24hrs or 1 day ago based on the date? If the latter, a record may not be live for 24 hrs. Does that make sense? So my question is: How many hours is in an Airtable day? Or, should I try to achieve this another way? Cheers

Anyone else having trouble uploading to attachment columns right now? Sometimes it’s fine, but most of the time I can’t use my automation to email them, or the attachments are just deleting themselves.

Hello all, I want to display my Event Start Time and Event End Time as ISO 8601 format. I need it in this format so that when I export the csv and import into Adalo (no code app builder) that it will accept the time and date format correctly. The “Local Start Time” field is the airtable user’s local time. They input the time there, then select the Event time zone. The “Event Time Zone” field has a formula to show the correct time in that time zone. I want to also create a column to show the “Event Time Zone” in ISO 8601 format and with the correct UTC offset. I need this because I need to export this airtable and import it into Adalo as a csv. I saw a user “Kuovonne” do something similar, but I can’t figure out the formula to get the correct format and utc offset. This is the output that Kuovonne showed that I am looking for.

I’m working on an app that needs to filter the table in some way. It doesn’t look like there is a way to update the filters in the app. Is this correct?

My base has a particular table that’s large - it has about 35,000 records and about 13GB of attachments and my base in total has just over 38,000 records. I know this is getting pretty big in Airtable terms, but its well under the 50,000 records and 20GB attachments limits for my Pro plan. The other smaller tables in my base load and continue to work fine. This problem table shows the ‘Loading view’ spinner, but then a very unhelpful error popup appears: I know I need to migrate away from Airtable since I’ll overun the 50k record limit within next few months, but I thought I had that much time up my sleeve to figure out the migration… Now my base does not function at all which is a business critical issue. I’ve contacted Airtable support and send Console info, not sure if anything else I can do for now… Any advice on how to proce

Hello everyone, I’m struggling with a Date/Time situation that is maybe pretty straightforward for a lot of you but…I’m confused :winking_face: I’m definitely in need of help here ! Thank you. So, I’m updating a table with an API call (using Data Fetcher) from which I get, inside the response, a Date/Time field which looks like this : And when it’s pasted into a Date Field into AirTable, the Time is offset and not correct : I don’t get it. I understand from lots of discussions here and there that it may come from how Airtable manages Date and Time but even going through some posts or support articles, I don’t know how to handle it… Does anyone of you have an idea on how to fix this ? This would be very helpful. Thanks

Hi folks I’m new in Airtable, how can I show last 24 handled records, suppose I have a “completed” status, so how can I view the only last 24 hours where a record became “completed” from another status (such as pending or in progress…)

Still a newbie, learning steadily. But now that I have 700 records, each with 10 or so fields, including 5 or 6 linked fields, I am mystified to how to update any one field in any one record. For instance, since my base is my records and inventory of vintage fountain pens, I sell a pen and need to update its status from For Sale to Sold. I find the pen in its group and make the change, and it changes the status for the whole group. I expand the record for that one pen, and it shows me that pen in its status, plus all the other pens with that status, so I can’t change that one pen’s status without changing all the others as well. AT won’t let me make the change right in the record/field cell in the base itself. What am I missing? Many thanks, Tim

Our journalism project is setting up a series of watchlists on an Airtable for monitoring groups of Twitter users who are public figures/institutions. Does anyone have an automated way of using the Twitter user ID or account URL to populate an Airtable with the public Twitter profile information (such as profile public name, bio/description, location, website, etc) and profile follower/following count/number?

Hi! A company I work with shared an airtable link with content (mp4 videos/ photos). I need to download these images and videos. I cannot find any type of download icon or button to click on the videos or photos on the airtable document. Please help! :slightly_smiling_face: TIA!

Hello, I want to add limits on my calendar view, so that I can add the opening time and the ending time of my office. I want this because sometime some tasks are planned for 6 hours, and those 6 hours are distributed between 2 days. Adding opening and closing limits to each day on my calendar will avoid having the 6 hours assigned to 1 day. Thank you.

Hello all! I would like to ask if anyone have an idea how to automate the following scenario or a formula. Eg. I have different strings like This is a Christmas tree. This is a Xmas tree I want to identify both the keyword “Christmas” and “Xmas” and tag them to a Multi-select option as “Christmas” Is there an existing formula or automation to this? Thank you all!

Hi community members! I`m trying to sync change between 2 columns on Formula. (or…Is it possible??) ①:A specific textbox update (Formulas with text appended under certain conditions) ②:IF①`S record created,A specific “Checkbox” becomes :heavy_check_mark: Any ideas on how to solve this? (or recommend “automation”??) Thank you!

Hey there, For a specific field “OPPORTUNITY” that I have integrated into Airtable, I get three type of inputs. I need a formula to be able to separate this field in 4 columns. Input posibilities in “OPPORTUNITY” Field: Option 1: Opportunity in TOWN, CITY Option 2: Opportunity in STREET, TOWN, CITY Option 3: Opportunity in STREET, NUMBER, TOWN, CITY I need a formula to be able to create the following columns automatically: STREET NUMBER TOWN CITY Any idea? Thanks in advance!! :slightly_smiling_face: GM

I’m currently using a four-step Zapier recipe to append the record URL to a newly created record. I’d MUCH rather just have Airtable do this automatically… Does anyone know if that’s possible (the key word is automatically, since I know how to do this manually)? As I discover something new about Airtable almost everyday, I’m wondering if I have just missed this functionality somewhere. Thanks! Jack

I am attempting to build a `table that with a “link to another record” field. The records that I need to link to are in multiple other tables. Is there a way to give this type of field the ability to link to records that reside in more than one table?

I have a Long text field type that can have a paragraph or multiple paragraphs depending on the length of the author’s numbered passage. It would be beneficial to me to have Airtable highlight that word so I can locate it faster in the entry.

I have 4 employees and myself who all track time in seperate bases within my workspace. They are contractors and so I don’t want to give them access to historical records and the workspace in general (because they aren’t employees). How do I ‘sync’ everyone’s records to one central master time sheet? I can’t use Airtable’s syncing because on the pro plan it only supports 3 syncs, and we have more than that but it doesn’t make financial sense to upgrade to the enterprise plan. I have also tried Zapier to no avail: the contractors occasionally edit old records & I want that to reflect in the master base, but in the Zap I created there was no way to update the old record while creating a new record for a new time & description entry. Any help would be appreciated, my brain is fried over this!

Hello Guys, I have a problem with one field getting synced in another place. This is field with lookup values by creating relation column. While syncing this particular table to another base, it only shows one value rather than all. So basically, it is showing unique value only once. Is this the bug or that’s how it works?

hey I shared a record. it went out by Airtable email. how can I see who was emailed later if I want to know the state that was sent? the only way I see going forward is to send the record to myself, vet it, and then forward it to the other party. weird that Airtable doesn’t just call your own email client how can I see who was emailed by Airtable??

My jira cloud app started to fail today and when I try to edit field, I found the following problem. Anyone face this issue? or what could be wrong?

Can a form respondent receive a copy of their form data? Can a form respondent subsequently edit their form data? I haven’t found a way to do either, so if there is a way, please point me to it :slightly_smiling_face: Many thanks for your help, Julie

Hi, I am new to Airtable, I have searched but can’t find the answer. I am importing a spreadsheet of about 2500 rows and am planning on adding more, new data. The existing 2500 have been proofed, but the new ones will not have. I want to add a check box and mark the 2500 existing ones to indicate they have been done, but don’t want o have to check 2500 boxes manually. Is there a way to set multiple items to checked? TIA

Hi Everyone, Thank you for reading my message ! I’m encountering an issue I don’t understand, as it should be pretty straightforward. Maybe one of you may help… The “Event” table is Linked to the “Invoices” Table, through the Invoice_ID’s linked record (see below) : An Event can have multiple invoices attached to it (as in multiple attendees). However in the above screenshot, the Invoice ID that you see IS NOT in the “Paid only Invoices” View, and appears anyway in the Linked record field which, as far as I understand, should not : My idea is to manage Event stock with Paid only invoices, so for me it would be very practical to ha