Solved

hi Airtable users!I have a question regarding custom selection of Lookup Field Values in Linked Records.I have 2 tables (A and B). I setup a Linked Field and then 2 lookup fields in table A. This pulls in a Group name Category names from B.Now in Table A, I'd like to manually choose a specific Categories (based on categories from the lookup field).  The steps I'm trying: I choose a group (in the linked field), and then choose categories manually... but I can only see how to show ALL categories in the lookup field OR categories that meet certain conditions. But this is not what I want... I want to choose only specific categories, which vary for each record. There are no conditions for this.How would I do this? Maybe there is a formula?  Please help!How can I choose specific values based on a lookup field?Thank you

Oh, this one has me stuck!I have a table of 'Individuals' with an email address and a unique ID on one table, and on another 'Audit' table, I have audit line items with the linked ID. I would like to use a checkbox of 'publish' in the Individual tab to trigger an email that sends a table of relevant data to the right individual. Right now, I have a trigger or 'when records match' showing a few conditions including publish. then Find Records, then Repeat for each List of records, with a send email and appropriate grid in the email. Problem is, I can't convince the automation to sort these, so person A only get their results ,and Person B get theirs. It's a mash of results, not getting split per individual. Because the list of individuals will continue to grow, I can't create a view per individual.Can anyone see what I am missing here?

Are the record's previous values available in the "when record is updated" trigger?  I'd like to be able to compare the previous values with the current values and act accordingly.  Does this require a code step instead?

Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?I hope this makes sense!

I have a column of Job Names and would like to indicate which Job Names are unique in that column. Has anyone successfully done this? Essentially I want to do the opposite of checking for duplicates and returning duplicate values in a new column.

Hello! I am new to Airtable and have been poking around for awhile now to try and create the following / see if it is possible in Airtable.OverviewI am setting up a super simple voting table, it will just have an ID and 3 string vote fieldsI.E. test data, and/or the Votes table, would be like (made-up names used)IDVote 1Vote 2Vote 3582394John DoeSally Sue (blank)362344Billy JoeJohn DoePeter Thol623442John DoeBilly JoeSally SueWhich ideally would aggregate into this Votes Cast table, sorted greatest to lowest number of votes:NameVotes(aggregated from above based on string value)John Doe3Sally Sue2Billy Joe2Peter Thol1At first I was reading about Rollups, but I am not seeing examples utilizing multiple fields/and or creating dynamic lines for results, for example, if a new person submitted the name James Cullen, then a new row would appear about for James Cullen with their 1 vote.If this is not possible...is there a way to achieve this if I do 1 vote per row? I.E. If each vote (of t

I'm trying to use an automation in a base, but there's something wrong with my flow. And it may be that what I'd ultimately like to accomplish isn't possible. In Base 1, I have a single-select field named "Status" with various color-coded options as variables to select from. In Base 2, I have a duplicate of the fields in Base 1, but none of the data. My goal: When the single-select field Status is changed to a particular option (in this case, "Delivered"), the record is copied from Base 1 (Active) and duplicated in Base 2 (Archive). But the flow I have is definitely not correct. So, one, is this possible? And, two, does anyone know what I need to adjust in the automation flow? Thanks so much for your time!

Background: Source table has no records, but fields have been configured. This is a blank copy from another base.Issue:  When in EDIT mode and with Creator access, Interface Layout "Record Review" does not show any page elements (page is blank) and does not allow me to add or remove elements.  I am unable to configure the interface page. I am only able to configure the "Record List".Request: Is there another way to add elements to a Record Review when the source table has no records? 

Hello,I have a very simple formula that is taking the values calculated from other fields and giving a total.  The problem I am running into is unless I have the formatting set to 5 decimal places the results will round.  For the work we are doing we need the data to not round, but the issue is for the exports we have to do to input the data into another system we have to remove the extra decimal places. Is there a way to keep the 2 decimal place formatting while preventing the rounding?For example if a value is 2543.54546 we would like it to be 2543.54, but if I change the formatting to two places the number ends up being 2543.55 which for reconciliation is a problem.  The values change daily so the direction of rounding also changes.  My formula is super simple {value1} - {value2}I did try adding the ROUND function, but that didn't seem to help at all.  ROUND({value1}-{value2},5) I tried various values for the precision and none of them did what I n

Hi there,I have two tables and an interface with a form. The first form is used to add an entry to the table. I have this displayed as a nice gallery.I wanted to add a button on the gallery, so the user can click the button on the record and it will take them to another form to request a change to that record. I've got about 90% there, but getting the field to prefill with the record_ID has been miserable. I've tried every combination and it just doesn't work.On the form I added a new field "Link to another record". I select my primary table and select some columns to bring in via lookup. It looks great, the user can use the drop down to view all submissions and select the one they want. But the prefill doesn't work to auto select it. https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=["rec1YlesldDRjs06V"]https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=rec1YlesldDRjs06VNothing prefills the entry. If I try another field, like Name or Title which isn't a linked reco

I'm sure this an easy one - but I am stumped.  Here is the scenario: I want to create a view so I can send out a daily report that shows all records that are on tomorrow's service schedule, yesterday's service schedule, and 2 weeks ago service schedule.  The current airtable filter options of tomorrow and yesterday work great until it comes to the weekend - meaning on my Friday report, the Monday activity is not showing up and on my Monday report, the Friday activity is not showing up.  I have created formula fields that calculate the next work day but Im still stuck on how to filter it.  I tried to filter using "is after" "today" but then it gives me all records in the future when I just want the one next workday.  Maybe I am approaching this all wrong and making it more difficult than it is - but my brain is not computing 

I have created a blank interface where submissions that come in to the "Requests" table are used as the basis for creating records in the "Jobs" table.I've identified that the biggest potential for user error is not having the correct Job selected in the right-side dropdown. I'd like to limit the dropdown's selection to only Jobs that are linked to the Request that is selected in the left-side dropdown.Nothing I've tried so far has worked. Any ideas?

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. Column: Submitted date: (constant)- user entered Columns: Expected Project Return (date) DATEADD({SUBMITTED Date }, 10, 'week')) This checks out good.  when I have a Resubmittal column(date) I would like the Expected Project Return Date to now show DATEADD({SUBMITTED }, 30, 'day')) So in short i want the expected return date column to update once the resubmittal date is updated. 

I'm using the CSV Import extension to import data into an existing table. I am trying to preserve a linked field relationship so that when data is imported, it does so into a linked field. I understand this is possible, however, the linked field I am working with is linked to a table that is synced from another base.When I try to import, I get an error message saying "You can't create records in 'Table' because it is a synced table." Are there any workarounds or is this just a limitation of Airtable? If I turn off the field (complete_machine_sn), I don't get an error message. At the end of the day, my goal is just to import the data and preserve the linked relationship, as I have downstream workflows that required that linked relationship.

I have and “hours” table whose rows consist of the following relevant fields:An email address of an event participantNumber of hours participation in an eventYear of the event participationThere will be separate rows with the same email address for each event where hours are recorded.I want to create a query (filter, group by,…) that answers this question.  Which people (email address) participated in at least one event in both 2022 and 2023.Following one suggestion, IGrouped the rows by email addressCreated a new field, called “yrs active” that is defined by the formula “arrayunique(year)”.  On the email address group by line, it indicates the number of unique values found so I assumed I could apply formulas or filtering that operated on just those unique values.Created a second field, “In 2022 and 2023” defined by the formula, AND(FIND("2022", {Yrs Active}), FIND("2023", {Yrs Active}))thinking that at the group by level, if the unique values contained both 2022 and 2023, th

Hello,I'm wondering if there's a workaround to import data into linked fields. For example, I'm importing monthly salary information to a data table and the employee name corresponds to the primary field of a different table. Airtable only imports the non-linked fields.Would it be possible to import the employee name as a different field then run a script to create the linked record ? Or any other ideas will be appreciated.Thanks,Mark 

Hey there,First of all thank you for your time and your help 😉I've made some pretty basic automation, when a record matches certain conditions, I trigger the action "send mail" (airtable default one). The field "To" is filled with a roundup type of field which has a formula "ARRAYUNIQUE(values)". It keeps the unique mails attached to the record.My issue is that it works 30% of the time. The failure to run is always caused by : "The "To" input is empty"Which is not, the field is never empty, it always has one or several mails. And it being not empty is a condition to trigger.I can't find what's common to success or common to failure.Any ideas ? 🙂  

Is there a way to put totals or aggregations at the bottom of (or any where for that matter) a list in Interfaces? I am not using the blank option - I'm using the Airtablke supplied ones because you cannot embed ones created from blanks into a website. They are always at the bottom of columns in the base grids. It is vey inconvenient to have to add things up with a calculator  every time Look something up. Is there an Automation that would do this?Thank, Scott

I'm having a mental block on something, and I'm sure someone will point out the right way to do this, and I'll privately say "oh, of course", but for some reason the coffee and adderal hasn't kicked in yet....I'm trying to make a member contact form that has a link to a specific person to populate an email table.I have two tables:Member - a list of people including status, name, email address etc...Email - a table that has all the email fields that I use an automation script that takes certain status values "Send" and sends those out and changes the status. I use this script method instead of the pure automation because I have several other scripts that generate emails from templates to send emails out.We essentially have a wiki page with a page for each users's profile (for example: <Jeff's profile >. I want to have a link that uses id=record_id() of a row on my members table, which ties to an individual. When they hit the link, it pulls up the name, member photo, and some

Hello guys,I'm struggling to achieve the desired results here. First: I have a formula that return a number between 1-156 based on the created time of a record:(VALUE(DATETIME_FORMAT(CREATED_TIME(), '0.smh'))*(156-1))+0000 Although I want this formula to return an integer and not with decimal values.What to I need to change here? Thanks in advanced.

I'm using a Repeatable Group with an Update Record inside to take a list of records from a Find Records action and update a field in the found records. When the list of records contains only one record the test runs successfully. When the list of records contains more than one record I get a received invalid input error. I think I know why this is happening.If I look at the Input table after a test I see Record ID listed there followed by a single record id if only one record was found. If more than one record is found then I see Record ID followed by multiple record ids separated by commas. If this is what is being presented to the Update Record action of course this will cause an error. If I'm reading the documentation correctly the input from the Repeatable Group should be a separate Record ID followed by a single record id for each record found rather than a single Record ID followed by multiple record ids. Why is the Repeatable Group not presenting the Record IDs to the Update Rec

I have this code that works well when filtering a field that is SIngle Line Text empName="Dummy Employee"let records = query.records.filter(record => record.getCellValue("Name") === empName); But If i want to filter a field that is a "Link to another record" field, it will not find it.let records = query.records.filter(record => record.getCellValue("Linked Name") === empName); I have a work around where I have a formula field that converts the value in the field "Linked Name" to a string, but i would like to tidy it up. Has anybody encountered such an issue? Thanks in advance   

I have a table with the following fields:Capacity Required - a number Capacity Provided - a roll up sum of a linked recordGap Remaining - the delta between Capacity Required and Capacity ProvidedI have another field called Status that looks at the Gap Remaining and provides a single select option The following are all nested, so will be triggered in order: If the gap remaining is negative, the status is "overstaffed"If the capacity required was 0 to begin with, the status is "N/A"If gap remaining is 0 the status is "fully staffed"if the gap remaining is less than the capacity required the status is "partially staffed"The status field behaves as expected for 1207 records in my table. But now I have a record where when the gap remaining is 0 the status is partially staffed...if and only if one of the values being rolled up is ".10" and only for one specific record. If I change the value from .10 everything works, putting a .10 value in a different record als

my kanban is a list of products with different stacks. I would like it so that when a product is moved from one stack to the other, the autmation sends a slack message as to what stack the product is currently moved to.How do I access the name of the stack? I clicked on the blue plus sign but nothing there relates to the stack name. Just the product details.

I've created an automation that follows this schema:The issue is that when it finds three matches in the name, it writes the name as many times as there are matches. I only want the name to appear once.I don't know how to achieve this.Thank you for your help