Solved

Hello.  I'm new to Airtable, but have some experience in other db applications. I am creating an app to track trading.  I have a trade table where details about each trade are stored.  It also stores the result of the trade in a field called TradeResult.  I made a grid view where I summed TradeResult grouped on TradeDate so I know the total results for each day. What's the best way to display that in calendar view?  I'd like to be able to look at the calendar and see how each day went. And not to be greedy, but if I could display the weeks total result on Saturday, that would be perfect.Any help is appreciated.

Hi There! Fairly new to airtable - and loving it! Context: I’m in the process of developing an interface whereby users can view or create ‘parent’ records, whilst also being able to view and update linked child records. Currently you aren’t able to ‘create’ linked child records in an interface (unless you do them one by one), so I’m looking for a workaround to create those records via clicking a button in the interface to trigger running a script via automations. The script would work on basis of: For this record > create X no of linked records in ‘child table’ (X = numerical value in ‘no of child records’ field) Problem I know there are multiple script examples out there that deal with creation of multiple linked records (namely the script developed by @ Kuovonne in 2020)- but I’m struggling to adapt them to my use case as a lot are built in the scripting app, and throw up errors when using them in scripts within automation . Very much a scripting newbie so any help or pointers ver

I have this working formula to return 'Reaction Hours'...ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2) If the request and reaction times are equal, 0.00 will be returned (correctly).  But then I embed it in an IF statement (simply to prevent #ERROR outputs if 1 of the input fields hasn't been populated yet)... IF(AND({Reacted Date & Time},{Request Date & Time}), ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2),"") Now it works fine apart from the situation where a zero is returned, in which case the result is empty/blank.  Both date fields are present, so the first part of the IF statement is triggering, but for some reason the 0.00 value is replaced by empty/blank.  Any ideas why?  

As the topic suggests, i'd like to create a formular field using the API and assign a formular value. The purpose is to use RECORD_ID() as a primary key for my records. I have made a call using the API to attempt to do this but i'm getting a validation error.I will be grateful for any pointers, thanks.

Hello. I've just started using Airtable today. I've created a database of workshops for my job. I have add a calendar view, which shows the workshop title and facilitator. It all looks great! However, when I subscribe to this calendar through Outlook or Google Calendar, it only shows the workshop ID. How can I also display at least the title, too?Thank you!

Greetings. i am having difficulty narrowing down the conditions for an automation. I want to activate this condition in my automation only if the name of a specific linked record contains the word “Conversation”. I could not make it work using the the linked record name, so i tried creating a Lookup Field that would just reflect the value of the Record name that i wanted. But it still does not work. Is there a way to accomplish this? Thanks for any help you can give!

Hello. I am setting up automation and need to program "To" to grab the emails from a field in my airtable base.  For example, when I need to send a report to just the operations department, I want to assign that report to that email group.   I use Outlook Email for the automation.   Here are some screenshots.   I can't get the automation to recognize a field I enter with the email addresses.      I tried a field using the addresses as one line separated by a comma and then tried three fields with a different email address in each.  Neither worked. What am I doing wrong or is there a better way to handle this? The PDF is generated by PDF Generator API if that makes a difference.  Thanks. Wendy

Hi,I have an event list that contains a Start Day column including time (needed in some instances, but often left as 0:00). As I would like a simplified view in some interfaces, I created a formula column to display the date without the time using the formula:DATETIME_FORMAT({Start Day}, 'DD MMM YYYY')However, the formula returns the wrong day, in fact Day -1. I imagine this is due to the 0:00 time being read wrong? Any suggestions to circumvent? Adding a formula to just +1 the day would probably not work for the events in which time is indicated.Thanks! 

Hello, I have a table whose fields are mostly file attachments. when I 'send record' via email, the attachment resolution decreases and images are pixelated upon zooming. Also the file names are being changed from the original names.Are there workarounds?

I have a field that links to another table (Initiatives) in my Budget table. In my interface, I'm trying to filter certain components by which ones have a certain initiative in that field. But, when I go to add an initiative to the filter, nothing shows up, so I can't actually filter by it.Does anyone know why this might be happening? Trying to use anything other than "has any of" seems to make me have to type it (and still nothing shows up), and I'd rather it be more like a drop-down.Thanks! 

For the Free version I only have 1 base for my social media calendar. Can i have 4 collaborators that can edit and comment without upgrading. This is the only thing I’m using Airtable for.

Hello, for the past few days, we've been getting fails on automated tweets. This seems like an error on Airtable side, right? Is everybody experiencing this now? This shouldn't be about crossed limits, as the limit is based on the connected account right? So it has to be that AT still uses the API v1.1 as opposed the v2.0 version?Thanks!

Hello Airtable world, We’re trying to extract customer’s names from a lookup field of a synced table where the names sometimes include a second name after the comma. Our data usually looks like this: John Smith Jane Doe, Terry Doe James Bond We’d like to be able to have a column that displays the following: John Smith Jane Doe James Bond So far we’ve tried the functions below, both returning and error. IF({Customer's Name}, REGEX_EXTRACT({Customer's Name}, "[^,]*")) LEFT({Customer's Name}, FIND(",", {Customer's Name}) -1) The number of characters is unpredictable both, before and after the comma. I suspect the biggest issue is that our primary field from which we’re hoping to pull information is a lookup field and not just simple text. Is there a solution to achieving this?

In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modified in some way because of the lookup field issue, but I'm not sure how: 'templateRate': c.getCellValue('Rate')

Hi all,I've got a table of dates called "Possible event dates" that gets linked to other columns including "Dates table" as shown below.The problem is that the link seems to be setting the time back an hour, as though they were set to different time zones, but it's not clear from the field settings how this is happening.Any ideas? Thanks! 

Hi all, My scripting ability is pretty basic, so bear with me. I’m trying to automatically update linked records based whenever a record in a table is updated. Basically as follows. We have a table called “Jobs in Progress”, and each record in that table has separate records attached from time to time in another table called “Tasks”. It isn’t uncommon to have several records in “tasks” linked to one record in “jobs in progress”. Records in “Jobs in progress” have a checkbox called “completed” which is either manually or automatically selected depending on several conditions. Records in tasks also have a checkbox called “completed”, which are usually manually checked. What I would like to achieve is that if any record in “Jobs in progress” has the “completed” checkbox checked (true), that any linked records in the “Tasks” table with the “completed” checkbox unchecked, update so that they are checked, or true as well. The reason for this is that on some simple tasks we overtake the proce

I'm new to coding so I'm a bit out of my depth.I have a "Multiple Select" field and I'm trying to create a new field which counts how many selections were made for each record.The items are given a rating depending on how many selections they can tick.I have the below but I'm certain I'm making lots of very basic errors.Any suggestions would be greatly appreciated.{Sustainability Rating} = "n",(("n" = 0)IF({Sustainability Checklist}, "Is the item plastic free?", "n"+1),IF({Sustainability Checklist}, "Is the item made from recycled material?", "n"+1),IF({Sustainability Checklist}, "Is the item fully recyclable?", "n"+1))

I have a table called Job Codes/Job Titles. I listed the job codes (numbers) in the primary field and then the job titles in the secondary field. In another table I added the Job Codes/Job Titles as a linked field. I want the ability to look up a Job Code (in this linked field) by its Job Title in case I can't remember the Job Code.  Right now I have to start typing in the Job Code number (but we have hundreds of Job Codes). Is there a way to do this other than making the Job Title the primary field?For instance, I may have a job code 0004 with a job title Academic Intern. In the linked field Job Codes/Job Titles I want to be able to start typing in Academic Intern and have it bring up both the job code (primary) and title (secondary).Thanks for your thoughts.

Using the Auto-number type field can be great, but it is also very limiting when you need to start with a certain number in particular. And if you create a record and then delete it, the next record you create will not have that deleted record's number, but the next one in sequence. For this Project Tracker, the client started using Airtable for job # 2000 (and they have a hundred more after that), which means they created 1000 EMPTY records just so that they could get to the real data at # 2000+. It's also no good to go out of order, so if anyone accidentally creates and then deletes a job, their list of jobs is not sequential. Yes, we can limit record creation with permissions, but I want to know if there is another way I can automatically create the next job record and set its number by finding the highest number used and adding 1 to it. And if a record gets deleted, I want to be able to start where we left off! For example, I am working in a test version of the base to play ar

Hey guys,I've got a base that tracks books in a small library.  I need to create a field that extracts the last 3 digits of the author's last name and it has become very complicated, haha.Example author names:John BunyanC.S. LewisAlister E. McGrathC. Everett KoopDr. William Lindner Jr.Authors very often have prefixes like Dr. or Rev. and they like including initials and suffixes, too - lol!So how do I build a formula that will pull the last 3 letters of the last name like this:John Bunyan = BUNC.S. Lewis = LEWAlister E. McGrath = MCGC. Everett Koop = KOODr. William Lindner Jr. = LINThis gets me very close:   UPPER(LEFT(REPLACE({Author(s)},1,FIND("~",SUBSTITUTE({Author(s)}," ","~",LEN({Author(s)}) - LEN(SUBSTITUTE({Author(s)}," ","")))),""), 3))  ...but it breaks with suffixes 😞Can anyone help me tweak it to work with suffixes???Thanks so much for any help!

Hello!I automatically retrieve a list of sales directly in Airtable via Zapier, problematic, the price is sent "raw" from zapier with a lot of "0", like that : 16000 for 160So I created a formula to remove them :LEFT(raw_price, LEN(raw_price) - 2) And it works 🙂Now, I am looking to create a new formula, in a new field to get the currency and be able to add the sales.Any idea ? 🙂

I was creating a new base and went to add in a synced table from our main data set and got the above error. Has anyone seen this before and know how to fix it? We are on the Enterprise plan and as far as we are aware there are no limits on synced views

Hi,I am attempting to build an automation that will help assign a student to the specified time slot.I have 2 tables, 1 of which is for trial arrangement, and another for enrolled students.Both these tables have the following fields:Day, Timeslot, Coach, Location.I have another table for the available slots.There are 6 records with the exact same Day, Timeslot, Coach, Location. (each timeslot can have up to 6 students (regardless of trial or enrolled))When a child is about to enroll for example, a button will be pressed, triggering a webhook to integromat/make.com, which will get information of the record.How can I make integromat/make.com find this slot if it is available, to assign the student to?I've tried doing a search, but it seems my formula might be incorrect, as it returns with a 0 bundle 

Hi all,I'm writing after thoroughly searching the forum and endless tries, so I really hope someone can help here...My scripting abilities are very basic but i can read and understand it, and can even write it with the help of GPT &#x1f605As part of a multistep automation, I'm running a script that takes apart a poorly formatted text field from my "form" table (using input.config) and creates multiple new records in my "contacts" table. The script works well and the new contacts are being created with all of the relevant text fields in the new table.My issues began when I tried populating other types of fields.. After lots of searching I fingered out that to update a single select filed it needs to be an object, and i finally managed to do that.Like this:    record['Marital Status'] = { name: 'Single' };   I'm now trying to link another table to these new created contacts. This is the "Families" table and it is already referenced previously in my aut

I want to write a formula to automatically note "Active" in a column when the position start date is before today and the position end date is greater than today OR when the position start date is before today and the position end date is blank. Here is how I'm trying to write it. The first part of the formula worked- it populates the cells in the column with the word "Active" for those whose position start date is prior to today, and whose end date is greater than today. When I try to add in the OR part- where position start date is less than today, and position end date is blank, I get an error. This works: IF(AND({Position start date} <= TODAY() , {Position End Date} >= TODAY()) , "active" ) But this does not:IF(AND({Position start date} <= TODAY() , {Position End Date} >= TODAY()) OR(AND({Position start date} <= TO