Other Questions

I want to add contributors to a base, they won’t be allowed to edit the basis, they will be able, only, to add and modify records, but not to change the base structure, formulas, etc. Is that possible? How I will be charged for therm? thank you for your help.

Hi All, I have a scenario where I need to have a formula that looks at all of the dates and picks up the earliest/first one as the "Initial Enquiry’. However not all of the fields are filled in there are fields that are empty as not everyone was enquiring for the particular developments. I have this formula: MIN( VALUE(DATETIME_FORMAT({Date Field #1},‘YYYYMMDD’)), VALUE(DATETIME_FORMAT({Date Field #2},‘YYYYMMDD’)), VALUE(DATETIME_FORMAT({Date Field #3},‘YYYYMMDD’)), VALUE(DATETIME_FORMAT({Date Field #4},‘YYYYMMDD’)), VALUE(DATETIME_FORMAT({Date Field #5},‘YYYYMMDD’)), VALUE(DATETIME_FORMAT({Date Field #6},‘YYYYMMDD’)) ) However, it doesn’t seem to capture the empty fields hence it is giving ‘error’ as the result. So what is required is for a formula

i’m using the CSV import app to create a list of unique people who have attended all our events. i match the people using their email address and create new people if they don’t exist. one of the fields is a related record field that relates to a tab with a list of all the events. that field allows for linking to multiple records. however, when i import the list of attendees from Event 2, it overwrites all the data in the Events Attended field, so that Event 1 disappears. my preferred outcome is that Event 1 and Event 2 appear in the Events Attended field. how do i solve? thanks!!

Hai everyone how to sync multi table to 1 table? because I have 8 table in 1 base and then want to create 1 table summary using value from those 8 tables.

I am getting a “Service Unavailable” error when I attempt to load the CSV Import App. Is anyone else experiencing this?

Hi there! I am building a RASA chat bot in which one of the custom actions is writing user input to a airtable via REST api. Everything works fine locally but when i host the bot on okteto cloud using docker, i am getting connection refused error. Is there any changes i need to make to my dockerfile or docker-compose for this to work?

I know this has been discussed a few times but I want, not a how to but opinions, on what the best backup solutions for Airtable are. Here is my situation. I have two Airtable accounts, one for personal and one for business. I have two Google Drive accounts, one for personal and one for business. The personal accounts are free, the business accounts are paid for. So, to save cost and ease of use (since you can’t log into two accounts at once from either Airtable or Google, I share my personal accounts with my Work account, and always log into my work account. Here’s what I want. I want a way to Back Up my work AirTable account. I tried the Sync to Google Drive function, but since my personal bases are included with my work bases, ALL of the bases come into my Google Drive. Here are my questions. 1: When syncing with Google Drive, it makes an Airtable folder. If I rename this folder, will the sync still work? 2: If In, in Google D

First time posting. We currently have a membership Access DB that we wish to have online. We have about 500 current members with about 30 columns of datafields in addition to the basic name surname address es etc etc. Which is best ?: To try and import all the existing data and try to recreate on AirTable or to start fresh and create the new DB adding whatever columns/fields we want and then selectively import into the columns from a .csv file? We would wnat to have varius reports or views such as expired memebrships, current or active, deceased, free statuts. paid up . overdue etc etc.

Just wondering if someone could please link me to or provide me the configuration that needs to be adjusted in order to affect the fields displayed on the card that pops up when you click on a linked record? The view-by-view reordering of fields doesn’t seem to affect this card. There is an interface for configuring the Kanban view, but not sure where to find the same functionality for the more general card that pops up, in any kind of view, when clicking on a linked record. Thanks.

Hey everyone, I have been tasked with taking an existing base, and transforming it into a linked, automated, wonderful work space and looking for help on where to start. The base has multiple tables, none of which are linked but this is something I need to put in place. I also need to create a task management table, or dashboard where multiple users can assign tasks and be up to date on projects. I’m a total novice with airtable and I’m stuck on where to start…any suggestions please? Thank you!

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

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?

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 a

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,

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?

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?

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!

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?

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!

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

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

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.

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?

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

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.