Solved

Hi, I'm a complete beginner to airtable so sorry if this is a dumb question, but here goes anyway.. I created a product table which is a collection of parts grouped by name. I want to then use the name of each product as a single select field in a new table, but instead I get all the entries for every part within that product.Ultimately I want to display price information for each product - sum of all the parts cost, wholesale price etc. 

Hi all, Hoping someone can help. I'm trying to create a time sheet where the user inputs the hours & minutes they worked in 15min increments - so 1.25 (1 hour 15 mins), 1.5 (1hr 30 mins) etc.How do I get this to appear as 1hr 15 mins, 1hr 30 mins in an hh:mm format without asking them to do their time sheets in seconds and also have the ability to roll up the totals?Ideally they would not be tracking start end times using date fields. Just a box yo input a decimal. Example:  This is a platform I've used for timesheets in the past, Synergist Thank you!

Hello all,I am new at this and english is not my first language, but i'll try to explain.I have a number of columns with numbers in it.I want to make a formula that if the number is between 2000 en 3000 in that column then in the formula colomn it states 50 bonus and if the number is between 3000 en 4000 it states 100 bonus and when not met is says no bonus.So:Colomn 1          Formula field1899               No Bonus3999              100 bonus2545               50 bonus So far i have this formula:IF({Jul} < 2000,"No bonus",IF({Jul} >= 2000 <3000,"50 bonus",IF({Jul} >= 3000 <4000,"100 bonus",IF({Jul} >= 4000 <5000,"150 bonus")))) but all this does that it returns No Bonus or 50 bonus in every cell...What am i doing wrong?Thank you in advance for helping me.

I am receiving a cryptic error when attempting to create a record using the code below:// Change this name to use a different table let table = base.getTable("Touchpoints"); //let ctable = base.getTable("Contact"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let billTillString = await input.textAsync('Bill Orders till which date? (format YYYY-MM-DD)'); //let notes = await input.textAsync('Any Notes to mention'); let billTillDate = new Date(billTillString); /* //newRecs[0]['id'] = 'recDYGIT7fj80tTAH'; //let namer = new Array('recDYGIT7fj80tTAH'); //let Contact = record.getCellValueAsString("Contact"); // Contact RecordID //let recordID = record.getCellValueAsString("Contact RecordID"); //console.log("ID is: " + recordID); */ await table.createRecordAsync({ 'Start Date/Time': billTillDate, 'Contact': [{id: 'recI7YlI

I am attempting to setup a workflow for a Callback system for my Sales calls. My plan was that when a record in my Callback List View inside my Touchpoints table was updated to have the Call Result column be set to Voicemail select - that it would automatically duplicate itself and the duplicate would have 24 hours added to the Start Date/Time column - so that I would automatically see that record the next day in the Today's Calls View in the Touchpoints table.My challenge is that I am unable to find a way to duplicate a record based on the ID - so far I have created an automation and passed the record id as 'rec_id' variable to be accessed through the input.config() variable in the script that is set to run when my Trigger matches as per this screenshot:https://share.getcloudapp.com/p9uL4eKPAfter reviewing some other examples of scripts I have created a script which you can see in the Gist below:https://gist.github.com/HeadStudios/98c8837c02a0fb8540e3e36333281945While this script does

Is there an easy way to remove the color highlights from an automated report? I want the colors to exist in the base, but when an email goes out in grid form I'd like the color highlights for different categories to not show up.

Hi smarter people than me, I hope you can help?I have an integration with CraftMyPDF where I send a payload I build in script through to be used to populate the PDF template. 2 of the fields passed through are date fields: Contract date and Event date. I have noticed that these fields are always offset by 1 day in the past.In the base grid view (or any other Airbase view or interface) these dates reflect accurately, as captured. When I use these same fields in my payload and inspect it, they reflect with -1 offset. The dates are formatted "friendly" and set to my local timezone.Does anyone have any suggestions on how to get the API to honour the date as it is shown in grid views?thanks in advance!

Hello guys,I am an extreme beginner,I have my data as a date in the incorrect format, I'm looking to auto-convert each figure into a specific "date" category.Can someone please explain how to do so?Thank you so much in advance

How can I set up an automation in Airtable that will update records in the status column once a week, but only if they meet a certain status type, such as changing records with the status 'DONE' to 'Archive'?

I am building an automation to send emails (up to four), to addresses pulled in from a "Find record" command searching a rollup rollup field. I am using rollup because bizarrely lookup fields do not show in the automation builder.The result produces the correct email address list, but with formatting markup code. Any idea what's causing this and how to get just the email address so that the automation can use it?

Hi Guys,I am trying to wrap my head around regex formula but can't figure out what if there are two patterns in the string. Basically I want to extract the number after the bracket but before the "+".Current value : /Date(1676537746330+0000)/Desired value : 1676537746330 Thanks

I have a base with multiple tabs that have links between them. Tab 1 is Digitization Projects. Tab 2 is Scheduling.Tab 2 Scheduling is made up of individual task records. Each of these links back to a project record on Tab 1. The individual task records on Tab 2 all have start and end dates.From within the Record Summary Interface, I want to be able to select a single Digitization Project (from Tab 1), and have a timeline element display only the records and dates (from Tab 2) that are linked to that project.I have not been able to figure out how to filter things to allow this. Right now, it shows me ALL the records from Tab 2, whether or not they're associated with the Digitization Project (from Tab 1) that I've selected in the Record Summary Interface.Screenshots attempting to illustrate below. Any suggestions would be most welcome. Thank you!Digitization Projects (Tab 1)Scheduling (Tab 2)Record Summary with Timeline element visible but not working as I'd like it to. 

Hello Airtable Community,     Question: My main field (first left field) is the "Date", next field is "Day of the Week" (single select). Is it possible to automate "Day of the Week" field so it would automatically choose the day based on the calendar date input in the "Date" field?   Thank you in advance for your help

I'm using make.com and have a connection to Airtable and am trying to do a simple search on a table. I can't find a guide on Make or Airtable on the syntax required in Make's Formula field.I would like to do something like the following logic{Email}='1.email' AND {Date} >= CURRENTDATEWhere Email and Date are fields in the table I want to search. I can't seem to find the equivalent of CURRENTDATE in airtalble's Formula Playground or elsewhere.

This is happening on trigger from record creation, another script triggering a webhook, etc.  The automation just hangs on the first script step endlessly.I've confirmed that the script executes successfully when run by itself.  According to status.airtable.com everything seems fine.Anyone have an idea on what might be the issue? 

HiI want to define feature status by automation.For example, if all the user stories of the feature are done then the feature is considered as completed.Is it possible without a script ?Thanks for your help.

Is possible to have a unique id number from autonumber function across all tables?, For example: If I create a new record on table A, that record must be 1; but if I create another new record on table B must be 2

I'm a javascript developer, but all the examples I can come across are either too nuanced or specific for my needs, so I'm hoping to find a simple script to take the following table which has a column of linked records from a third table:Table_1IDLinked1A,B2B,C,DAnd spit out the following table:Table_2IDEach_Link1A1B2B2C2DThanks!

Hello!I'm attempting to optimize my Calendar view, and I'm running into an issue.I have a table with tasks that fall in three categories:Multiple Days (Start and End dates are different)Single Day (Start and End date are the same)Deadline/Milestone (only End date is filled out)In Gantt view and Timeline view, these work great. The issue is Calendar view. I duplicate the Start and End dates for Single Day events because it then shows the event as taking a full workday (which is important for our workflow, and it differentiates it from a deadline/milestone)In Calendar view, the start and end date appear as separate cards, essentially becoming duplicates. I could use a date range, but because of the volume of multi day events we have, this would make is extremely difficult to read the calendar. Is there any way I can merge the start and end dates into one card in Calendar view if they are the same, while maintaining the ability to move them around on the view itself? (i.e - not

I am trying to setup an automation for the following:1) At a scheduled time (eg. 10am)2) Send an email to records in Table 1 3) Condition: IF the record has been 'ticked' (A field in the table is a check box that must be ticked, for the email to be sent at 10am).I can setup an email to be sent at a schedule time OR I can send an email if a record is ticked - but I can't seem to do all 3 of these steps. Any ideas? Thank you!

Hello dears,I need help please to do the following formulaIf multiple cells in the "Star" column matches each other in text and the matched cells has the options "in office" or "stock" in the "Status" column then mark all cells as {show}If multiple cells in the "Star" column matches each other in text and the matched cells doesn't have the options "in office" or "stock" in the "Status" column then mark all cells as {hide}The below image should clarify the need please i need help 

Hello,I'm wondering if anyone has any recommendations on how to achieve the use case below. I've seen VLOOKUP scripts and I've also seen automations, but not sure which would be easier given the criteria.Table A has each Product and State pair listed as its own row (as there are other columns of data applicable to that pair). The Product will have as many rows as necessary, depending on how many states it's sold in. The Status column says if it's approved to be sold in that state.Table B needs to be a summary of all of the states that each Product is sold in and the status of the approval, where each Product has one row and the States are now listed as columns.Table B needs to lookup the Product name in Table A, find the State name in each row and bring the Status in that row over to the matching State column in Table B.It would be great if each time a record is created in Table A, a single record representing that product is created in Table B. So it would look like this: Th

I am now working on integration the Airtable OAuth to my existing system.So I am trying to test on Postman first.But when I send the GET request (e.g. https://airtable.com/oauth2/v1/authorize?client_id=xxx...) for Authorization in Postman, it return the web page "verify it's you -Airtable". The page also says "Our systems have detected unusual traffic from your computer network. Please help us with a quick security check to validate it’s you sending this request".But if I run the GET request on a Chrome browser, I can get the return code without issue.Can anyone help? 

hi, asking for help,I made a database of my office documents and i need a formula for due dates that is due on 16 months, however the due dates will correspond to two （2） date fields, ex. date A and date B, the condition is this; if date B is not empty, due date will correspond to date B + 16 months, but if date B is empty, due date will correspond to date A + 16 months.I hope someone help me, thank you!

Hello. I have found several posts that deal with this issue but it doesn't seem to work for me. Problem: I have a form that I want prefilled, but for columns pulling in data from linked columns, it will only pull in the first data entry even if there are multiple selections ("Assigend to" column with multiple people selected from a linked "Name" field on the "Persons" sheet.Suggested Solution: Was to created a Roll up column that would join the linked values and then get pulled in to the prefill easier. https://community.airtable.com/t5/formulas/prefill-form-with-multiple-linked-records/td-p/26213Here is my URL Formula on button that links to form (Assigned%20to is the linked column in question):Here is the formula in my roll up column "Assigned_to_Rollup". This is the prefill value for Assigned to.Actual behavior: In my form, only the first name gets pulled in, though.In the base, there are 3 names assigned that are joined in the rollup column. The prefill doesn't seem to pu