Other Questions

Anybody have ideas on when the Matrix App will be enhanced to include Date fields? That is the ONE missing piece that I need for the app to actually be useful for me. Any suggestions on what I can do in its absence? :slightly_smiling_face:

Hey team Is it possible to build a twilio IVR that searches and creates records in Airtable? I have zero coding experience so any documentation and support is appreciated. Thanks

Hello, an animal rescue charity has told me their existing database provider has stopped their plans for charities so they need another platform. I think Airtable may be perfect for them. I have exported all the data from the old system and have it in two CSV files. I have imported the CSV files into two tables but unable to link the two together automatically. The two tables are customers & animals So each animal is linked to a customer by a customer_id record in the first column. I am looking for how to make these links work as there are a couple of thousand records, far too many to consider doing manually. Does anyone know how to do this? Thanks Paul

Hi all, Looking for help on this issue. Created a zap to alert me of a new record in a view. When it sends the message, it garbles my field data. Dates work, but any text fields do not. Any advice/assistance?

Hi all, I have figured out a lot of the rich features of Airtable in my free version but I can’t figure out how to send a simple email to one person. Think of this as direct sales. My sales person wants to send an email related to a conversation so the email has to be unique and it will only go once. How does she do that? OR, we want to send an email to all clients with a specific status but, again, it’s a unique email, not something that should happen on an automated basis. Can I select the status and do a group send of a unique, one-time only email? Your help will be extremely welcome. Janice

I have a linked table where I copy data in from an external source on a monthly basis. The external data changes between updates in that new records could be added or existing records could be removed. I am trying to determine the best way to update the data I am using in Airtable so that it stays current and doesn’t break the existing linked and lookup fields.

Hello with each other with my new Samsung Tab S7+ it prints me only the window with the print settings but just not the table?!?? Can someone give me a tip here? All love Karin

Hi all I want to upgrade to Pro but want to be certain of the cancellation notice I need to give if it doesn’t work out. Is it a month? Nothing in the FAQs specifies this! Thanks Beth

Hi, I tried solving this but no avail. If Payment Date falls on Friday(e:g 1/5), Saturday and Sunday, it should return a following Monday (1/8). If it’s Mon-Thu, keep the original date. My Code: IF(5-WEEKDAY({Payment Date})<=0, SWITCH( WEEKDAY({Payment Date}), 5, DATEADD({Payment Date}, 3, ‘days’), 6, DATEADD({Payment Date}, 2, ‘days’), 0, DATEADD({Payment Date}, 1, ‘days’)), {Payment Date}) Somehow, everything is right, except Sunday. Whatever way to write the code, it keeps returning me Sunday’s date, in this case 1/7. How can I solve this?

We have the pro plan, but we’re only able to share 3 views into one single view in Airtable. Is there an issue or do we still need to upgrade?

Hi all - was wondering if anyone knew of a way to import an Excel file onto an existing table. I have a table already set up but would like to continue adding records over time, but don’t want to do it manually line by line as I am working with a significant amount of records. I see options to import data from places such as Excel but that would create an entirely new table each time I import. Anyone know if its possible just to add on to an existing table using import? Thanks in advance!

Is there a way to get the whole table to calculate so there is a final sum for the entire table? (see image 1): Also, is there a way to get the figures from the monthly tables to automatically populate to the overview table? TIA

HI! I’m trying to embed Airtable - City Council Candidates into a wordpress site, and no matter what method I attempt, I get an error message. If I use an embed block, i get a blank grey rectangle, if I use the embed code, I get a JSON error, and if I use an iframe plug in I get the error message “airtable.com refused to connect” I’m not sure why it won’t connect, I have checked the settings a bunch of times. Is there anything else I can try?

Hi! I am trying to create a typeform from my airtable base , and see the following error: VALIDATION_ERROR The payload is invalid. I am on a professional plan in typeform and pro in airtable. I could not find an answer in this nor in the typeform community, hope someone can help me out. thanks Barbara

Can anyone help me with a formula? Here’s what I want to do: Take a total number of words: for example, 60,000 Subtract my current number of words: for example, 20,000 And then take that number (40,000) and divide it among the number of days left before my deadline. TIA!

I’m trying to get the content from a rich text element in Airtable, transform it via Integromat from Markdown to HTML (using the Markdown to HTML module) and then post the HTML. I can’t get line breaks to work in my Rich Text Field properly in Airtable. I’ve tried: using a , but this breaks the final result using GitHub flavoured markdown (doesn’t seem to be recognised). and of course, just entering multiple line breaks doesn’t mean these line breaks are sent by the Airtable API. Does anyone have a solution on how to deal with this? thanks in advance.

Hello, I am new to Airtable and I am not very gifted :-): . I would like to sum several records “prix” by name of the person I try to link theses fields in another table without success. I’ve seem this post Sum Numbers by Group then use results in a formula - #2 by Neads_Admin Can you explain me it better ? Thank you :slightly_smiling_face:

Hi, I have been constantly experiencing errors when importing the excel data into a new base. I wonder can anyone help me with that? Thank you very much!

Wondering if this is possible? I have about 10 multiple select options in a column. Several of them are no longer relevant, but I still need the historical data in the column. Is there a way to remove items from multiple select while maintaining the data in the cells?

Hi! I’m posting on behalf of a mutual aid group that I help with. We recently shared a bit.ly link to one of our donation forms, and we started getting really racist / violent hate mail from what seems like a bot all morning. We’re unable to connect donors with recipients right now because of this. We created a duplicate form, changed field language slightly, deleted old form, redirected bitly to new form link, but the bot is still running. We tweeted at Airtable, emailed support, sent in tickets, but it’s a holiday weekend. Is there a way to add a captcha to Airtable forms? I have searched the forums on this topic and it seems third party options are available, but when I look at what they have to offer I worry that the integration does not provide enough protection against an injection attack grabbing internal data. If we have a js developer on our team, is that something that could help at this time? Thank you!

Hi all! I am working with a client that is using several different forms in a table, and they want to tag submissions with which form is filled out. In other words, if someone fills out form #1, the record that is created indicated that form #1 was filled out. If form #2 is filled out, then the record indicates that form #2 was filled out, etc. I am sure there is a way to do this, but I can’t figure it out for the life of me! Thanks in advance!

Hi all, I noticed that the Sync Table is treated in the REST API, and the Block APi, as a plain table. But as we know it is not (you cannot mutate on those imported fields). Is there any way we can get some meta data to tell if it’s a sync table / field or a normal one? I did notice that sometimes the externalSyncSource fieldType will show up, but that’s not consistent at all. eg. i don’t understand why only SingleSelect field is changed to externalSyncSource, while everything else is exposed as if it’s normal fields. This seems half-baked unless I’m missing something here.

Hello, I am trying to connect my Airtable with my IOS Contacts, so when there is a new add or I modified something into my airtable, it automatically get updated or added to my IOS contacts. But I am having some troubles with the formula to make that works. Can someone help kindly? Please find screenshot attached.

Is there a built in way to input data other than the standard views, such that it looks like page designer? It’s definitely not page designer that I’m looking for, but imagine if you designed a page using page designer, and you were actually able to input data in that format rather than just view it. That would be amazing! I’m pretty sure this exists, but whenever I ask someone or Google it, it just brings me back to page designer. I think it might have been called “custom input interface,” but I really need to know the real name! Thank you!

Wondering if there is a way to scale the font size to fit the width/height of a given field in Page Designer? I have field names that are quite variable in length and would like to maximize readability by having short field names take up the full width/height while having long field names still fully displayed without being cut off. Thanks for any tricks or tips!