Other Questions

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!

I am trying to create a view based on rooms and multiple items within that room. Is there a way for me to just output the room number once at the top and then the related records for that room beneath? Currently, i have it grouped by room in view, and the records just show up in rows with the room number on each. Current: Room 111 table Room 111 chair Room 222 lamp Desired: Room 111 table chair Room 222 lamp

I have a set of tables with a descending set of relations. Grandparent has children which have children etc. I choose the linked records from a parent record and this stores my order since the ordering is dependent on the parent. When I create a view from the lowest level I want to be able to group by the ancestors and then sort each group by the linked order. I only get options for alphabetical. Is there some other way around this? Can I somehow get a calculation to expose the ordering of the array of linked records?

Hi very new to airtable. Was wondering if there was a way (lookup or formula) to display the most recent collaborator comment on a record in a tablef? so for instance, be able to include columns such as: col X: Shows content of the most recent comment made by a collaborator on a specific record col Y: Shows the name of the most recent collaborator comment col Z: Shows the date stamp of the most recent collaborator comment Hope this makes sense Thank you!! Jason

Hopefully this is a simple one and I explain this correctly: I have a table of products containing several fields, including: unique product ID and price. (Let’s call this the primary table) I am using the Data Fetcher Airtable app to pull updated product information from an API into a separate table in the same base. (Let’s call this the secondary table). This also contains a unique product ID and price I want to fetch the price in the secondary table and update the relevant price field in the primary table, using the product ID to ensure the correct item is updated. If these were two tabs in Excel, I would just use a vlookup to look up the id and return the price. However I can’t figure out how to get this to work in Airtable. Any advice much appreciated. For info - the two tables do have a name field, containing the name of the product, however the names in the primary & secondary tables don’t always match, so I cannot use this field to match an item. Many thanks

Hi, I have a customer order table that includes, customer name, order date, order… etc. I am aware that I can create a CSV file with the fields explicitly shown, however, I would like to create a CSV file just with the customer contact details, name, email, etc which is currently set up as an expanded record field. I need to know how to create a CSV record of the customer details only. I hope that is clear! Thanks

I’m seeking a way to protect from records becoming accidentally unlinked (or at least being able to relink them again). Example scenario: Let’s say table1 in db1 (table1.db1) is synched as table1 in db2 (table1.db2) and table2.db2 is linked to table1.db2. If table1.db1 gets filtered and synch’ed to table1.db2, the missing records will get unlinked in table2.db2. And I see now way to relink them again easily. The solution here (“If a record is removed from the destination table, that record will unlink from any linked record fields to that table”): Sync FAQs – Airtable Support does not protect from the main db admin from accidentally filtering the main table (table1.db1). Is there some way to store the record ID of a linked record in table1 within the linked record in table2 (e.g., with a script)? This would then make it possible to at least repair the links after they’ve been broken (and after fixing the filter in table1.db1).

Hi, I have been asked to track data (think revenue and cost) over time. In the tables where this is calculated, I can easily see what the current revenue is for a project. But I need to get revenue per project at time intervals so it can be graphed. I set up a Summary table where I can write an entry per project and capture the timestamp. I did this simply for proof of concept using a checkbox field. An automation runs if the checkbox is selected, creates the entry in the summary table, then clears the checkbox. But now I need a way to completely automate this without having to select a checkbox. I thought running an automation on a schedule (perhaps once per week) would let me capture the weekly snapshot and write a record to my summary table so that the data can be graphed. But, it doesn’t appear that using the schedule trigger will work. While it will fire exactly when I want it to, I can’t create a “Create record” action to add a record to the summary table using values in my so