Other Questions

Hello I started exploring using Airtable native AI fields; I would like LLM to read and process an attachment documentin PDF but the relevant field {Attachment} seems not to be available in the prompt design. Is it possible in some ways or do I need to resort to using OpenAI APIs and scripting? Regards and Thanks !

I know airtable doesn't have the ability to do this, but I wonder if anyone here has a clever solution.For context, we're a non-profit vege farm. A few of the things we keep records on need many records created at the same time. For example, when I seed trays of 15 different crops in the nursery, or I sow a cover crop into a bed (sometimes 10+ species). Each crop in either of those instances has unique data stored against it - Date, quantity, etc.We need to be able to do this on mobile, as we're in the field, and unfortunately the table view of airtable isn't very easy to do this on mobile. And unfortunately having to submit a form 15 different times is confusing and time consuming. The ideal solution would be a form that could collect all data against each instance, but airtable doesn't allow that.Does anyone have any ideas to help with this workflow? I have seen on2air, but unfortunately as a non-profit, spending more and more $ on record collection is really real

Hello, I’m trying to put automatically as primary field the name of the forms where the data came from but I can’t find a way to allow that, even if with formula. Someone have an idea how to that? Here data from my table: Table name: Table1 Compose by these views: Grid view Order form Incident form Purchase form Ask money back form I want to display the name of each form on the “Grid view” as primary field. Is that possible to allow it without to ask the user to field this name on the form?

Hi! I'm looking for an alternate way to display records that are grouped by a "multiple select" field.  As an example, I have records of food items and am grouping by the Food Type field with tags Fruits, Veggies, Carbs, Berries, etc. Some records, such as Cherry will be tagged both "Fruits" and "Berries."  As it displays now, Cherry will be grouped in its own area of both Fruits and Berries rather than showing up in the individual Fruits group and the Berries group.  I realize that having Cherry show up in both groups would mean the single record is displayed twice, so perhaps there's an alternate way of grouping records where the group will show all records with a given tag? I'd love to come up with a solution for this, because it gets pretty cumbersome to sift through many annoying "groups" where multiple tags are used. I just want to see ALL the records with that tag, regardless of any other tags those records may have!

Hello, hope you are all doing well. Need some help giving points to each participant per race result, would like to create a field on the same table with a formula that does that automatically. The point system is basically the reverse order of the number of participants, ea: 1st place gets the total number of participants in points, the 2nd place gets one less, and so on, with last place getting 1 pointHere is the condition, only the "Pos" with numbers will get assign the points. Positions that have a DNF or DNS will get just 1 pointHere is the table: Any help will be grateful, my brain is toast for the night, trying all kinds of ways.This might be super simple for someone out there 😆Thank you!

I am considering linking back to a specific cell in Airtable. I can copy a link to the cell by right-clicking on it and selecting 'Copy cell URL.' However, this opens Airtable in a browser. I want it to open in Airtable's desktop app for Mac. Please suggest how to do this.

I have both the Teams Plan and the Business Plan. Very often I found that Teams Plan is sluggish and unresponsive at certain times of the day. But I don't get that in the Business Plan. Do you also experience the same? Granted, that the Business Plan is 2x the price...

I want to use a form to allow volunteers to register for upcoming events. Each volunteer can select multiple events. Volunteers may also return to fill out the form more than once, as many of them will return for future events. The volunteers will just be members of the general public, not Airtable users.Is it possible to set up my tables and form to ensure the following conditions are met?1. Each volunteer is listed in the Volunteers form once, with a unique email address and phone number for each volunteer.2. Volunteers select one or more upcoming events from a list of upcoming events.3. Volunteers who return to fill out the form more than once can select other events, but the name and contact information they enter is not duplicated in a new record. Only the new events they sign up for are added to the record that already exists for them.

Hi all! Looking to figure out a way to hide certain options in a Single-Select Field for a form. I run trainings throughout the globe and it’s all tracked via AirTable. The list of training dates is getting rather long, and I would like to shorten that list to available dates for users filling out the form. The only way I can figure to do this is move any trainings older than 30 days to another tab, but that is rather cumbersome to have data points in two locations. Any thoughts on how to best solve this problem?

Hi! How are you? I’m new, and I’m having trouble with the average. I want to calculate the average of ao column that will ever grow (each day I’ll add new numbers). But when I create a new column to calculate it, it just repeat the numbers, instead of calculating the average number. I need a field with the Average, to link this field to Dasheroo (and I’ll do that with other fields, to, like the highest rated item in the database). How can I do that? Thanks

Hello I need to build a form where users create a 'Deals' table record. The description of the form should contain  dates that come from a  record in another table: 'Cohort'. It seems that Fillout pre-fetch is exactly what I need, but it is only available for 79$/mo which seems too much for this form only (and mini-extensions likewise). Is there any another solution? Does scripting have anything to do with Forms? Many Thanks 

Hi I am building a freelancing platform matching freelancers with projects. In my 2 tabs “Freelancer” & “Project” I have some common criteria as lists : Country, Expertise, Language, ect… How can I do to have this common lists always up to date & use them to create algorithm / automations without creating a table for each criteria / lists ? Thanks !!! Anthony

Hi all, I have a csv file with a column that contains the name of the project associated with the client. So I have a csv file with 2 columns: customer email, project name. I have to import this file into the customer table on Airtable where the “merge field” is the email and the project name must be inserted in a multiselect field. The problem is that many customers already have projects in their multiselect field and doing this import is all overwritten and only the last imported project remains. So the question is how is it possible to import (add) new values in “multiselect field” without overwriting the already existing values? Thanks so much everyone for the help

Hello there is some way to totalize an entire column in another column or in a cell. Thank you very much

Trying to create a form I click “add a field to this table” I see under “Single line text” (type of field the words “A single line of text. You can optionally prefill each new cell with a default value.” see attached that’s what I want to do but can’t figure out how to actually do that? TIA for any ideas here…

Our team uses airtable to track orders and get through a large list of records each day. I have a view setup that removes a record when a box is checked (completed) so we only see what's left to work on. Our records are grouped by client and some clients have multiple records. Due to the filter, as you click the checkbox on 1 record it disappears from the list which only allows you to click one at a time. Any solution you could think of to select all the records in one grouping and bulk edit them to "checked"?

I have 1 large airtable with jobs that I sync to airtable bases of clients in the same workspace.Now they should not be able to edit these jobs, so that's perfect.However, within that tab I want them to be able to add other jobs they might have, only for their use. How can I do this? I cannot see any way of doing this, and I don't want it to be a two-way sync, as those jobs should only visible for them. Ideally in the same tab as the other non-editable jobs. Is there a workaround?In some other tab they can link jobs to applicants with a linked record. I want that to still be the same job tab, otherwise It would not work well (if I have them make jobs in a different job tab)...Any workaround or creative wizardry?

I’d like to show a single calculated column of data (field 2) in an embedded table without the primary field (field 1). I recognise that I can’t hide the primary field within Airtable - but in the iframe code? Is there any way via: html creating a linked table and embedding that some other solution? Help please!

Hey can someone tell me why I keep getting a error I tried so many different ways that I know but i seem to can't figure It out😩

Here is a link to a quick video...how do I import from a .csv file and route certain fields to certain tables, and maintain the links and relationships?It seems like I have to import to each table separately, and then somehow re-link after the imports?What is best practice for doing this?https://share.zight.com/kpuvqg4q

I’m currently creating an order form that will populate in the a table. I’ve noticed that if I make a typo in the field name on the form view, the typo will stay on the table view even when it is corrected on the form view. Is there a way to avoid fixing errors twice? This also happens if I enter a field on the table view and change the name on the form view. They end up not matching up. This may be user error but some guidance would be appreciated.

Hey, I’ve set-up a rather long form, and I’d like to divide it and give an explanation in that division. For instance, a section header: “Tell us about yourself” and then a short paragraph below: The next few questions ask about your name and your job. Fill them in for yourself and anyone in your group who is coming. The form gives space for four people and another spot to add even more if needed. Once you’ve given the names of all the people in your group, skip to “Your Preferences” below. Is there a way to do something like this?

Hello, i’d read all discussions here to resolve my issue and nothing work, how i can get it done with this discussion :slightly_smiling_face: for this i created two tables, one contain survey results and the second contain users entries, they add their profil and based on automation airable add via the linked field all similar profil, until this point all is good. For one of the survey questions, i asked people for main daily missions they do (multiple select field), when i check the lookup or rollup field that get missions data from all result i see many missions many times, i would like to have unique values but seems impossible, i tried all tips that i found here :confused: any advice please ?

Link to video talk thru:https://share.zight.com/2NuoL7deI am currently in the process of comparing some Upwork freelancers who are helping me with researching the Ownership of commercial properties in the US, and contact information for those owners. Before embarking on a larger (and more costly) project of 40,000 properties, I had several providers run a Trial with 100 Properties, all of which I know the owners and their contact information.I'm trying to figure out who to somewhat normalize the data and compare each provider's results with my data, so that I can pick the right partner.Not sure how to do it, but I'm looking to have an accuracy % for each Provider for each field and in total.My thinking is something along the lines of importing it all into a new base, somehow using the Property Address as the Grouping field, and showing my MASTER ANSWER key and all 8 data files from the service providers and using Conditional Formatting compared to the MASTER to color code for exact mat