Other Questions

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

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 our case. Additionally, if we have

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 no-code marketing emails using the Mail App, pulling from my Airtable lists.I was looking

I’m looking for help with integrations: My nonprofit uses Airtable heavily to track lists of people and their contact information. We also use MailChimp to send out updates to our partners, newsletter subscribers, etc. using that contact information. My question is this: Is there a simple way to establish a “Two-Way Sync” between Airtable and MailChimp so that they will always contain the same data, regardless of changes made on either side? I need a true “sync” that will: Update MailChimp with any changes entered in Airtable (add, remove, edit), and Update Airtable with any changes entered in MailChimp (subscribe, remove, edit). I’d rather pay a small fee per month for an established app to do this than build it in Zapier/Make, but either way is fine if it works. TIA, M p.s. If you know of a fix for this with an email marketing program other than MailChimp, please let me know. p.p.s. As of today’s writing, Outfunnel can do most but not all of this (like adding un/subscribes to Airta

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>

Hello. I want to create an app/system for managing Shopify store from Airtable. Is there anybody interested in a solution that here? What features would you like to have? (ex. order management, product/inventory management etc.) Would be happy to hear some feedback. Thank you!

We have been using the free version of Airtable for awhile and wanted to upgrade our account to paid to allow for more boards. The creator of the account is no longer with our organization and we don't have access to that email address. So when we "request an upgrade" it goes nowhere and we are stuck.I have emailed support numerous times, emailed Sales numerous times and I am not getting any response. If Airtable only responds to accounts that pay - how can customers who don't pay right now upgrade? We are in an endless loop of having no answers.