Other Questions

I am new to Airtable and I work in Procurement. I have built something for our buyers to use and track all projects and contracts. What I have not been able to successfully do is create a savings report for upper management. I have looked online and youtube and I have been unsuccessful. Can anyone be so kind as to help me? 

Hi there. I’m pretty new to airtable and am having an issue with something that feels like it should be quite simple so I am assuming I am missing something obvious. I have a Product table linked to a Product Bundle table. In a single record in the Product Bundle table I have multiple linked records from inventory from name, cost roll-up, quantities etc… Works great. One thing that would be super handy is to find the individual item that is linked from the Product table with the closest expiry date. At the moment I am able to use a roll-up max value field to find the earliest expiry date but I cannot figure out how to reference the record name that it belongs to. For reference, I have 10-20 products linked in one bundle and the expiration determines how I will sell the particular product or if I can at all. So, by finding the record with the earliest expiry date, I

I created a Form but don't see it in my Data view. 

I am trying to add a hyperlink that will direct applicants to a third party website within the help text of a form, in order for applicants to visit this site they will currently have to manually copy and past the link in to their browser.  is there a way to have it so that they could just click on the link provided and that would open up the link? so this english proficiency test link is the one I am referring to…   Thank you in advance!

So CSV has proven to be a problem for me. I downloaded a CSV file from Homebase, the database my dad used before either of us had ever heard of Airtable, and his product description cells were separated out because of all the commas within. How do I prevent that from happening with Airtable? I’m currently combing through my dad’s 50,000+ records to cut-and-paste clauses back into their origin cells and it is a complete nightmare. It’s not something I can do every time I download a CSV file from Airtable. Please, oh please, tell me there’s a way to avoid getting cells separated out because they’re long text fields with product descriptions that include commas. :fearful:

Hey Everyone,I’m working on a shared Airtable base, and I’d like to restrict certain team members from seeing specific views while still allowing them to access the base. I know I can lock views, but I need something more like custom permissions per user.Does anyone know if this is possible natively in Airtable?Thanks!

Is there a way to created a FORMULA for assign automatically in created a number NOT REPEATED between 1000 - 9999? Sorry i am new and no programmer.Option 1 formula and assign automatically, is no posible to NOT REPEAT, no problem i order table and search repeat, and change manually and assign other numberOption 2 I hava a table with 600 number aleatory. Assign it each a row is created. ¿Its posible?Thanks 

I have a database of contacts and I would like to keep a record of the activities or meetings in which they participate (I don't know if in each activity I should adjust the form for this action). But it would only be to add this new column, not to create duplicates of people each time they attend an activity. Thanksss!!!

Airtable has how to autocomplete fields in a form, that is to say that through a unique key it preloads data already existing in the database that are requested in the form.

I've created a customer appointment confirmation system for our solar installation business and am struggling with a specific issue.Current Setup:We have an Airtable base with appointment records for our customers We send automated emails with links to an Airtable form for appointment confirmationProblem:When customers submit the form, it creates a new record with their feedback instead of updating the original appointment record. This disconnects their response from their appointment data.What I've Tried:Passing the Record ID as a parameter in the form URL Using "prefill_RecordID" to attempt to link back to the original recordQuestion:How can I set up an automation that will:Capture the form submission Find the original appointment record using the Record ID passed in the form Update the original record with the confirmation status Optionall

Hi,I’m experimenting with the RLP with DNA 2023 Airtable template.  I’m trying to personalize the column headings and can’t figure out how to do what I want after reading the Airtable help.  Can someone please tell me the following?  It's really a general question about copying/pasting a column field from one tab to another.I made a new field called “My Tree” and inserted it on the DNA Match Details tab.  But, now how do I insert that same “My Tree” column on the Kit Access tab?Thanks! 

Hello everyone, I’m having some trouble with the field order. As much as I move the field order in my grid view, when I click on manage fields, they appear in another order… I wouldn’t mind but the problem is when I send automatic emails with list views of fields it does not display the fields in the order that I need to. Can anyone help me? Thanks in advance Patrick

Sorry…I am swapping over from Jotform. I need a form where customers lookup their details (record) by entering telephone number…if there is a match, on submit, the customers details are emailed to them.

I've submitted my information 4 times online and emailed support to have someone from Airtable call me to upgrade to enterprise. It's been over a week. Is this normal or is there a better way to get in touch with someone?

Just purchased upgrade to Enterprise. Sales rep sent me a "how to" on upgrading to Enterprise. The video shows the ability to upgrade to Enterprise when you click on the license level. When I click on the license level, it says contact sales. We've signed, claimed domain and ready to roll. Just need assistance with next steps.

I'm using Airtable to keep updated physical therapy notes for learners in a special needs school. All PT students and I fill out a form that feeds into a table to keep the daily notes. This is all fine until trying to fill out the information for group sessions but having it feed into each learners' individual notes.What I need to be able to do is select all the learners present in the group, fill in the general session notes (I.e. date, time, what activities the group did) and then have the form open a section for each of the learners to have an individual section to be able to write up their individual performance. This single form then needs to feed into individual records in the main database table. To try and make it clearer, if there are three learners in a gross motor group (child A, B and C) I need the main database to reflect the following:For child A - the date, time and general group info, Child A's individual performance in the g

I am looking for a Chrome extension that sort of acts as a reverse web clipper. The extension should take data from Airtable (or alternatively a csv-file) and put it in certain input fields of a handful of selected websites. I would like to be able to select the input fields via css tags. Does anybody know an extension that would be suitable for the job? Thanks in advance!

Hi,I have a database for planning a vegetable garden, within it there is a table for vegetables which contains a field called 'avoid', this links to records in the vegetables table that this plant shouldn't be planted near. I would like to do some sort of rollup / lookup to show a list of vegetables that need to avoid this plant.Beans need to 'avoid' onions.In the onions record I'd like to see field that says onions are 'avoided by' beans.This is similar to a two-way link where one person becomes their daughter's mother after making the link.Any ideas? Thanks.

I run an event. Participants can suggest multiple different types of program items to have (talk, workshop, etc.). Since Airtable doesn’t support form logic (grr) this requires multiple forms, as each item has different requirements (for a workshop I need to know room layout, for a performance I need to know A/V needs, etc.). I noticed that a single table can support multiple form views, so in theory I can gather all this data in one place, which is great. But to do that, I need some way to indicate which form the data came from so I know which item type it’s for. Airtable also doesn’t support hidden form fields (grr!). It will look bad to have a form that says “Workshop Proposal Form” and then have a question for “What kind of item is this?” with “workshop” as the only answer. So is there any way to create a form key of some kind? Or am I stuck making one table for each type of item, or doing some hacky workaround like creating fields called email-workshop

I have set up a view and I’d like to be updated whenever there is an update to that view in Airtable. That means, when someone does @me in a record, I’d like to be notified in slack. Unfortunately, the slack integration does not seem to trigger any notification when there is a comment added to a record. What gives?

I have created a marketplace using Softr and Airtable.I am trying to figure out two issues:1. I have lots of records and want to create a field for signup, with the URL pointing to the sign-up in in Softr. Is there a way to input the URL into one row of a record and then copy that into every sign-up record?2. Going forward whenever I create a record, I would like that the sign-up field will be automatically populated with the URL. How do I do that?Ideally, I would like to have the Signup in the Softr record (card) directly point to the appropriate URL but it seems it will allow me to map only through Airtable. 😞Thanks a lot in advance.

I have been playing around with @Justin_Barrett’s excellent script “Parent Child tree hierarchy” (Parent Child tree hierarchy). The output of this is a text field with any separator you like, for example: World > UK > London > Hammersmith > Elspeth Avenue > Joe’s Cafe World > France > Paris > La Defence > BNP Paribas World > USA > New York > Manhattan > Central Park Question - is there any way to extract the #3 item (or the #2 or #4 for that matter) from these text strings? In this case, to pick out “London”, “Paris” or “New York”. I assume this should involve counting 2 instances of the separator (“>”), and then selecting the text from there up to the next separator.

This may be an issue more with our organization's strict IT rules but here is the situation:We have a type 2 email account that hosts all of our events on its calendar.When we initially started with Airtable, we used the outlook integration and was able to access that type 2 by using one of our work emails that subscribes to that type 2 calendar as the sync configuration source.ex. connected accounts>raethgu's outlook>events calendarOne day the sync was broken and in an attempt to re-establish the integration, a coworker updated the sync configuration source through their outlook accountex. connected accounts>coworker's outlook>events calendarIt looked fine until we noticed all the tasks and subtasks and comments were gone. We believe using that different source erased all the existing records and replaced them with the same records (since it was the same calendar).Our goal is to make the

Hello,We have a table that syncs with our outlook calendar that we have been using for a few months now. Our organization adds events every week, for some reason when they were added to the outlook calendar today, Airtable made dupes of each one. I can confirm there are no duplicate events on the outlook calendar itself, but I do notice that Event 1 and Dupe 1 have different outlook IDs. Has anyone experienced this or have a solution to remove the dupes? Thanks.

How can you export all the PDFs/images/etc in attachment fields?