Other Questions

Unsure of the best approach so I would love some suggestions on this;Background & current process;We book training sessions for clients. We currently create one Airtable record for each session to set different dates for them. Each session (record) immediately receives a confirmation email (triggered through Zapier) once we change the status to 'Confirmed'. Sessions are linked to a Company.One issue with this is that clients often book multiple sessions at once, so upon confirming them in Airtable they will receive multiple confirmation emails that are almost identical (only the date/time changes). This spam-like approach isn't the customer experience we want to deliver.Desired outcome;For clients that book multiple sessions at once, I'd like to be able to send a single email that shows all the sessions as dot points so it's easy to understand and doesn't seem like spam.I'm not sure of the best way to set this up with Airtable. We still want to keep the sessions as individual recor

we currently use Google in order to sign on to our airtable. the company is migrating to Office 365 mail boxes. once we have finished migration to office 365, we cannot keep using the google sign in option…but, we can login regularly. question is, do we keep all the data of airtable in the new account? or is it all gone ? :frowning:

Hey guys,I am trying to pull reports of hours worked on a project to total up all hours worked that month across all projects, the individual project monthly hours, and calculate the percentage each project used from the total monthly hours. Let me break down my set up.Table: Project Tracker - contains all over all project information. Linked to Hours TrackerTable: Hours Tracker - where coordinators input the daily hourly information by the project they are working on. Projects can be worked on from anywhere from .5hrs to 8hrs and people can work on multiple projects a day. There can be multiple records per project per day for different amounts. I currently have the current project monthly hours by having a date format field to pull that date's month, have a view where it's grouped by month and then project to get the summary for the month and by project. So I have those number if only in a summary field.I am trying to pull percentages (total monthly hours/total project hours) in

Hi,I've tried using automations to "find records" but it doesn't seem to be working for me. I have a platform where we assign people from our "Staff Directory" to different stations of an event. I want to have a linked field that adds anyone assigned to a station to a general "Staff Assigned" field that I can pull e-mails from (already have that part setup). How can I have "Staff Assigned" update as each field is updated? Is there another or better way to do this?  

I have a formula that pulls text from another field. That field is a link to another table. Airtable is creating quotation marks around the text if the text contains any punctuation marks. Is there a way of stopping this??

Hi all - I have a table in grid view that I’m trying to group and then sort alphabetically. The table is: Grouped by StateOrProvince from First-Last Sorted by StateOrProvince from first-last No matter how I group, sort, etc. I can not get the table to group/sort alphabetically by State. Any insight you can offer is so appreciated. Thanks!

Does anyone know what the character limit is for the length of URLs of photo images exported in CSV files? Is there a way to limit the URL size/length?   

first off: recurring issue: where can i report bugs?the record history seems to give wrong information when the change in the record was an addition of a linked record. the record history should say "[USER] created this ['record' or custom name for record as per table settings]" but it does not respect the table settings of the related table and does not use the custom name of the record of the linked table.i.e. i have two linked tables, one called "products" and one "sales". the tables are set up so that records in the "products" table are called 'product' and in the sales table are called 'sale' (for example in the footer of the table when summing up etc).when i create a record in the sales table say 'sale #5239234' related to say the record 'GREEN APPLE' on the product table, the record history of that 'GREEN APPLE' records should say "[User] created this sale" and display the change in the link-field. instead it says "[User] created this product", but i created a sale related to a

Hi all, I’m currently trying to set-up a pie chart via Airtable’s ‘Blocks’ function. Is there any way to choose my own colour for each of the segments? The default colour scheme that my pie chart is using is completely contradictory from the labels of each of my segments - and I can’t find a way to change it. Any ideas? Thanks in advance. Cheers, Mark

I am in Real Estate and have created at table for all my transactions.  Some date fields are calculated based on a formula.  For example, a Loan Application is due x# of days after contract date - it can vary based on the contract.  I am creating a template that lists tasks based off that calculated date.  I create the template and choose a relative date but the calculated date is not listed, only dates that are manually entered (vs. calculated) are showing.  Does anyone have any suggestions on how to accomplish this?  

Hello! I'm trying to create an email automation to go out to my team on a weekly basis that would display our top three social media posts by engagements within a certain timeframe. I've figured out how to set up the email and created a view filtering for that timeframe and sorting by engagements. I've seen there's not really a way to limit a view to a certain number of records automatically, but I wondered if anyone had any workarounds or ideas for setting up this email to go out without the entire list having to go out each time and without me having to go in and manually change something in order for the email to go out? Tall order, but appreciate any help.

Hi, I'm currently on a free plan with five editors. We are considering upgrading to the Premium Team plan. But wnat to clarify if $20 a month means we can retain our five editors from the freemium plan. 

Hey guys,I am trying to find a way to relink Personnel records on a base with synced tabled from 2 different bases in order to limit interface views off Airtable accountsBase Personnel - All Personnel info including airtable account using the User Field typeBase Project Tracker - Overall project information including Personnel like producers linked to record on a synced table from the Personnel base. Airtable accounts are a lookup field.Base Asset Tracker - Synced to Project Tracker to assign assets, pulls over information like producers. Also synced to Personnel base to assign assets to people. The synced Project table on the asset tracker currently pulls over the producer information but obviously as a single test field with the producers in a string out. Obviously I can't change the field type to relink to the Personnel synced table on the asset tracker. I've tired an automation that finds records with the matching name but that does not seem to to work since there can be

Hi !I have the team plan, previously plus, with the bonus payment of 10usd per collaborator per month.If I add a new collaborator, will I still maintain that price? Or will I start paying 20usd per collaborator per month?Thank you.

Hello all My script below, looks through records in a table to find any records that have a field value that matches the record that kicked-off the script (automation) when a button was clicked. The field used for the condition is a Single Line Text field (Tracker Cycle ID). The actual value being compared is passed into the script via input.config (matchCycleID).  I do not get an error but the script does not work as intended and the script editor tells me "This condition will always return 'false' since the types 'string' and '{ readonly matchCycleID: string; }' have no overlap.(2367)".  I would assume the value of the field being passed into the script via input.config is a different type of 'string' than the value in the record being compared (record.getCellValueAsString('Tracker Cycle ID')).  As a test, if i rewrite the comparison (line 6 below) as: if (record.getCellValueAsString('Tracker Cycle ID') === "Tracke

Hi to all 🙂We have a couple of bases shared within our team members. I would like to see if anybody is 'inside', and to see what is he doing in any of bases. Is it possible to set somehow?I know about the options 'last time modified' and 'the person who last modified', but I would need some more accurate and in the real time.Thank you all, wish everybody Happy Holidays 🙂

Hello AllI send automated SMS to a list of contacts that is present into another table with the lookup function.My problem is the phone numbers are displayed with a coma as a separator (see picture below) and my sms provider does not recognise it. I would need to have  semicolons instead of commas Can you please help me with the syntax in case I would have some formula / rollup ?thank you 

Hello,I, like many here in the AirTable forums, have dealt with seemingly "random" file deletions. One of the issues with this bug is that it is often sporadic. However, I have recently refactored one of my cloud processes that processes data from a record, generates a data file (application/json type) and puts it back into the record. I have a consistent set of records that I can run this process on, and I can literally watch my process write in all of the files, and then anywhere from 1-20 seconds later I see the files deleted  realtime! I know that my code is doing nothing to actually delete the files, and you can even tell from the record history that something is awry because the original file write is by our "Software" user and it specifies the Users token, and then the deletion is also done by the "Software" user but no token is specified (see attached screenshot). I feel confident that I have no old API key based processes that would be doing this action. (As an aside

Hello community!I have a problem, which I've been unable to resolve myself.I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).Now, in the first table (table 1) with different entrees all entrees have a name connected to it.But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.Hope my explanation is clear.Does anyone know how to do this?

I have attached below all the images.In number, it gives me 100.In percentage, it gives me 10000%but I want only 100%   

The Team plan is $20 per seat/month billed annually. Does the "per seat" mean users? So if we have 10 editors, it'll be $200 per month? But the plan also says it includes unlimited editors. It's very confusing...

I often copy data from several fields at once, so I need to use a horizontal scroll to select all the data, which is not really user-friendly. That’s why I thought maybe it’s possible to create a button field that copies data from some fields of the same row and sends it to the clipboard. I did some research and figured out it can’t be made with built-in Airtable features. I guess custom scripting may help, but I’m not familiar with JS, so I have no idea where to start or if it’ll even work:sweat_smile: Any help would be greatly appreciated!

Hi Community, I am attempting to develop a QC DB for my international QC inspectors, in my dept we manage over 18,000 unique item id’s manufactured by over 400 factories, in 20 different countries . I keep a list of Item IDs and Factory IDs on a source of truth database which I have synced to my prototype inspection DB. For Simplicity Sake, these two tables, within source of truth DB, are as follow, Item IDs Table Primary Field( ITEM IDS) Secondary Field(Factory IDs-linked to Factory IDs table) Factory IDs Table Primary Field(Factory IDs) Secondary Field(Item IDs-linked to item IDs table) Within my inspection database, I’ve created 2 linked fields within the inspection table. Filed One(Factory ID-linked to factory IDs) Field two(Item IDs-Linked to item IDs) I would like the QC inspector to enter a factory ID in field one… after which I would like the QC inspector to select an item ID in field two… And alas we reach the issue, how the heck to I configure field 2(item IDs) to only popul

Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't understand which step I had made wrong. 

Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com http://domain.com Column 2 Result in all rows of above domain.com