Other Questions

Hello! I inadvertently removed information from a field… How would I be able to EDIT this to find out what was originally in there AND ADD IT BACK?

Hello, I am in the EST timezone and my boss is in the PST timezone. We are working on a shared Airtable base. Is the timezone displayed locally for each of us? For example, if she enters 6am, should I see 6am or 9am when I view the record? Thanks for any tips/guidance! Jena

Hi all! We have an onboarding checklist that we use for the IT, People, and Office teams when our company hires a new employee. This table is used to share out information like first/last name, start date, starting location, role, and more. Sometimes, the recruiters and coordinators are unaware that the start date might be a holiday. I’d love to find a way to monitor the start date field and check it against a list of company holidays (which we would like to manage and assign to locations) and alert us via Slack if a new hire is planned to start on a holiday. I’m kind of stuck, but hoping that somebody has an idea. We can also utilize Zapier, and any other tools that may be helpful for this

Hi, I just joined airtable and find it amazing ! I managed to build my product in a few days and just launched it. But I’m facing an issue : I have an automation send an email (throught gmail) to people responding to a form. As my plan is still “Pro trial” I can’t send email to people who are not collaborator, I tried to upgrade my account but it says that my account will be upgraded after the 12 days left of the “Pro trial”. Does someone know how I can unlock email in “Pro trial” or skip “Pro trial” to be on “Pro plan” from today ? More and more people are subscribing and email fails every time… :confused: Thanks ! Rebecca

Hi all, I would like to filter my records inside the vega-lite app to be independent from various views. Therefore I’m looking for a way to filter strings: record: “ABCD” record: “ABKF” record: “APFK” I want to visualise only records where the string starts with “AB”. As far as I read the documentation, it is possible to filter numbers and complete strings. But is it possible to truncate strings? Or maybe there is another workaround? I expect to use it inside the transform statement. Blockquote{ “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “transform”: [ “filter”:{truncate(“field”:“PL reference”, 4)}, //something here is fishy… “equal”:“AB” ], “title”: “Shipment”, “width”: “container”, “height”: “container”, “mark”: “bar”, “encoding”: { “x”: { “type”: “nominal

Is there a way to drag and drop fields and/or records from one table to another?

Using the formula for date add as found in AT, I can get the date to SUBTRACT days but not to ADD days. I have a date column {datereqsent} and I want {duedate} to calculated to 30 days from datereqsent. I have tried changing the minus sign to a plus sign and that is not working. TIA

Hello, I need help retrieving Invoices from Airtable. I had an account and had a workspace for which I was paying. Then i deprecated the plan for the Workspace, and now I don’t have access to that workspace anymore. Which is not a problem, but I need to get the invoices for my company accounting. Also airtable doesn’t send pdf invoices by mail so i have no trace of them anymore. Please help me retrieve the invoices from December 2019 till December 2020

Anyone having any issues with loading large tables today? It was working fine for me yesterday, but today keep getting error messages to refresh anytime we open a new window. My main table in my base is approx 25k records & 300 fields. Thanks.

I am continuously getting an error message when trying to import Multiple Select items from Typeform into Airtable. I have read the support information and followed the instructions and cannot fix this. Has anyone had any luck with this? Thanks in advance!

HEY, I don’t know why air table don’t save this formula Do have a problem with the formula?or it’s a little long. I don’t really know where the problem seems to be is. Please help Me !!! IF({RECEPTION},IF(IS_AFTER(TODAY(),“DATE ECHEANCE”),“NON PAYEE”,“ENCOURS DE PAIEMENT”,IF({ENCAISSEMENT},“PAYEE”,"")))

I’m trying to create HTML code for each record based on a common HTML with placeholders between [ brackets ] that will then be replaced with record data from the corresponding fields, so I have in a long text field something like this: < h2 style=“text-align: center;”>[ESTADO]< /h2> < p> < /p> < table style=“width: 100%; border-collapse: collapse; border-style: none; margin-left: auto; margin-right: auto;” border=“0”> < tbody> < tr> < td style=“width: 25%;”> < h4>Cliente: < /td> < td style=“width: 25%;”> < p>[NCLIENTE] And then in a formula field I have SUBSTITUTE(HTML,"[NCLIENTE]",NCLIENTE) (that last one is the field name) Works fine with the [ESTADO] placeholder, but then when I use the [NCLIENTE], either by itself or as a second nested substitute formula I get #ERROR! message. I have tried changing th

Hi, I’ve just started with thunkable and airtable, I’ve created my first table and instead of write on the suppose first row, it means 1, my 3 firsts submit were writed on row 4, 5 and 6. Why could this be? Thanks a lot.

Is there a way to share a form so that the thumbnail is a logo or the title of the form instead of the generic Airtable logo? We are trying to post the link to our form on social media, but the thumbnail is just the Airtable logo (tried to post a picture but kept getting an error message (you can’t put pictures in a post).

Hi- I’m trying to embed a password-protected Base in my website. It works when I do it in my ‘home’ browser (Chrome). But if I try to look at the page and enter the password in Chrome Incognito, on my phone, or in Safari, the password doesn’t open the Base. The password dialog box pops up, I enter the password, the password dialog box disappears… and the base isn’t open. Am I missing something? Is it only working in my ‘home’ browser because my Airtable account has access to the base in question? thanks

Said formula: AND({FORMULA1}!="", {FORMULA 2}!="", {FORMULA 3}!="") no matter what combination of those 3 fields are empty or populated it always returns 1. i only want it to return 1 once all those fields have returned a value. conditional automations using ‘and’ also return true even if not all of the options are true when using formula fields. are we seriously not able to check if several formulas did or didnt populate? am i missing something? seems to me that AND() is behaving more like OR() but i have no idea what im talking about

Hello! I searched for this, but I could only find similar results – but not the result I need. I have a Purchase Order table and a PO_ITEMS table where I create one line for each item I’m buying. I need to control serial numbers of these items, so each record is later linked to a sale. What I need is to create the PO, add the PO_ITEMS and in the end, have a pretty Purchase Order (Page Designer form) with the total quantity I need for each model. This is the form which will be sent to the manufacturer. The examples I found show the Purchase Order with every line from the PO_ITEMS table, not a summarized table. Can anyone help me? I’m attaching an image to help understanding.

We have many views which group items and create summary data at the bottom of the view. FOr example, all of the sales for a day of the week, with summary totals after each day. These appear find in the views, but DO NOT appear when exporting to CSV. It appears to only export the hard data. When printing and saving to PDF, these summary rows DO appear (but this is not helpful). This is supposed to be for salespeople to simply export and see all the totals. They will not be able to manually add the functions to Excel on each column to sum them manually. Is there another tool we can link to that will do this?

Hello, I have two coworkers who have recently left the organization. Since we pay by user I will be deleting their accounts. Will their activity history and entries into shared workspaces and bases still be viewable by other paid users/collaborators in our organization? Thanks! Lisa

Hey everyone, Airtable’s billing system is confusing me. Likely this is simple, but I can’t figure it out. How do I add users to my 5-user Pro starter pack? I swear at one point it asked me to and I said “skip for now,” but now I can’t find that anywhere. Thanks, Eric

Hi! Any idea why my date fields won’t sort? I click 1-9 and 9-1 and nothing changes, perplexing??? Thankful for your expertise! :pray:

Is there a way I can add an attachment that coordinates to the entire table and not just a particular record or field in that table. For instance, instructions on how to complete the table and the rationale behind it. I did include field descriptions for each field but I need to explain WHY we need the data that goes into each field and record.

I need help with emailing selected records. i understand that you can select records and send them and this works great. I need this same function but able to have the app user / end user enter their contact information and send the records to a hard coded email address. The user also needs to be able to add comments in a field such as notes. The end result is the email should contain a copy of the selected records , a form for the user to add their contact information with the send to address already filled out a button to send and a confirmation email back to the user stating requests submitted. Please and thank you.

Hi, I am currently on the free version of Airtable and working out how it can be used at my company. I want to email one record in a table to 14 recipients, I have attempted this both with the comma between addresses and the comma and space between and still no luck, the email is never received by any of the email addresses- these email addresses are not collaborators; however, I didn’t think that would be an issue? Can anyone help me with this problem please?

Hi there, I am wanting to see if anyone can help me with this. I have done a search but (probably by my own lack of knowledge) can’t find a reasonable answer. I work with students. When I enter a new record, I want one of my fields to auto-populate with a new email address assigned to that student. So for example, I have an email of student+112@nameofcompany.com. What I am wanting is for the next record I enter, which would be a new student, to result in a new email assigned that reads student+113@nameofcompay.com. Is that even possible? I have done a formula of (99+{name of autonumber field}) for their student ID which results in on going new IDs for each student, now i need the email to have the same result. Thank you in advance, I’m new here.