Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
jord8on
jord8onInspiring
posted in Other Questions
Use Form to capture daily progress of external users

We have an initiative where we’d like to populate a table of users, while allowing these users to come back daily, weekly, etc. and fill out the form to “check-in” with their progress on specific activities. Need to create a database of users Users need to be able to come back at regular cadence, to input same data points Data should be associated with particular user each time they log, based on email Users can’t see list of other users We’d like to have a form where there’s a form field for user’s email address (unique identifier for the record of a “Contacts” table), and we’d ideally like to obtain first name, last name, email address, and phone number, upon creation… Then these existing users will come back regularly to “log” their progress on a few key activities. We want this data to be associated with their existing user ID, that was already created (email address). BUT, we don’t want users to see other users or be able to log progress for anyone other than associating it with

111
Kamille_Parks11
Z
Zach_DykesNew Participant
posted in Other Questions
Iframe embed into elementor too short

I’m using the embed feature to put conference speakers onto a page of our website. I use elementor for the design of the website and I am using chrome to do the editing. I’ve attempted to change the height associated with the iframe, however it remains the default height. Any ideas?

30
Z
B
Bernice_EbenezeNew Participant
posted in Other Questions
Stuck with airtable design for my Webflow website

Hi fellow airtable users, I’m trying to build a no-code solution with Airtable, Memberstack, Webflow and Zapier and I’m stuck with the airtable design for the set up. Here is a gist of what I’m trying to achieve through this. I’m using Webflow/Memberstack as my front-end to create a place where a user can customize an ecard to be sent to one or multiple email recipients. My first step is to collect an image and a text for the inside of the card via a form(I created an inside info table for this) and another form to collect the back image and text for the card(used another form and a table called back info). I would like to link the 2 tables(inside info and back info) using a common identifier(not sure what that is to be. Maybe it should be an email field), but at the same time need to know that the 2 records belong to the same card. How do I set this up? I’m using a Webflow form to pass the email address from Memberstack to the airtable form(Inside info and back info). But I’m unable

20
B
C
ChrishelleNew Participant
posted in Other Questions
Watch for a Deleted Record using Integromat

Hi Guys, Is there a way for deleting a record across two bases using a trigger? The watch record trigger in integromat only detects for created and last modified record/field. I would love to have a watch trigger that detects deleted record as well. For example, if I delete a record in Base1, it would automatically delete same record on Base2. Is there a workaround for this? Thanks,

158
ScottWorld
Burner
BurnerKnown Participant
asked in Other Questions
Prevent linked reference field in Form from accepting new values that aren't in the reference table

So I have a table called “US states”, which other tables have linked fields to. One issue I encounter often is that when I have a form in a different table and add a field called “Select state”, which is linked to the “US States” table, I often have people who fill out the form start typing in the state and accidentally insert a new State (sometimes misspelled or sometimes just the abbreviation) thereby creating a new record in the linked “US States” table. Is there a way that a linked field in a form restrict creation of new records and only allow users to select from the list of linked records?

560
Burner
J
Jarryd_WilliamsParticipating Frequently
posted in Other Questions
Embedding images in a Basecamp to-do

Good Day, I am looking to run a scenario through Airtable where a webhook activates an integromat scenario, which creates a to-do in Basecamp. My issue is that I am having a problem uploading the images to that to-do. All that comes through is the URL. Has anyone had any experience with this?

125
ScottWorld
K
Kyle_StensonInspiring
asked in Other Questions
How to prefill form where field type is "Checkbox"

Hello, I am wondering how you can prefill a form where the field type is “Checkbox”. For instance, I have a Contact Info form I send new clients. I have two Checkbox fields that I do not want them to see but would be helpful for me to be checked. When checked, mark the client as being an Active Account and an Active Contact. Field Names “Act. Acc.” “Act. Con.” Example Prefilled Form URL Client Contact Info Form???&prefill_Act.%20Con.=???&prefill_Account%20Name=Client%20Name&prefill_CSM=First%20Last&prefill_ST=UT&prefill_Acc.%20Exec.=First%20Last&prefill_Account%20Name%20Dropdown=Client%20Name Thanks in advance!

640
K
C
Chris_SchultzNew Participant
posted in Other Questions
Need help with having an email address automatically populate

I have a field for employee names created. It’s a single select field with all their names available to choose. Right next to it I have an email field. I’d like it if when I choose a name, their email address automatically populates in the field next to it. Can someone help me figure out how?

4010
Ben_Young1
J
Jessica_BlancheNew Participant
posted in Other Questions
Tracking history of shipping locations?

Hi, I am new to Airtable and I am trying to migrate my studio’s crate inventory (crates contain artworks that we ship to museums and then back to us). We used an excel sheet unto which we had a ‘‘history’’ box. That is where we’d manually list all the previous locations with the years of where a specific crate had been shipped before returning to us. Is there a clever/simple way to keep track of such info in Airtable? Like a tab that keeps track of each crate’s previous locations when we update its current location? I hope this makes sense, thanks y’all!

135
C
V
Vish_BhatiaNew Participant
posted in Other Questions
How to query two tables with a linked record?

Hello, Can someone help to create this query in Airtable? Table 1 fields are: FirmID Firm Country Table 2 fields are: Firm ID Firm Contact Name Find all “Contact Names” from [Table2] where Country=“USA” in [Table1]. where FirmID is a one-to-many join. Is there a way to do this in Airtable? Thanks

10
V
B
Becca_PickettNew Participant
asked in Other Questions
Referencing Holiday String in a formula

Hi! I’m working on setting up a long-running {Task Due} date formula field that will eventually span across multiple years. The {Task Due} date is already successfully calculating a variable workday amount prior to the {Key SR Date} (the date of the actual event) using negative values found in the {Days Out} field. I’ve created an IF set up to accommodate some of the {Days Out} are 0, where I want the output to be the same as the input. Here’s the formula I’ve got going successfully: IF(({Days Out}=0), {Key SR Date}, (WORKDAY({Key SR Date}, {Days Out}))) Now, I want to factor US holidays (and specifically a string I made for my company’s holiday list). I created a separate table with a {Reference Year} and a {Holiday String} field so that I can create a string for 2022, 2023, etc. I’ve used lookup fields on the current table so that the correct Reference Year is applied to each record, and it displays the applicable {Holiday String} from the other table. My thought was, shouldn’t I be

330
B
J
Jessica_ShinParticipating Frequently
posted in Other Questions
Import Airtable to Power BI -> not working

I’m having a trouble connecting rest API for one of the tables that collects sales data for my business. Since I cannot share streaming graphs of this data in airtable with my partners, I would like to bring in airtable data to power BI so that I and my partners can look up the situation at any time. I have connected google, facebook, google sheets etc. to this service however, airtable is the only one that I’m having a big issue. Given the API URL : https://api.airtable.com/v0/[base ID]/[table ID]?Api_key=[your api key], I have tried so many method to connect in power BI, It doesn’t work. not to mention there is paid service out there that specialize connecting airtable and power BI only. Please help me how I should resolve this issue. Thanks in advanced.

101
B
N
Neal_MillerNew Participant
posted in Other Questions
Limiting the number of selections in a multiple select field

I want to create a multiple select field and on the form limit the number of selections. As an example, there would be 10 possible choices but I want the respondent to select five, no more or less. Can this be done in Airtable?

282
N
Drew_Nemer
Drew_NemerKnown Participant
posted in Other Questions
Restricting Views amongst Collaborators -- or a workaround

We have created an Airtable in our company that will be used for employees to log their monthly caseload recertifications so we can better track them. They will be entering and updating their recertification on a daily basis. however, we later realized that there is no built in privacy for our employees to use airtable and prevent them from seeing each other’s performance. it isn’t a welcome feature because we know that there is a risk to having everyone see how you are performing on an individual basis–can create a toxic culture. the new interfaces feature looks promising as a solution, i was wondering if anyone has a recommended workaround? Drew

21
ScottWorld
V
vidhun_prakashNew Participant
asked in Other Questions
422 Client Error: Unprocessable Entity

Hi! I am trying to write data to a airtable from Rasa chatbot. But when i run the code, it returns me a 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/<base ID/<table_name> error. load_dotenv() airtable_api_key = os.getenv("AIRTABLE_API_KEY") base_id = os.getenv("BASE_ID") table_name = os.getenv("TABLE_NAME") def create_convo_record(category, price, storage, ram, battery): request_url = f"https://api.airtable.com/v0/{base_id}/{table_name}" headers = { "Content-Type": "application/json", "Accept": "application/json", "Authorization": f"Bearer {airtable_api_key}", } data = { "fields": { "category": category, "price": price, "storage": storage, "ram": ram, "battery": battery, } } try: response = requests.post( request_url, headers=headers, data=json.dumps(data) ) response.raise_for_status(

7242
V
S
Sam_Giovenco1Participating Frequently
posted in Other Questions
How to send an email/sms from a record using a template

Base record that contains customer email who i wish to send to inform or request to collect information using series of templates. Could be follow up of a lead or requesting further information to processing their enquiry. Something like adding an email button but how do i connect this up

111
kuovonne
H
Haley_LopezNew Participant
posted in Other Questions
Automated data not updating on original table

Hi I have created an automation where by changing the status of a record it will create a new record on a new table. In this instance it’s a record in a dealflow and then by changing the status is will then create an entry in a task flow table. When I then update the status in the task flow table it doesn’t update the status in the original dealflow table, how can I make this happen? What I ultimately would like to happen is that my task flow table will only display entries that have a certain status and that this status is updated in all other tables this entry is shown on Thank you

196
K
A
anand_makwanaNew Participant
posted in Other Questions
Limit data entry to through forms only

Hi, is it possible to limit a table such that a new entry can ONLY be created through a form and NOT through gird view or any of the other views? The problem i’m trying to solve is to make sure that all the relevant data is entered. this can be done with a form but people can create an entry in grid view and not fill out every important field. thanks Kind regards

402
A
H
Hamutal_LadanNew Participant
posted in Other Questions
Linked record with to different views accourding to conditions

Hi, In my main table I have field “id” and “sorting Group”. Second table with fixing problems and “sorting group”. that has views according to the “sorting Group” field. I want to add a field in the main table that will have Allow linking to multiple records & Limit record selection to a view BUT will take each tiime different view from the second table accourding to record “sorting group” How can I do that ??? I can’t find how to make condition to the views … Thank you

00
H
A
Arnaud_DesclauxNew Participant
posted in Other Questions
Apply same filter on mulltiple rows

Hello. I would like to apply the same filter on multiple columns. Seems simple… but not at all! ie: Today if I want to filter records wich contains the word “test” in at least 1 of 3 columns, I have to configure filter by adding each column to the filter. I would like to configure something like this: IF “column A” OR “column B” OR “column C” contains “test” IRL I need to filter on 15 columns and I would like to have a dropdown menu in my interface to chose a world to filter… Hope you’ll help me! Thx a lot!

02
ScottWorld
T
trashcaneronKnown Participant
posted in Other Questions
Checklist Copy-Paste

I use the LONG TEXT field on my records as a way to put in subtasks as checklists - these aren’t linked to secondary tasks, but they itemize the steps I need to take on a specific task. I’m often copying from something else to add in to the checklist. Here’s what I don’t understand. This is the list I copy: VFX-01 VFX-02 VFX-03A VFX-03C VFX-04 VFX-05A VFX-05B VFX-05C VFX-06 When I paste it in, it looks like this: Is it possible to paste it in so that I don’t have to manually add a checkbox to each line?

186
T
T
Tarah_KendallParticipating Frequently
asked in Other Questions
No "My First Workspace" option

I’m new to Airtable and have only used bases shared with me. I created my own base, and need to make it private. A colleague told me to move it to “My First Workspace”…however I don’t have that workspace as an option.

390
T
F
Filippo_LivornoNew Participant
asked in Other Questions
Issues with Notion integration

Hi all. I have the following issue: I want to integrate a table inside a Notion page. In my table there are links to Google Photos albums, but they don’t work (they do instead work if I copy and paste the same link in the browser). I don’t know if this is an Airtable, Notion or Google Photos issue though… Anyone experienced that before? Thanks.

290
F
M
Matthieu_HaenenNew Participant
posted in Other Questions
Update record via Barcode

Hi ! I have a question about Barcode in Airtable. Is it possible to update record in an Airtable base via scanning barcode? Like, if I scan a barcode of a record of my Airtable base, can I attribute to it another field via scanning another barcode of another record of my Airtable base? Is there an application to scan barcode and can synchro with my Airtable base? Thank you and have a great day !

61
ScottWorld
P
Piano_SenseiKnown Participant
posted in Other Questions
Limit choices for time slots

I want to have people sign up for time slots. Can I have it remove each one for the next person? In other words, say the options are 1:00, 1:10, 1:20, 1:30, etc. When someone fills out the form and chooses 1:00, can I have it removed from the options for the next person so each time slot only gets one person?

9414
P

Badge winners

Show all badges
Terms & Conditions