Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,761 Replies
10000 Topics
R
R_Dillon_EmericNew Participant
posted in Other Questions
Trying to create a self-study quiz for my students from a table

Hi everyone, I’m teaching a course which requires students to label and recognize certain kinds of sentences. I have a list of sentences for them to practice on in a table and the answers in the next column. I’d like to set up a kind of self-study tool for students. The Flashcard App would work really well for that, can I somehow share that with my students? It’d be even better if I could randomize it. The ideal use scenario would be a multiple choice test that would grab, say, 10 examples and then reveal the correct answers to students when they submit. But I’ll take what I can get! Thanks!

101
ScottWorld
J
JohnBatemanNew Participant
asked in Other Questions
Multiple Bases & Task lists for different clients: I want due dates to populate into a single table & google calendar

I need to manage multiple deadlines for multiple projects & clients more efficiently. I don’t want to update deadlines in multiple places, but that’s where I am. This isn’t efficient and will not work for the long term. Here is the current setup:I have a Primary Base I use to manage grant research, tasks, and profiles for all of my Clients. This includes 2 key tables: a Research Table and a Task Table. The Research Table is filtered into views that are specific to each client. Each of those views are synced to a Table within a Separate Client Base. That Separate Client Base also includes a second Submissions Table that is manually updated with specific due dates and other requirements that are unique to that Client (although some research may be relevant to multiple Clients, specific details will be unique to each client). This Separate Client Base is shared with each Client. The Task Table (in the Primary Base) is manually updated with a wide range of tasks that is grouped by Clie

183
TheTimeSavingCo
drnemer
drnemerNew Participant
asked in Other Questions
External User Portal options. — what do you recommend

My organization seeks ability to create Airtable based apps with a proper user portal for external users to create/register and log into their profiles.  Unfortunately, Airtable portals doesn’t fit our budget for the number of external users we might expect. (Approx 400).  (we have business plan by the way) Even Softr is pretty pricey, but it seems like a halfway decent option.  I have looked into many different options from Pory.io, Zite, Stacker, Noloco, Glide, WeWeb, Bubble.io, Jet admin, etc  even thought of possibly seeing if I could linked Airtable to a supabase and build portal in Bolt.  I am not very technical, but I want to learn how to do this myself and help build a solution or find the right one.   there are so many options, and let’s say the budget is $2000 per year for approx 400 external users.  This is on top of the existing seats paid for the business plan for internal users.  what do people recommend, and why?  Please feel free to DM if you can offer more guidance. 

263
ibayub
M
Michelle_McNameNew Participant
posted in Other Questions
Fiscal Year support on Gantt

Hello! I wonder if you might give a way of offsetting the “Q1”, “Q2”, etc markers on the Gantt timeline, to support a fiscal year that does not match the calendar year. Or, if not that, to hide the markers altogether. I realize there’s a way to use formulas to have fields reflect an offset fiscal year based on dates, but I don’t believe it’s possible to change this header and it’s very confusing for viewers. Thanks!

295
phillipsry
J
JenGNew Participant
asked in Other Questions
Help to find a deleted record

How do you reinstate a deleted record? It’s been 24 hours since we've noticed - is there a way to revert to a previous version?

704
Mike_AutomaticN
N
Nathan_CainKnown Participant
posted in Other Questions
How do I create a url with a formula?

This is what I have tried: "http://nwatagalog.xyz/maps/"&pinColor&"/“number_”&sort&".png" I’m getting this error:: “Sorry, there was a problem saving this column. Invalid formula. Please check your formula text.”

5759
B
jowan_qupty
jowan_quptyKnown Participant
posted in Other Questions
Link to run script

Hey all, I’m experimenting with an idea but am not sure it’s possible (yet) and I would love to hear your input on whether this is doable or not. I have a script that spits out custom reports. Is it possible to insert a button (or link/hyperlink?) into the report, to act as a button which would then run another script? Thank you

16083
Mike_AutomaticN
M
Michael_NorrisKnown Participant
posted in Other Questions
Limit number of attachments in an attachment field

Hi there — I suspect the answer is ‘you can’t’, but is there any way to restrict a user to only be allowed to upload a single attachment to an attachment field in a Form view?

13412
Mike_AutomaticN
S
Shaleece_HaasNew Participant
posted in Other Questions
Creating conditional text blocks within a form

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!

794
ScottWorld
T
Trung_NguyenKnown Participant
asked in Other Questions
Unable to duplicate base (stuck >12 hours)

I am experiencing an issue duplicating one of my bases. The details are: Base ID: appMbMonUXRj3FMXX Base name: QUAN LY TNC Issue: When I attempt to duplicate the base (both with data and with structure-only), the process never completes. The dialog shows “Duplicating your app is taking a bit longer than expected,” but even after more than 12 hours, the duplication does not finish. Troubleshooting attempted: Tried duplicating with full data → stuck. Tried duplicating structure-only (no records/attachments) → stuck. Tried in multiple browsers and workspaces. Waited over 12 hours without completion. Already tried to create a new base from a snapshot → still unsuccessful. Anyone have experiences in this matter?

00
T
S
SidStuntParticipating Frequently
posted in Other Questions
Date format

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. 

15712
A
A
AlliAlosaInspiring
posted in Other Questions
New JotForm Integration - Mapping to Linked Record Fields

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?

215
ScottWorld
C
Chris_RutledgeNew Participant
asked in Other Questions
Choosing the time zone used for Date and Time functions

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?

24767
P
A
Aly_FossettNew Participant
posted in Other Questions
Pre fill form issue

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?

799
A
Mike_AutomaticN
Mike_AutomaticNGenius
posted in Other Questions
Feature Request: Filters for Groups

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

190
Mike_AutomaticN
V
VCD at OlinNew Participant
asked in Other Questions
Adding Descriptions

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.

233
L
J
Jon_EynonInspiring
asked in Other Questions
Filtering from Main table having no effect on Calc table... Linked records

​ 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!   ​

6411
Mike_AutomaticN
WilliamPorter
WilliamPorterBrainy
posted in Other Questions
Generate URL for form that allows editing of an existing record

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.

1035
ScottWorld
O
oreocereusKnown Participant
posted in Other Questions
Using Form on Mobile

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..

5956
MargeM
M
Megan_BishopKnown Participant
posted in Other Questions
Text on forms?

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.

3734
MargeM
S
southwestNew Participant
asked in Other Questions
Form with multiple pages

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?

3889
MargeM
P
Panda_loverNew Participant
posted in Other Questions
Save Jotform's e-signature on Airtable

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？

466
ScottWorld
D
Dustin_GoodKnown Participant
posted in Other Questions
Revisiting E-signatures

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.

4146
MargeM
G
Gregoire_de_MonParticipating Frequently
posted in Other Questions
How to trigger Google Tag Manager when an Airtable form is submitted on my website?

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

989
ScottWorld
A
Alyssa_BuchholzNew Participant
posted in Other Questions
Submit PDF forms as attachment

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!

224
ScottWorld

Badge winners

Show all badges
Terms & Conditions