Other Questions

Hi All! I am creating a form in Airtable and would love to allow users to see specific text based on their responses. I am familiar with using conditional form fields, but they seem to be limited to fields that require a response. I’d like to do something similar, but just with next that would inform the form user. Does anyone know if this is an existing functionality or if there are plugins to make it possible? Thank you!

Dear community,All the data in my database is formatted as DD/MM/YYYY. This question is about meetings we have. The meetings should be link to other records. But when I want to link the meeting with date format DD/MM/YYYY in another table, the format is MM/DD/YYYY, which is quite confusing. Any idea how I could solve this?There is a screenshot of the situation attached. 

So many new goodies from Airtable yesterday! I did not see the JotForm integration coming, but was so excited when I read the newsletter. After playing around with the feature, I realized that mapping JotForm Fields to Airtable’s Linked Record Fields is not supported at this time. I contacted JotForm about this and was told they put in a feature request to their backend team, but couldn’t guarantee it would happen. No idea if this is something entirely on JotForm’s end, or if Airtable is able to help them maybe ( :slightly_smiling_face: ?), but I wanted to put in a word here and say how helpful enabling this feature would be. Without being able to map JotForm fields to linked record fields in Airtable, the integration is basically useless in all of my workflows. Anyone else have any thoughts?

I am in Seattle, using my local time zone, Pacific Standard Time (GMT -8). One of my columns, ‘Start Time’, contains a Date value of “1/2/2016 10:00”, but when I reference it in a separate column using DATETIME_FORMAT({Start Date}, ‘MM/DD/YY HH:mm’) the time displayed is 8 hours ahead (18:00). The same thing occurs for any other times I reference. I see that I could use SET_TIMEZONE, but do I need to use this whenever I want to have the results of a formula in my time zone? Is this a setting I can change in my account or base, anywhere?

Can someone help? I am trying to prefill our customer intake form with the source so I know where the form was filled out (i.e. from our website, at an event, ect.). When I change the URL it is showing correctly in the form, but when I submit it to Airtbale the source field is empty. Am I missing something?

Hey Community :D I know feature requests should be submitted using this link. However, I thought it would be fun and relieving to post my pain here as well.I love Airtable. Hands down, the best software I ever used. However, there are some things that could be def improved (1st thing is forms, but that we discussed on way too many posts already).Something I’d really like to have is the ability to apply filters at a group level. i.e. when working on a grid view on my base, and applying groups, I’d love to filter my view by conditions met by the full groups, rather than the individual underlying records. Example:“Show me all groups with size bigger than 1 record”.Yes, I could come up with crazy workarounds where I link all of the records of a group together, create a lookup, rollup, or count or other type of helper field, maybe have an additional formula filed to bring values of all lookups together if needed, and then apply a filter on such field on a record level (which would show valu

I am adding descriptions to records and they are showing up in Grid View but not in Calendar View. How do I get descriptions to show on Calendar View on the AirTable calendar imbedded on my website.

​ I have followed this to a tee but I am missing something here! I have a table called Certified Partner Data (CPD). It is essentially my Main table from the exercise above. I have a field called TRIs in that CPD Table. I need to rollup the sum of that column. I have created a Calc table and made it Link to CPD. I see all of records of CPD in one row of Calc. I go back to CPD and create a Lookup field going back to the rollup in Calc of the TRIs.Below is what I see when I when I view CPD. I have it filtered to a single month and you can see the TRIs column = 15 (column total at bottom) yes my Total TRIs is showing 554. That is the total NON FILTERED. The filtering on CPD has no effect on the Calc results. I am SO close but can’t seem to get this part to work. I am filtering on a Single Select “Month”. Why is it not picking up the Filtering from CPD? And as always, thank you!   ​

Hope I’m putting this in the right forum. I could swear that, a long time ago, I saw Gareth Pronovost demonstrate how you can generate a URL that will load an existing record into a form so a user can edit it. All I recall really recall is that it involves getting the record ID into the URL. But I’ve been searching for how to do this and can’t find it. I’m talking about a technique that does not require anything outside Airtable. I already know how to do this using miniAutomations (and that works great). But I’m trying to do it without miniAutomations or any other helper service. Anybody able to throw me a clue? Added a minute later: To be clear, I’m NOT talking about prepopulating fields in the form. I know how to do that, too, using ‘prefill_’ and encoding the URL. When you do that it simply prepopulates certain fields with values, but when user hits Submit it creates a new record. I want to edit an existing record and then save the changes to the same record.

So a big reason I chose airtable was that it had an app, so that myself and my other user could input data in the field. Except now that I've spent dozens and dozens of hours building something with forms etc, I see that forms don't actually work on the android app...!What's the work around for quick in-field form submission? That's a surprising oversight, and I see people have been complaining about this for years..

It looks like the forms in AirTable have recently gotten a bit of a revamp. Is there a way to add blocks that just contain helper text? I essentially want to include text giving directions and reminders to the form taker as they are going through the form. I know a field can have helper text added, but for the form I'm creating, there are certain pieces of info/reminders that aren't necessarily directly related to a specific form field question, but it's info that I still want to remind the form taker about. I can add it as helper text, but it won't flow as well.

I know a few years ago it was not possible, but I'm curious to know if anything has changed. I have a long form that I'd like to split into multiple pages. Is this still impossible to do in Airtable? Is my only solution to use an external service like JotForm?

Hi, I have connected Jotform with my Airtable. Everything works perfectly fine. Information was able to save on Airtable appropriate. I chose the E-signature widget on Jotform, is there any way I can save it on Airtable as an image? or what should I do with it? Any suggestion？

I see there have been a handful of posts pertaining to e-signatures in AT forms, but I decided to add another one since the most recent seems to be from 2021 and we know how fast things change in this space. My specific use case revolves around credit card authorization forms. As we rebuild our company website, one request from the CEO is to add an embedded form to our site. As it stands we use Adobe to create an editable PDF however I don’t currently have access to our login to explore what a logged-in admin sees when receiving a completed form. Currently we send the editable PDF form to clients via email. Most clients…it’s an old school industry, then print it, fill it out, scan it, then email it back. We then scan and file the hardcopy away. In my mind the ideal flow would be to embed on our site, allow user to fill it out with esign, and have submissions stored in a table somewhere (either adobe or AT) Any advice is appreciated.

Hello ! I’d like to track leads who fill the airtable form embed in my website in order to make Facebook ads. Do you know how I have to set GTM to manage it ? I first created a thank you page but my browser (Chrome) blocks it as a pop up page (perhaps because my website juggles between my domain name and Airtable one ?) and I’m concerned my customers have the same issue. Thank you for your help ! Greg

Very new to this. Is there a way to create a fill-able form for my employees to fill out and submit. When they submit it, I’d like it to show up as an attachment next to their name in their row. I don’t want to create a new row for each form submission because it’ll add up quick with everyone doing weekly forms. My employees have to fill out a form every week and submit that so I need a way to keep track of who submitted/when and keep them all together. Thank you!

Hi all, we’re a custom sportswear company using Airtable to track orders. At the moment we have a single line item for each garment ordered, and the numbers of each size. The view is grouped by contract number so we have all garments for each client grouped together. So for example we might have: Line Contract Garment XS S M L XL 1 1875 Bobs Bikes Cycling Jersey 1 2 3 2 1 2 1875 Bobs Bikes Cycling Shorts 1 1 1 3 1 3 1875 Bobs Bikes Cycling Jacket 0 2 2 1 0 My question is whether I can collect this information in an airtable form to auto populate our airtable? I have tried creating a form for this but under Garment it will only allow me to choose one garment, OR I can setup the garment field to allow the form filler to choose multiple garments . But in the former case I can only collect information about

How can I turn off spell checking? I use this entirely for foreign-language content (all non-English words) and Airtable is underlining every single word!

I have found some posts on printing mailing labels via Page Designer, but they were from 2018. Since it is 2023, I was hoping if there was a way to print on Avery labels with Airtable. I don't have an actual label printer, just a regular old printer and some Avery sheet labels. Be aware that every label would be unique.Example: 

Hi,We are an academic library. We don’t have a facebook account or any connection to facebook that I know of. However, I noticed when an interface was loading, that my browser said “waiting for facebook.”When I looked at the html of the page, I found this:<img height="1" width="1" style="display:none" alt="" src="https://www.facebook.com/tr?id=418406606004092&ev=PageView&noscript=1"/>We’ve found similar non-displayed links to facebook on other pages.Is this expected? If so, what does it do? And is there a way for us to turn it off?Thanks,Joe Montibello

I’m having a hard time finding the correct links for the columns-  airtable API key (which tells me I’m supposed to create a token for it which I did but not too sure on how to copy it and paste it on there) Airtable database app (not to sure where to find this located either.) My goal is to make it close to the template that it provides with the leaderboard. I‘ve created my own already with the AI source.  Would like help!! 

I’ve seen something like this asked, but not really seeing responses?  But it got me thinking….  Is it really possible to have two different forms feed into a single base?  My thought process is this.  Creating an onboarding base so we can make sure we get everything completed for every hire.  But questions we ask on applications can vary based on the job(s) they are applying for, so having several forms with the specific questions would be great instead of having questions that only certain people would fill out or verbiage that is correct for some, but not for others.Is it REALLY possible to do this?  Yesterday I was trying to determine if there was a way to set up a form with sections so that each section of questions was for specific jobs, but the form will be LONG.  Having different forms based on the job they are applying for would be much better, if it will truly work.

Hi, I created my first form today and liking the tools, however i find the linear scrolling required to access a multi-field form a bit long winded… Can i modify the layout and locate fields where i need to, to make the form more compact and intuitively laid out, and potentially all fields on a single screen/page? I looked at a thread from 2020, and it mentioned JotForm using Zapier ? Has there been any changes since then to Form layouts for Airtbale? Thanks You, Simon.

I’m trying to create a form that will allow club members to order multiple products. Each product has different color and size options, and I can’t figure out how to build the table to then create the form with all the different options. Any suggestions? Thanks, Dave

I noticed differences in the revision history of a record when i open it in an interface vs. when i open it on a table. How? Why?in interface, last edit 4w ago (but last edited date shows 1 day ago...):in table the edits from 1 day ago show up. they relate to a linked record...: