Solved

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

Hi folks : )I'm trying to put a link in an automated email, and it keeps generating a sequence of characters at the end of the url that makes the link useless. Here's how I have it set up in the body of the email:Here's what the end of the url is supposed to look like:230526796288065/sign_document_d4deb6cd5dd95877_79e90063180a7cbf.pdfAnd here's what it looks like when the automation is done with it:This happens whether I set up the field as a URL or single line text, and the link opens fine from the data view; these extra characters only show up in the link generated by the automation email.Since the characters look like html encoding, I looked them up and found this, if it helps:%EF : ï%BB : »%BF : ¿How do I set it up so this doesn't happen? Or is it a bug that can be fixed?Thank you for your attention,Shawn

Hi all!My team and I are using Airtable to store user research as we build out and iterate on different products within our org. One of our goals is creating a repository to reference research participants we've spoken with in the past to contact them more easily for future research. The goal of this base is two-fold: the first being a structured pool of participants to pull from, and the second is a collision map to make sure we're not pulling the same participant for several different projects and overloading them. Our project teams often aren't aware of who the other team is recruiting for research and this has happened a few times. In the participant repository base, my setup so far is 3 tabs, 1)Ongoing projects and their timelines, 2) Our staff members and 3)The participant database. I have a lookup field in the participant database tab that lists the projects a participant is involved with and another field with the status of those projects, whether they are active or i

Hi,I have a project management interface where I have a table listing all of my projects and then another table for tasks.  On the task table, there is a link to the project table.  I have created an interface using kanban that shows the tasks by priority (high, medium, low).  In the interface, I allow the linking of the task to the project table.  When I click the plus signal, it only shows me the first three fields from the project table.  Is there a way to modify what fields show on the "linking" screen that pops up?Thanks,Kevin

My phone number field has rows with different formatting. e.g. 12824673737 and (510) 890-9699 How can I force all the phone numbers to be of one format: namely, a 10 digit number without any punctuation in between

Hello,Currently, we use automations integrated with Slack, where we utilize the "actionable message" feature to allow users to approve or decline directly through Slack. We are now transitioning from Slack to Microsoft Teams and would like to know if the same functionality is supported in Teams. Specifically, can we enable actionable messages in Teams using automation?Looking forward to your guidance.Thank you.