Other Questions

Can Forms be customized outside of just adding the fields in the table? Can I add labels or pictures that don’t add anything to the table but improve the look of the form?

Hi there - I’m looking to set up a formula to determine fiscal year and can’t figure it out. Help appreciated I tried setting up an IF function (i.e., if the date in the “Engagement End Date” column is on or after 7/1/2018, then the fiscal year is 2019, and if the date in the “Engagement End Date” is on or after 7/1/2019, then fiscal year is 2020.) Also - is there a formula in Airtable comparable to IFERROR? I don’t quite think ERROR and ISERROR formulas are what I’m looking for. Thanks! Thanks!

Hi All,Hopefully, there's more help here haha.My automations have stopped working, I've checked the run count and its around 15k well below the max. During my search for support I found my next invoice has changed from $54 to $257.20!!!!! Now I definitely did not permit this change and I don't know whats changed since my last payment. I've tried getting in contact with Airtable support via the chat but its been 30mins with no response. If you have any potential answers I would be very grateful to hear them.

Hello!Is it possible to enable the revision history to show exact dates (instead of "1w ago, 3y ago," etc.?I continue to run into this--where I am trying to find out when a change was made and I get these approximations. Hoping there is a fix for this or maybe it can be requested on future updates.

It doesn’t look like searching in a table searches the comments. Can you help or is this a feature you are adding? Definitely need full text search across everything

I have a form embedded on a wordpress/elementor page, and it is loading extremely slow. On some devices it takes up to 15 seconds to load. This is impacting my conversions.I already reached out to support, but while I wait for them to get back to me, has anyone dealt with this and found a solution? 

Once a week I want to email a report from Airtable to stakeholders (who don’t have Airtable logins). This report is based on rows created in a particular table in the last 7 days. Basically a filtered view of the table. The report could be as text, PDF, Excel or HTML. I have managed to use Zapier to send some data on a schedule. But the ‘Find record’ zap only seems to be able to find a single record. Ideally I want to be able to send a whole view or block. Any ideas? This seems like a fairly basic use case.

Let’s say I have the price of several items in column A, and I plan to add more items periodically. How do I create a field that automatically tallies the total of column A as I add each item? Thanks for your help!

I am building an inventory table for a company that I am integrating into their duda website to display their products. On the main inventory page, the "main" image connects to the gallery widget with no issue. On the dynamic page that showcases each individual product, I'd like to highlight the 6-8 additional product images that I've uploaded into a field in Airtable titled "product images". When I connect a gallery widget to this field, nothing appears. Is it possible to connect a widget to a group of images? If not, how can I showcase all images without creating a separate field in airtable for each on and then connecting those fields to individual widgets on the site? Image attached of my setup. 

I have an automation that sends an email. Now to my question, when sending a message, there is always the sender's email address at the top and then the following (see attachment). Is it possible to remove the text highlighted in red?

I have a table that syncs from emailed data from CSV attachments. I need to be able to delete some individual records. (The data is not valid, and it's messing with roll-up calculations.) When I try to delete a record in the main record UI it's grayed out and says "To delete this new record, update this table's sync configuration so that records are deleted when deleted or hidden in the source." But I don't know how to get to the source since it's an emailed CSV? Can anyone advise on how I can get some records deleted from the synced table? Either through accessing the source data (how?) or through a script or API override of sorts? Open to any suggestions. TIA!

Is it possible to prefill and hide fields within forms in Interface Designer?Example... Hide and preselect project type based on where the user is coming from within the Interface DesignerYou can do that with forms outside the Interface Designer https://support.airtable.com/docs/prefilling-a-form 

Hello,I would like to know how to hide some options from a field in an airtable form.For example, my grid has a column that offers the following choices: "Office", "workshop" and "housing".In the form, I would like to display only "Office" or "Workshop".The reason for this is that this form is intended for people who are not supposed to be looking for "housing". On the other hand, in my overall grid, i would still like to see which actors are involved in "housing".How can i do that?Thanks a lot for your help,Pierre@Jeremy_Oglesby 

Hi! Is it possible to add a new record to a synced table but it not be added to the original synced source? If it is possible, can you tell me how to do this? Thank you!

Hello --I have a base that I have created that my coworkers use in Kanban view. I would like to assign keyboard shortcuts to the various "Add Record" buttons for each column in the view. Is there a way to do this? It would vastly accelerate our ability to use the table when additional detail beyond category is not needed for each record.

Hello All,I am creating a form to compile completed project data from a small architectural firm.  One field in the form links directly to an existing table of consultants.  When that field is selected, the list of consultants is visible and selectable but once an actual consultant is selected the box never seems to populate and the 'thinking' circle just spins.Does anyone have any ideas how to resolve this?Thanks!

Is there a way to set the default formatting for currency fields (or for that matter other number fields) either per base or per account/workspace?Every time I create a new currency field I have to manually change $ to £ and set the decimal places. This is tedious

We have a base where users go to print documentation from specific records.Nobody is supposed to be changing the Page Designer instance at all, but I think people are accidentally adding or moving fields when they access the extension.1) Is there any way to identify who made changes to the Page Designer configuration?2) Is there any way to limit who is allowed to edit the Page Designer configuration?Currently all editors are able to edit the configuration, and I don't see any way to change it - I'm really hoping I'm just missing something.Thanks! 😊

Hi! Is it possible to hide a field from an end-user form, but still be able to see it in my table view?That is to say, I need the field for internal information, but I do not want my customers to see that field when they fill out the form. Thanks!

Dear Community, I have a trouble to hide a field with conditions in form view and I’m losing my mind with this. My goal logic is like this: HIDE field 3, when field 1 contains “word” AND field 2 is not empty. But form view has only option to show field with conditions. How I can make this field disappear with show field conditions ? Trying to invert the logic do not work: show field 3, when field 1 does not contain “word” AND field 2 is empty. Any ideas ?

I'm looking to find others who are building Airtable-first products/companies!I'm starting my journey, so I'd love to find others to connect with as I'm starting out 🙂

Hi all, So, i’m testing the pro plan to see if creating an invoice might be possible. I see that it is possible even though blocks like page designer are not extensive. The problem is this. Let’s say i make one so from every record i can have an invoice. Is it possible to get this invoice (pdf) back into the table of the record? The person i am making this for only works from his phone for his company and i’m trying to improve his workflow. Otherwise would there be options where i can generate a link as part of the record and then through zapier and some pdf service create an invoice. I saw online that this is possible and for setting up it would be oke to do it on a desktop but in practice this all needs to be setup so it can be access it throught a mobile phone (preferable the Airtable app).

I’ve made an invoice system in airtable. I now need to export to send to a client. However I need my invoice to follow a certain naming convention to be able to use for later. I’ve made a function field to takes care of that. I can PDF from the print prompt and name my document, but I need to copy/paste the name from my function field every time. Is there a way to automatically name my PDF based on my function field?

There seems to be an issue with uploads for years, the bug is uploads / attachments are cancelled if you navigate to a different app or to a different screen/record. Is there anyway to get this fixed (ie. run uploads as a background process?). Running latest version of iOS / AirTable iOS app but the issue has been around for years.

I want to filter the records that I modified since 5:00 PM EST TODAY ? I don’t see the option to pick exact time in the options.