Solved

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

I have created a Rollup field in my Contact table which searches within the Touch Points linked table and rolls up the 'Start Date/Time' field using the 'MAX(Values)' aggregation formula. My challenge is that I am unable to get a date which I can then filter to appear inside my Rollup field. The Formatting tab does not have the option for date as per screenshot:https://share.getcloudapp.com/X6uKqr7Qhttps://share.getcloudapp.com/9ZuKv2yyAny input would be appreciated. Video included below for more context if necessary:https://share.getcloudapp.com/rRugpPzAThank you!

Hi! It says that Airtable automation runs rest every 1st of the month. Our current limit is 50,000. We've been in Pro Plan since 2021 and have never experienced running out of runs. However, just 15 days after February started, it says that we're out of automation runs. We did not add any significant increase in usage. Has anyone experienced this before? Is there a way to get a breakdown of your usage to see which automations consume the most runs? Or is there a possibility that this is a technical error from Airtable's end.Any help is greatly appreciated!

Hi.I got very excited when I managed to insert a gif of a screen recording into an email using the Gmail automation. But, I can't for the life of me resize the gif!I've seen a few other posts that mention removing the '%' sign, so the number is for pixels, I've even put 'px' after the number to no avail. I can't see what I'm doing wrong and looking at CSS script, I can't see anything similar.The code in the email is:<img src="https://dl.airtable.com/.attachments/4264bcfde762b6e6126cc3dcdbdcf244/8e042b16/PortalConfirmTripGif.gif" style="width:300%;height300%" />As I said, it displays, but I can't resize it and it is currently too small... it is just teasing me!!!Any help appreciated.

Is it possible where we send a slack automation with button that when you press that button, it updates a specific column on slack?

I am creating a new record triggered by a script with the following code: let newRecs = {};newRecs[0]['id'] = 'recDYGIT7fj80tTAH';await table.createRecordAsync({'Start Date/Time': billTillDate,'Contact': newRecs,'Notes': 'New Record note'});I am getting the following error:  TypeError: Cannot set properties of undefined (setting 'id') Can you please modify the script - assuming the record Id is correct - so I can populate my Contact link field? Thank you!

Hi,  In my database I have several fields that are calculated automatically with a formula, but I want some of these important date in a calendar.  But the Calendar only allows me to use a Date Field, how can I "force" the calendar to take the formula date ? This is my formula fieldDATETIME_FORMAT(DATEADD({Date de départ}, -60,'day'),'DD-MMMM-YYYY') Thanks for your help !

Hello Airtable Community! 🙂So... I am rather new. I have a formula that works fine, except that occassionally the result is a negative number.How can I display the result as "ZERO" if the result is less than zero (i.e. a negative number)?I read somewhere that MAX should do the trick... but not working.   IF({Total Sold}> 0, MAX({Total Sold}-({Products Completed}+{Total qty on hand})), 0)   P.S. As mentioned, I am new, so if you do write out a quick formula, could you please use MY actual field names? 🙂please advise, and thank you in advance!DJ

Hi! Is there a formula (or other solution) to remove extra whitespace within a string? My formula right now looks like:  SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({name})," "," ")," :",":"),” .”,”.”),” ?”,”?”),” ,”,”,”) This works great to remove whitespace before/after the string using Trim and then remove double spaces and spaces before punctuation using Substitute. I'm wondering if there's a way to also remove instances of 3 or more spaces within a string without separately writing each possibility (3 spaces, 4 spaces, etc) as substitutes.Thanks for any help!

Hi!I'm having such a basic issue and can't figure out what I'm missing. I believe this should be a very basic IF statement: IF {field} is not empty, show this stuff. However, I've tried using {field}, {field}!="" and {field}!=BLANK() and even where there is nothing in {field}, text is showing. Here's the simplified formula I'm using to figure out what is going on (substituting "the text" for what will really be there):IF({abr formula- all},"the text")Here you can see that even if {abr formula- all} is blank, "the text" is showing up.Any help appreciated!

Hello everyone! So first off I have this formula field:   DATETIME_FORMAT( IF( DAY({Tilføjet d.}) <= 10, DATETIME_PARSE(CONCATENATE(YEAR({Tilføjet d.}), '-', MONTH({Tilføjet d.}), '-11'), 'YYYY-MM-DD'), DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.}) <= 3, 3 - WEEKDAY({Tilføjet d.}), 10 - WEEKDAY({Tilføjet d.}) + 3), 'day') ), 'DD/MM/YYYY' )  The name of that field is 'Kan laves d.' and shows me the date of the next coming wednesay based off of the date the record was created. So for example if the Record was created today, it will show me 25/2/23. So what I want to make now is a new formula field, that will add a green circle for all the records that can be made the next coming wednesay, and only for those.  Can someone help me with this?

I have a column 'Original' with the value: Breakfast-NO|Lunch-YES|Dinner-YESI want to the next three columns that are set to formula to automatically be set like this:OriginalBreakfastLunchDinnerBreakfast-NO|Lunch-YES|Dinner-YESFALSETRUETRUE Breakfast would be the string between the first '-' and '|'Lunch would be the string between the second '-' and '|'Dinner would be the string between the third '-' and '|'also want to convert the value from No to FALSE, YES to TrueThank you.

What are the acceptable colour choices for single/multi selects in scripting?I've been creating new fields via a script and now I want to make a multi and single select, which is fine, I can do that much like so: await table.createFieldAsync("new", "multipleSelects", {choices:[{name:"test"}]}); But all the colours become grey and I'd like to specify the colour of the tag (or randomise it). I know there's a `colour` option for the array, but the documentation doesn't specify or give examples of what this should look like other than it being a string. I've tried using hex codes for colours, colour names etc., even the specific colour code of the default colours I can use, but I'm always getting this error message: j: Can't create field: invalid field config. Failed schema validation: <root>.options.choices.0.color does not match one of the possible values But I can't see anywhere that tells me what any of the "possible values" are!Can anyone help?Thanks

I have a survey set up with 5 of outcomes depending on the total amounts of points. To assign a certain score to a certain outcome I used the IF statement. See attached files. It does not work properly for at 60 points it should show 'Extreme angst'.Any thoughts?Thanks.   

I am working on creating an automated email.  I want the email to go out when a user updates a record.  The email should read the following:[user] has updated [task][status]...etc.  How do I set it up so the user populates in the email?

This is a code that uses the Scryfall API to search for Magic the Gathering cards based on user input. The first line prompts the user to enter the name of the card they want to search for. The second line sends a request to the Scryfall API with the user's query, and the third line converts the response to JSON format.The code then checks if the API returned any search results. If there are no results, the code outputs "No results found." If there is only one result, the code creates a new record in a table called "Cards" in a service like Airtable with the card's information, and outputs a confirmation message. If there are multiple results, the code prompts the user to select the correct card from a list, and then creates a new record for that card in the "Cards" table.The issue arises when after the list of potential cards is loaded as search results, if it cant parse the card name it gives a bunch of options, no matter what option you choose, it wont actually add the choice as a r