Other Questions

I’m prefilling a link in a button field to an adobe webform. It works perfectly if I click the button on desktop, but on mobile it encodes the # that adobes requires as is and doesnt fill the form. Is there something I change in the button? Its useless if mobile users can’t use it since most of the team uses their phones vs desktop. My button: CONCATENATE("https://na1.documents.adobe.com/public/esignWidget?xxxxxxxxxxxx*#”,”L-Number=",{L#s...},"&Name=",{ID.},"&Microchip=",{Microchip Number},"&Age=",{Years/Months},"&Breed=",Breed,"&Sex=",Sex,"&Fee=",Fee) iOS link that opens the right form but doesnt prefill: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXX*%23L-Number=CP21-069&Name=Cassie&Microchip=990000005808221&Age=1%20year&Breed=Border%20Collie&Sex=Female&Fee=175 Link that opens and works on desktop: https://na1.documents.adobe.com/public/esignWidget?XXXXXXXXXXXXXXX*#L-Number=CP21-069&Name=Cassie&Microchip=99000000

Hey there, we’re just starting using Airtable a bit more intensive than in the past. One of the biggest issue we are facing is performance when switching between tables. Our customer table only contains around 3000 rows of data but it takes 3-5 secs at a minimum to load each time we switch to other tables. There are connections to another table with around 8000 rows which are linked to the customers but I can’t believe it is checking these connections on every reload/switch to other tables, is it? If so the problem would only get worse with growing numbers and we could just stop using Airtable again. Any other idea?

I created a form (or survey) successfully and embeded it on a web page for my university class, but it is cut off. Not all the questions show, yet the submission button is there at the bottom as it should be. Any suggestions? Thanks KGB

Can you use automations in airtable to automatically extract a csv of a view in your base? I have a views that I’d like to have extracted automatically without having to go into airtable each time to do it. Can this be done? Thanks!

Is the a way that a non collaborator can take some (but not all) fields from an existing record and create a new record from it that then can be edited, using some sort of form, button or automation?. Ie Can I have a name, address, email address duplicated but not the various date/$ amount and various notes fields? We have a table that includes customer name and address and payments made and often we have to pay the same person more than once but with different amounts and for different reasons. I realise if we had known this from the start we could have created a seperate customer table but we are to far down the road to go back and change that. Thanks in advance

How do I filter a view where the date record created is greater than a specifc date? ie ony show records more recent than July 1st 2021 I assume it is simple but I can’t work it out.

Hello there, I have a table [Main] with PNG files in {Attachments}. Unfortunately, the file name is “UnnamedAttachment” for most of them. The desired file name (including .png extension) can be found in the field {Filename}. How can I manually trigger a batch name change of the files in {Attachments} to the the name in {Filename}? Thank you! Cheers Christoph

I want to create a view where I can see ONLY milestones. I don’t see a way to filter based on milestone. Ideas? I suppose I could make a new field called milestones, but was thinking maybe there is already a button.

Hello All, I created a table in my base called notes. Customized the field type to Long Text then turned on the Enable rich text formatting. Copied and pasted a bunch of town names into one of the cells. Clicked on expand cell blue button so I could see the whole list. When it opened it had a red zig-zag underline under most of the names. I was right clicking on them all one by one and selecting add to dictionary when I realized I had added one of them to the dictionary that was spelled incorrectly. NOTE: Undo from adding to dictionary only seems to work on the LAST word added. Q: How do I find this dictionary and remove the misspelled word so it is caught again in the future! Thank you Jonathan

Hi all, Is there a way to run Run the first Datetime formula and if an error automatically run the second date time formula to pull the information in? DATETIME_FORMAT({Date Paid}, ‘MMMM-YYYY’) DATETIME_FORMAT({Order Date}, ‘MMMM-YYYY’))

Hot off the press! Airtable is acquiring the team and assets from Bayes to help people better manage complex workflows) :blush: Seems like we can expect some new and/or improved apps no doubt. Today, we’re announcing that Airtable has acquired the team and assets from Bayes, a no-code data visualization tool that shares our vision of making highly technical concepts more intuitive for non-developers. […] This is Airtable’s first acquisition, and the Bayes team will now focus on strengthening Airtable’s data visualization and reporting capabilities, including better insights for people who manage bases and new ways to depict complex workflows.

Hi I was wondering when you export a table to a website can i also export the search so as to use the search to bring up relevant information onto the site.

I am aware that Airtable does not have included functionality to use the embed app based on a field in a record. Is there a custom app or other option to accomplish this? Possibly using the field URL in an iFrame through Javascript or typescript? I want to be able to view a google doc URL from a record as an embedded URL so we can type and update the doc in real time without leaving Airtable.

Hello I have in my base five columns: Product Name (starting point) (ex: Apple Macbook) Main Color (optional) Secondary Color (optional) Finish (optional) Product Variant Name (formula) I am trying to write the following formula to generate the “Product variant name” , but having a hard time: Product Variant Name = Main Color + “,” + Secondary Color + “,” + Finish However, IF ANY of those three optional fields is (blank) then skip it as well as the “,” corresponding to it My hope is to get in “product variant name” a clean product name. How can I do so? I get lost when trying to use the IF / AND formula :frowning:

Is anyone using airtable to crunch census data? I’m curious if it’s a good fit and if anyone has jumped in.

I don’t remember my new password. I have the old password. I didn’t register via email because contains special characters " _ ". How can I log in again? Thanks

I am trying to do a look up based on two fields. Here is the situation: my first field is called Severity and it is the primary field of a “severity definition” table, which contains 5 records my second field is called Probability and it is the primary field of a “probability definition” table, which also contains 5 records I have created a junction table, called “Risk acceptability” which is built with the two above-mentioned fields; the primary field is built as a formula (Severity&"-"&Probability). On that table is the field “Acceptability” which is the one I will try to lookup. See below -Finally, my FMEA table will allow for any new record to pick a Severity and a Probability: I would like to automatically have the “Acceptability” appear. So I have created the same formula in that table (Severity&"-"&Probability) to lookup to the table “Risk acceptability”. Problem is: I cannot create a Lookup based on the result of the formula. So my question is: how can I use

I have a form that i send to my faculty and I want them to be able to choose their own name “record” and have the data show up in that “record”. I figured out how to get a drop down for the faculty to choose their own name but when they input data it creates a new line “record”…Boo on that!

When using Filter in Grid view, I can filter across linked field with multiple values. However, for the same field in Calendar it doesn’t work. As seen in the screenshots, filtering for a name returns multiple records in the Grid view but not in the Calendar view. Is this a known issue?

Hi, I am trying to add comments on table in airtable but not able to see any option from where I can comments on table, but there is option for comments on using row only. My question on comments is Can we write comment on table directly instead of write comment on row? Is there any API available for write comments or retrieve comments? Thanks

I track contract dates in Airtable. I need to use this field as a reference in an email automation. However, in order to have the date show up correctly in the automation, I have to use the Set_Timezone formula –here’s my formula --DATETIME_FORMAT( SET_TIMEZONE({Contract date}, ‘America/Los_Angeles’), ‘MMMM D, YYYY’)– When I use this formula, the date now changes in this formula column in my database to the day before the date I have in the Contract Date field. This seems ridiculous that this is an issue and I assume I’m doing something wrong. I could just write a day ahead of the actual contract date to “solve” this issue, but again, this seems ridiculous. How can I set up my Airtable so that when I input the contract date, it’s in the timzone I’m in, so that my formula field (which I have to use so that it shows up in my automated email) is synced correctly with my Date field?

I have entry and exit dates (date range) for volunteers to our project. Each volunteer has a separate record. I need a formula or method to show on a calendar how many volunteers I have on any given day by referencing the entry and exit dates of the volunteers.

Hello Airtable community! I have Table 1 with over 10K records, and I want to link every single record there to Table 2 in the Linked Record Field such that everytime there’s a new record in table 2, the Linked Record Field already has all records in Table 1 linked. I actually found a solution through the Automations app and followed this instruction: Linking existing records using automations – Airtable Support But it seems to not link all the records. So I reached out to Airtable support and found that there’s a limit of 1000 records linked in this way. So I am wondering if a Script can solve the 1000 records limitation, and if so, I am happy with the solution where everytime I have a new record in Table 2, it all records in Table 1 are already automatically linked, or I can take an additional action like checking a checked box as a trigger (as suggested in the Automations instructions). Thanks in advance!

Hi everyone I’m using n8n.io to facilitate the process of sending email via AWS SES. The small issue though is that the various nodes used in n8n to send email (both generic email node and AWS SES node) don’t seem to play 100% well with the body of the text I link to it, which sits in a lookup column in my airtable table (looking up from a Long, Rich Text enabled column from an another associated table). Basically, my results of sending such text from n8n suggest the AirTable Long Text (Rich or not) via a Lookup is neither sending across plain text or html text, and instead something in-between. Thus is there anyway to convert the Long Text to pure html? Thank you Stephen

Hi! I am using Zapier to autofull documents based on airtable inputs, I am struggling with checkboxes and trying to use formula fields to provide me with a “true” or “false” based on the input of a single select field. Has anyone used single select to provide a true or false outpouts, I am stuck!