Other Questions

I took a little break from the business. Now that we are starting back up, all the bases and information linked to my account are gone. How do I regain them?

Im looking to create an extension that shows dropdowns for various fields in my base, but I don’t know how to make the dropdowns appear within the extension. I’ve tried returning the select field as well as using it with a FormField but neither approach works. I’m unsure as to how to make the dropdowns appear in the extension

Is it possible to add day before date?

Hello, In my base I have 2 tables: Users and Emails. They are linked together because one user can have multiple emails. Users Id|First name|Last name 1|John|Doe 2|Sam|Harison Emails Id|Address|User id 1|john.doe@gmail.com|1 2|sam.harison@gmail.com|2 3|sam.harison@yahoo.com|2 I want to create a form in which user has to provide first name, last name and one or more emails. How can I achieve this in Airtable? Of course after submission data should be stored in tables with correct relationships.

A general question to the Airtable community, what is expected when email notification are switched on and a mention is done in the comment section on a record. So far I have been unable to make this work between collaborators - and not sure what I am doing wrong. I don’t see anyone else with this issue so believe it must be me. Is the email instantaneous - or with delay? Many thanks.

Good Morning! I have a project field that is synced externally and uses a formula. I wanted to use that same project field (with the formula), to link to a tasks field. For some reason, I cannot link the Project Field to my Tasks field. The Projects field does have automation as well. Any tips?

Hello everyone. I have a base with several tables and collaborators. I need to restrict viewing a complete table or several columns within a table from some collaborators, but at the same time that table or columns should be visible to other collaborators. Can anyone help me to find a solution? Thanks in advance.

Hi Everyone, I have a start date field and a duration type field and I’m trying to create an end date with a formula DATEADD({ :gear: Appointment Start Date},{Duration},‘minutes’) This doesn’t seem to do anything i.e. the end date is the same as the start. Any ideas? Cheers

This may have been covered, but I cannot find it. I have a field that has several emails in it. It is a lookup field I need to extract the first email in the list. Can someone help me with the formula?

Wondering if/how to make this possible… I want to have have a single table embedded into a website/app that displays records. Want to filter what records can be seen based on the logged in user of said app. Thanks in advance.

Hello, I have an “id” column in my table. How can I generate sequential “id” after submitting the form? |id|First name|Last name| |1|John|Doe| |2|Mary|Jane| |3|Raplh|Smith| I.e. after creating a new record “Tony Jones”, id=4 should be added automatically.

Hello, I need to migrate all the data (+ automations and formulas!) to another Airtable. Is there any way to do this? I found Free Airtable to PostgreSQL migration tool but it offers only migration of the data, not the formulas and automations.

Hello, I have a table to input hours for tasks. These task are linked to a country and a profile. Simple, in generic. People input 40 hours a week, to profile 1 and country 2. But I have a problem with a department. This department, already has more granularity in tasks, and they input 40 horas for a specific task wich is alreadly linked to profile and country. I can add to the table two columns with profile and country lookup , when they input this task, but i need to copy automatically this field to the original linked field country and profile in another columns. I read a lot in the forum, but any solution is accomodating to my problem. Maybe some script? many thanks for your support

HI Everyone, I have a couple of bases that are synced, I want to move them to a new account.; This obviously breaks the sync between them. What is the best way to sync them back together after the move? It seems its not possible to reconfigure the table to sync with the new base. Is there a better way than creating new tables and then having to modify of the links and lookups?

Continuing the discussion from Seeking a Volunteer Airtable programmer: Please take a look at this old post and reach out if you can help!

I have a table that is populated by a form where volunteers sign up for a specific event. Those events are shown in a field that is linked to another table that contains the events. My problem is that, in the shared form, the only field that appears in the grid is the 1st column, which does not contain enough information. I want to see more fields in that grid. What am I missing? Second image shows what I see (not enough information), 1st image shows what I want to see in the shared form. Thanks in advance.

Hello, I have created a form to schedule meetings with our company. However, I have noticed that when someone from another time zone picks a time for a meeting using the “Date/time” field, Airtable schedules this meeting in this person’s time zone. For example, if someone in London picks the time 10:00 am, the meeting will be at 10:00 am their time (3:00 am CST). Is there a way to have this “Date/time” field to only stick with Central time no matter where the person is located? For this particular case, the meeting will be 10:00 am CST, not 10:00 am London.

I have a table that looks like this… CompanyName, CompanyID, AttributeA, AttributeB, Phase1Start, Phase1End, Phase2Start, Phase2End In other words, 1 row per company, with lots of start/end date columns for multiple phases of a large project. I now want to plot those phases with some kind of timeline view but am struggling to achieve this with Timeline or Gantt. Calendar view at least allows me to specify multiple input dates per row, but the view isn’t really appropriate for managing a project. I can see one potential solution which is to create multiple rows in my data per company and then group the various rows by company in my timeline. But I really want to avoid doing this and dramatically messing up the structure of my initial base. Has anyone else successfully plotted multiple phases of a project for a given row with a timeline view? Or even any other view that works well on project management? Thanks for any thought!

I have a button field that runs a script, that calls an external API, and then updates a field in the record. Is there anyway to stop the extension dashboard containing the script from opening (even partially) when the script is run? I really don’t need my users wondering what’s going on (or poking around for that matter). :slightly_smiling_face: Thanks!

Hey Everyone, So I and a colleague have “Creator” Permission on a base. We are trying to use the Dedupe extension and we are not able to use it, because it is said we do not have permission to make the changes. Please advise.

Hello Is there a way to replace all spaces with “-” in a cell? I synced a cell with my website and what ever I put in to the cell in airtable becomes the webpage slug. So I can’t put a space in a slug. Any solutions for this?

Hello! I am wondering if anybody can help me troubleshoot why a script stops working when there are records in my base? The script in question is the “Creating Projects/Tasks From Templates” script (which I found here). I am also including share links to 2 test bases for reference on my problem (those are located here and here). The Sandbox for Question (1) table is copied from my company’s Workspace, and includes confidential information that I’ve renamed to “Redact” - very sorry if this makes addressing this issue more complicated or confusing! I use this script to batch create tasks (in the Tasks table) from a template (defined in the Asset Templates table and Task Templates table) that are parented to a specific asset. I recently started to encounter this error when trying to run the script: > TypeError: Cannot read properties of null (reading '0') at main on line 87 For context, this is line 87 in the script: let p_id = r.getCellValue(project_template_link_field_name)[0].id

I am trying to figure out how to get my script to run under the 30 second limit. The Find Records automation doesn’t handle a list and I am trying to loop through a short list of Google Event attendees to see if they exist in a Contacts table. If they exist, I want to add the Contact name to an array. If they don’t, I want to create a new record and then add them to the array by Name. Then I want to create a Meeting record that adds the Attendees by name to the Meeting record. let attendees = input.config(); let customers = new Array(); let contacts = base.getTable("Contacts"); let contactRecords = await contacts.selectRecordsAsync({fields: ['Email']}); for (let i = 0; i < attendees.attendees.length; i++){ var attendee = attendees.attendees[i] if (attendee.includes("@tray.io") === false){ for (let record of contactRecords.records){ if (attendee === record.getCellValue("Email")){ customers.push(record) }

Hello all, I am trying to put together a customer base that pulls in information from multiple bases. I have several archived sales data bases, so a base for 2020 sales data, 2021 sales data, etc. Let’s say I have a customer “John Doe” that has multiple orders in each base. I’ve got a CUSTOMERS table in each base that summarizes number of orders, total revenue, etc. Can I create a “Master” customer base so that when I sync from multiple sources it tries to find an existing record with that primary key before creating a new record? When I try it is creating a new record for “John Doe” for each source instead of placing each sources information into the existing record. So if I’m sycing three years of customer information, I have three John Doe records instead of all of that info in one record.

Hi everyone! We’re excited to announce a new beta feature that allows you to specify a display time zone of your choice on date fields that include time and formula fields that output a datetime value. Once you specify a time zone for a field, this time zone will be visible and used for all collaborators. We’ve heard your feedback that time and time zones can be tricky to manage, and we hope that being able to choose from a broader list of global time zones can make collaborating across time zones much easier and clearer for you and your teams. You’ll only be able to use these field-level time zone settings in your base if you’ve signed up for the beta and you can sign up for the beta via this form. As you’re trying out the feature, please submit any feedback/issues here. Read on for more information! For datetime fields, you can access this feature by going to the field configuration menu and toggling on both “Include time” and “Use the same time zone for all collaborators”. Setting