Solved

Hello Airtable community!I have created a Jira integration with Airtable. There is a field for Sprint, however, if a ticket was included in more than one sprints, all sprints appears seperated by commas. I want to extract only the sprint that is the highest number. I tried doing this by taking the last one (with the RIGHT() function) but unfortunately the string is not always alpahbetically sorted within the cell. Please see below:Essentialy, I'm trying to find a way to extract the highest sprint. Any ideas how to either sort alphabetically within the cell or how to extract the highest using a formula? Many thanks!

Hi. I am using the Find Records action to return what is frequently a more than 1 item long list of results.I understand that the results are returned in an array, so when I try and append the results to a Google Sheet, they will all be listed in the same Sheet row.Has someone figured out a way to create a new row for every record in the array? Or is there some completely different way of doing this?Thanks!

Howdy, I am trying to append my airtable records to a google sheet at regular intervals, including my last modified column. How can I get it to append the actual value, and not just the character length of the value. I’m getting results like 29, 30, 29, 29… for my rows instead of 8/18/2021 10:27:31 or whatever

Hey guys im really dumb in Excel, I need some help. First column is the item, then next one I have records for each, that is the stock. I’m struggling for an hour to find a formula which COUNTS how many rows are there, therefore I have the exact numbers of the rows, which is the stock for each item. Thanks!

I need to be able to interface general information, name, email address, title, phone number, to external clients so that they can edit the data and the changes are also automatically made on our end, on our base. 

Hi! How do I individually concatenate fields if one of the fields is comma-separated? For example, I want to take “red, blue” and concatenate this with “shoe” to come up with ““red shoe”,“blue shoe”” with the quotation marks instead of “red, blue shoe”. Any ideas? Thank you in advance!

Hello,I would like a formula to convert date fild  into quarter and  add display it in full text.Exemple:Dates between 01/01/23 to 31/03/23  will display " first quarter"Dates between 01/04/23 to 31/07/23  will display " second quarter"and so on...Thanks for your precious help. Remy     

Hi everyone! I’m trying to work with the Vega-Lite extension to show sums of values in multiple fields in a stacked bar chart, but I haven’t been able to get a stacked bar graph to work correctly without manually creating a new “data” array of objects with values. For example: I’d like to be able to show something like “Jim worked for 0.5 hours on checking emails, 2 hours on code reviews, 1 hour on development, and 1.5 hours on assisting coworkers, for a total of 6 hours” as a stacked bar chart, where Jim has each number of hours as a different field on the table for a total of 4 fields and 4 bars stacked. Is this possible with Vega-Lite’s integration with Airtable, or even Vega-Lite as a whole? Or am I limited in either how many fields I can stack or how the table data is formatted? Thanks in advance!

I'm I missing something or does the mobile app (iOS) ignore view information in Airtable url links? Scenario: I setup QR codes to pull up records in specific view for updating assets. On a web browser it works perfect but on the mobile app it always opens in whatever view was last used on that device and ignores the view referenced in the link. Also, is there no way to input/search on the mobile app via QR(camera), have to leave app switch to camera scan, then it reloads app very slow process forced to walk around with a laptop or use another tool to collect then upload, update via script

Hello, I have created a custom Airtable extension. But when I run the block this error message is showing. TypeError: Ic.createContext is not a function

Hello,I am having a table in Airtable that contains a text field with dates. I imported a CSV files. And all dates were added as text field in a wrong format (MM/DD/YY). So I am basically looking for a way to: Convert these text date field to a real date field that is next to the column (so Column 1 with the text based date value should be copied to Column 2 with a date field)And in another column I want to change the date format (also text based) from MM/DD/YY to DD/MM/YYYY.How can I do this? Thanks for help, M.

I am using a customized version of the Employee onboarding Template base. The template seems to be set up to duplicate the base for every new hire that is being onboarded. I would like to use one base that generates a checklist for the employer onboarding tasks every time a new hire is created (I have a synced table with new hire records). I thought maybe I could use the new record templates feature, but the problem I'm encountering is that just linking tasks means that I can't use the "Complete" checkbox because it applies to the task record, not the task for a specific new hire. I hope this makes sense. Can anyone advise on how to make it so that everytime a new hire record is created, a series of tasks are created for that new hire specifically that can be used as a dynamic checklist?

Hi,I'm working with the NPM package to get data from tables which have lookup fields and I'm wondering if there's a way to ignore these lookup fields in the initial API call either by using some parameter or `filterByFormula`. I've checked the API documentation for my tables, checked the documentation for the Formula field and nothing seems to be able to filter by field type.EDIT: I guess the question can also become, is there a way to ignore fields when using the `base().select()` method? I have a list of the fields I want to ignore from the Base schema but can't find a way to ignore those fields. I can just drop them from the returned data afterwards but that is going to be fairly expensive as we're processing potentially tens of thousands and eventually millions of records. Thanks in advance,Thomas

I'm not sure if what I'm trying to do is possible, but here goes:I'm working off of an existing base template, and am trying to tweak one of the formulas that's in there. The existing formula is as follows:I would like to add one additional condition: if Equipment Status is "Unknown" the result is"❌ Not Available". Since this is pulling from a different field than the existing SWITCH formula, I can't add it in there; I've tried nesting another "If" within this formula, but that also doesn't seem to work. It may be that I simply can't do this, but if anyone has any ideas or suggestions, I'd appreciate it--I'm pretty new to Airtable formulas, and trying to figure out how best to leverage these formulas. Thanks in advance!

Hi there, Im new to airtable and Im having difficulty with formulas in general.Currently on my table is Name, Date and the PromoWhat Im trying to achieve is that every time a new person and the date is added, the person is given a promo based on the date providedFor exampleJohn Doe - Jan 1 2021 - promo 1 (during 1 week of the date)John Doe - Jan 1 2021 - promo 2 (after 1 week but during 2 weeks of the date)John Doe - Jan 1 2021 - promo 3 (after 2 weeks but during 3 weeks of the date)I know this may be difficult which is why Im asking the community for assistance on this part.Thank you!

How do I create s drop down list for a certain field, but as users fill in the table, they should only be able to use the options I selected on the drop down list, but not be able to add new options. How do I do that?

I am trying to send an automated message with outlook. I want to avoid using a hosted image from a URL, and have an inline image in the mail. This help page shows this is possible by inserting a “render at html” grid or a list, but I can’t make it work: https://support.airtable.com/hc/en-us/articles/360051028394#:~:text=How%20can%20I,your%20HTML%20tags Instead of the image appearing, I get either a ticked checkbox or the name of the field. Can anyone enlighten me what is going wrong?

So I have this automation set up so that if there's no email address where I expect it to be, it can try using another field - but it's getting hung up on the if step. Isn't that the whole point of an if->otherwise condition set up? 

Let's say I have 3 date columns namely Attempt #1, Attempt #2, and Attempt #3. I want to send Attempt #1 on May 1, 2023 --- then I want Airtable to automatically compute the next follow-up date (which is after 3 days). But if it falls on a weekend, I want it to automatically add the nearest weekday date available. The same goes for attempt #3, I want Airtable to compute the next follow-up date based on the date indicated in attempt #2. Is this possible? 

I extracted unique names of participants in my table by using the ARRAYUNIQUE formula in a field called {Progress Made BY}. This produced a list of unique names separated by commas in the {Progress Made BY} field, which is what I was looking for. I used this one instead of CONCATENATE because I had a couple of duplicate text strings. I then created an IF LEN SUBSTITUTE formula field called {# Participants Progress Made BY} to count the names separated by commas produced in the {Progress Made BY} formula field. IF({Progress Made BY},LEN({Progress Made BY})-LEN(SUBSTITUTE({Progress Made BY},",",""))+1) *Note that I had used this formula successfully in other tables to do the same thing, however the reference field in the other formula fields was a CONCATENATE formula field instead of an ARRAYUNIQUE formula field. I get an #ERROR message in the {# Participants Progress Made BY} field where there is data (separated by commas) in the {Progress Made BY} field in the record, and nothing retu

I'm trying to get this formula to calculate the difference between the date 'today' and the date in the field 'End date', then stay blank if it it's more than 10 days but return 'Yes' if it's 10 days or less. I can't get it to return the right values though. Any suggestions for how I can fix this to get the right result?  IF(DATETIME_DIFF(TODAY(),{End date},'days') >10, " ", "Yes")

Hello!I'm making a table to generate contracts. Sometime there is 1 name on the contract, sometime 2.List of my columns :Name 1Name 2And (just a formula for write "and" in the column).I'm trying to find the good way to write the formula of my and column :CONCATENATE({And}, " ", {Name 2}) (it works fine)IF({Name 2} = BLANK() => don't show "and" in this column.Thanks for your reading!Have a nice day.

Hello, I have the table that is pulling information from other table using lookup fields. However, unless I manually assign the initial pull-down record, it wont find any previous information. I am trying to use automation to fix that.I attempted to link record based on  this article however it does not do what I want it to do. The goal is simple. I have Table A, it contains names and all the associated information with those names. I am adding the lookup fields from other Table B, and I want to see what information it contains. I need to connect these two, so the lookup field from Table B that initialises all the following references automatically assigns to Table A field. I tried "Update the Record" and "Find" and then "Update", but it doesnt seem to work. Any help is appreciated!

At least let me re-order the interfaces that are listed.Right now it's as you create is the order that is displayedI really want interfaces that are related to each other to be next to each otherFor example New Contact at top, Lookup Contact and Activities EntryAnd the two Dashboards at the bottom.  

Hello everyone,I want to allow a list of people (whose information are already stored in a table) to book different events in a Calendar they could access. The booking system would allow them to see all upcoming events, and register to the ones that we still have availabilities for (let's say 5 participants maximum per event for example).I had access to the "No-Conflict Asset Reservations" template, and it seems promising, but it implies that the Assets will be available 24/7, whereas I would like to let people choose among a list of pre-defined slots.All the registrants will be pre-existing records in my "People" tab. Ideally, I would like the process for them to be:They receive a unique link to a view/interface they can bookmark and share internally.They open this, and see the event they want to take part in. The number of participants is displayed next to an event, and only events where we still have slots remaining are visible. (In a perfect world, they could even toggle betwe