Other Questions

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

I have a table Treatments and a table Users. Then I have a table Users_Treatments where each record is a combination of one User and one Treatment, and in addition there is a Review field (basically users review treatments they have tried). I have already pre-populated the Users_Treatments table with users and treatments but I miss the reviews. I would like to create a Form, so that each user can add a review for each one of the treatments they have tried. Is this possible? I only managed to create a Form that however shows only one treatment per user.

Hi everybody, I am attempting to use forms to update fields in my table. I need to be able to pre-populate the other fields in the form with the current information that is in the table, is this possible?For example: I have a table of "Items", and each row has the item name and columns of information about the item- owner, amount, etc. In the form, the first question is "what item would you like to update?" with a linked record to the first column with all the items. When an item is chosen, I'd like the other fields to auto-populate with the current information in the table with that item, so they can see what they're updating. If they choose "Scraper", for example, I want the next field of "How many" to auto-populate with the amount that is in the table, and then of course I want them to be able to edit it if necessary. Is this possible, maybe with Zapier? Thank you.

Hi all--Thanks in advance for your thoughts. I have a items shown in the attached that are different content that have different topics associated with them (you can see the column of topics). I'd like to get a view in Airtable where I see all of these segment names associated with the individual topics in lists in 1 view.  The way I've thought about doing it is to try grouping them, but when I group them, they sort with the 4 topics together, not as individual topic lists. Grateful for any advice on how to do this!

Hello, I am trying to understand more about the paid plans, and who exactly on the team needs to pay for plans to access bases that use paid features. We use airtable for our general employee handbook. Although everyone needs to access it, only the admin team needs to have editing/creator rights. From my understanding, someone with a paid plan account needs to create a workspace that houses the handbook base. Then they would share it with the rest of the team, and note in airtable who needs read-only permissions (in which those users won't need paid plans to access the base), and those who should have editing rights (in which we would then need to pay for their plan). Is this correct?We want the handbook base to have the paid features of higher record limit and sync intergrations which would be useful, but we don't want to end up paying $20 a month per seat for everyone just for those two features as the cost isn't justifiable for

Hello,I work for a growing nonprofit that needs *help* in the area of Email Marketing.  We use Airtable to manage our various lists of people and their contact information, but I need a good Email Marketing App that will integrate well with Airtable. We're using MailChimp right now, but it's a mess because it's not integrated with our Airtable contact lists. Can anyone recommend a setup for using Airtable as the CRM, integrated with another Email Marketing App that can:Automatically sync contact lists "two ways" with Airtable.Meaning, if someone updates the Airtable list then the Email App's List will be updated, or if someone Subscribes using an Email App SignUp Form then Airtable's Lists will be updated. (FYI, MailChimp doesn't do this natively, neither does Outfunnel which integrates Airtable and MailChimp.)Manage the Contact Lists, tags, groups, etc. in Airtable, andDesign & send

Hey! We build our company automation and centralized system with Airtable's API & Automation systems.We use 1 Workspace with many many different Bases. Could the Dashboard (in the main view) have folders inside the Workspace that can be used to divide the different bases, which would make it easier to organize and find the right Base. The view looks really messed up right now. 

I live in Lagos, Nigeria, one of the biggest commercial hubs in Africa and I think it's a shame that Airtable is hardly known here. People are still using decade old desktop versions of popular office software that they learned to use when they were in university. I would like to officially partner with Airtable to showcase the product to businesses in Nigeria and Africa as a whole. I sent an email through the Airtable contact form about this but I received a generic response that sounded as if the person didn't even understand my request. I'm hoping that an Airtable community manager or sales representative will respond to this post.

Hi - the iframe code that is generated when you want to share a view makes it look like the background can be changed, but it is always grey regardless of what I do with the iframe code. Has anyone been able to change the background color? Thanks. <iframe class="airtable-embed" src="https://airtable.com/embed/shdfgsfgs0I?**backgroundColor=blue**" frameborder="0" onmousewheel="" width="100%" height="533" style="border: 1px solid #ccc;"></iframe>