Other Questions

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

We have an Enterprise level account and are trying to implement a date field which will track the date that a status is changed in another field. This is all good on a move-forward basis, but we would also like to update it historically, which is proving to be trickier. With our enterprise account, we have 3 years of revision history, but it seems like the only way to access what we need is to open up every single record, scroll through until we find the action we’re wanting to track, and then approximate based off of Airtable’s generic date timeframes when that action was performed. Once we’re out of the 1 month timeframe, this goes to month by month and then year by year approximations, when what we’re really looking for is exact dates. Is there a better way to do this? I don’t see an access point in the scripting API to see record history. Our Enterprise audit logs only go back 6 months, and don’t offer this level of granularity. We know the data is there but are at a loss as to how

Right now I have some interfaces on a base. 1st on is a form that will only be available to certain users (senders). Depending of 1 of the decisions that this sender made, the answers of this form should be only available to a specific user (accepters) to deny or approve it. 2nd one is a interface that will only be available to a certain accepter depending on a dropdown answer that the sender filled. My question is if there is a way to give permission to certain airtable users to use an interface. I’ve been trying to find a way of doing this but can’t find any way. Another solution I explored is to create different bases and give the correct collaborator permission to the people whose work correspond to the one assigned to the base. But I would need to send data from a base to another. I don’t know if this is possible but I can’t find any solution to this either.

I was tring to modify a formula DATEADD({Start Date},13,‘days’) to find the end of the month but since months have differing amounts of days I wasn’t sure how I could do that. Bascially, I want the formula look at the start date and then output the last date in that month. So a start of 9/1/22 would equal 9/31/22, etc. Thanks in advance!

I have two different tables with information that needs to be synced to an existing Google Docs file. Anyone knows how to make it? Thanks in advance!

Hello! Recently one of our bases started sending out emails to everyone when I change something (add a new view, change a automation etc). I would like to stop this because most of the people inside of the base don’t understand most of airtables more “advanced” systems, which causes them to get confused about it. How might I disable this?

Hi all, I have inventory for our plant shop already in Airtable. From a Gallery view of this inventory, I would like to use the url of each individual card to generate a QR code for our pricing labels that customers can scan and get just that specific card view without having to sign up or log into Airtable. I don’t want them to be able to edit anything, just view the specific card. (These cards have plant care instructions for each plant.) Is this possible?