Solved

I have set up an automation:Trigger> Google sheets: when a row is createdAction 1> find records where REF is [value from google sheet column with REF #s, which should match airtable REF values]Action 2> update recordAction 2 is giving me trouble. I have 2 fields I want to update (a checkbox and a currency field).When a row is created on the google sheet, for example with airtable REF #AB-0101 in the google sheets "airtable ref #" column, I want airtable to find record #AB-0101 and update that record's checkbox and currency field. I swear I had it working last week, but today's test failed due to "invalid inputs." I don't really understand how the "Record ID" part of the automation setup works for Action 2 (update record). I did blue plus sign > Use data from... find records step > ...... then I'm lost! I've been digging around trying to find an explanation for the different options here (Insert all records as list vs grid, vs Make a new list of...) but not

Do you accept VISA (which is technically not a cc) or only Mastercard and other pure credit cards?

Is it possible to automate the status of read-only interface collaborators? For example, when the status of a collaborator changes to 'inactive' in my base, I'd like to remove them as collaborators on all interfaces. When their status changes to 'active', I'd like to remove their access to Interface B but preserve their read-only access to Interface A. 

I need help with script (or other way?) to merge Multiple rows with same "User ID". These aren't duplicate rows. They have 2 fields in them that are different in each of the rows with the same User ID but need to be merged to one row. Essentially every 4 rows will have the same User ID that needs to be merged like this. Examples below.Example of what I have:User IDQuestionAnswerDaveDo you like CatsNoDaveDo you like DogsNoDaveDo you like Hamsters YesDaveDo you like MonkeysYesExample of what I Need:User IDQuestion 1Answer 1Question 2Answer 2Question 3Answer 3Question 4Answer 4DaveDo... Cats?NoDo…Dogs?NoDo…Hamsters?YesDo…Monkeys?Yes

I have a form that is letting people create Inventory Request Records, choosing Item Records they would like to check out from our inventory. We would like to have a way that will automatically prevent them from choosing an item that will be checked out during the dates they have selected.Using the filters and conditional options for these fields, I only see being able to toggle visibility for the results of the "check in date" and "return date". I would like to use the values from the questions asking for the dates to compare to the records in our "Items" grid so "Items" checked out will not be visible but I cannot find a way to do this. We are not able to use a 3rd party platform.Any guidance on maybe how to rework the fields to allow us to use the info from previous answers to help filter their selection? Is there any way to have formulas or more advanced coding in these forms?

I am struggling to add a holiday string in an existing worback formula that changes the date based on another field. I applied Workday successfully but cannot apply {Holiday String}&"" SWITCH({Channel Size},'Large Email', WORKDAY(DATEADD({Launch Date}, -16, 'days'), -1),'Medium Email', WORKDAY(DATEADD({Launch Date}, -12, 'days'), -1),'Small Email', WORKDAY(DATEADD({Launch Date}, -8, 'days'), -1))I found two posts about adding a holiday string from a lookup field {Holiday String}&"" and still cannot get it to work.https://community.airtable.com/t5/other-questions/referencing-holiday-string-in-a-formula/td-p/135086https://community.airtable.com/t5/product-operations/feature-request-workday-holiday-sets/td-p/144717 

We have a form our users fill out that requires selecting a few entries from a long list of items, which we've managed to clean up by storing items by organization name--each organization has its own multi-select field, and they're conditional upon that organization being selected, so the form works nicely on the front end.On the backend, we have a bit of a mess. There are nearly 100 organizations, and every one of them has a field. In order to easily collect the items that users are selecting, we have a formula field that concatenates every organization field. It's basically:{AA} & {BB} & {CC}which returns the selected values in whichever field.The problem is that the multiselect fields don't all behave the same with the concatenation. Sometimes they produce a comma and space between them. Sometimes they don't. My goal is to clean this up for our user facing team in our automated email notification to show which items they've selected in a nice, bulleted list.Any ideas?

Hello!I am looking for a formula that will update on a month basis to pull data for a meeting.I have a few dates I want to pull from - Target Start, Target Completion Date, and Dev start. I would like to label any records that have a date in the upcoming month (ex. March as our review is the last week in Feb) to be labeled as "Now." Then any content that has a date falling in the next 3-months to be labeled as "Near" and all remaining to be "Next". Any thoughts?? The date ranges for Now and Near could overlap, meaning it is being worked on over a longer period of time and should also reflect as Now.Thank you!!!!

I have 2 linked tables, Tasks and Sub Tasks. I want the Sub Tasks' status to define the status of the Task. I currently have a rollup that makes an array of all the statuses in a given Task's Sub Task. Then I have a formula that reads these arrays and creates a status. ITrying to create a formula that fulfills the following requirements:If all subtasks are "Done", the task status should be "Done".If any subtask is "In Progress", the task status should be "In Progress".If any subtask is "Done" and at least one subtask is "To Do", the task status should be "In Progress".Otherwise, if none of the above conditions are met, the task status should be "To Do".I am not much for coding so I explained this to ChatGPT and it gave me the following code. IF( BLANK({All Sub Tasks- Status}), "To Do", IF( FIND("In Progress", {All Sub Tasks- Status}), "In Progress", IF( AND( FIND("Done", {All Sub Tasks- Status}), FIND("To Do", {All Sub Tasks- Status})

Hi everyone!I want to send email to our customers in which I want them to choose between two options (buttons). "YES" or "NO" depending if they agree with the cost of repair for their product.How can I build this buttons and email so that I can get their choice direct to the AirTable? I already have one single select field with yes/no option. But I don't know what to do next.Thank you for your help!

Hello:I am trying to create a RollUp for A Scoring Process we are undergoing related to our Strategic Plan. I have managed to get everything else to work; however, I am running into a challenge doing a RollUp for two questions.One is a Simple Yes/No Question. I want to get the total number of Yes/No Votes.The second is a Yes/No/Maybe question. Likewise, I would like to get the total number of Yes/No/Maybe votes.I have tried creating conditional formatting that counts IF FIELD=YES, but that is not giving me the total number of 'Yes' when I roll up. I recognize I will probably need five new columns - but I cannot figure out how to get them to populate with the required information.Thanks for any help. 

I struggling to correct a formula where I want the return value to appear based on IF AND statements.Goal I am trying to achieve:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).Here is a short Loom where I walk through what I want to fix: https://www.loom.com/share/82b6cdb91b12403d96fdb047760e01e0?sid=bdca5f77-58d9-478e-bfbd-6395874742dcBelow is my current formula:IF(DATETIME_DIFF(NOW(), {📧 Inquiry received}, 'days')>=90, IF(NOT({🎉 Date Won}),"📞 ",""))What I want the formula to say:If the “inquiry received” date is greater than or equal to 90 days, if the “date won” is empty, and if the “lead score” is greater than or equal to 5, then the “follow-up” column will return a phone emoji.Screenshot with notes:Current formula:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).

HI, this is my code for my payload posting to a table using Google Apps Script: var payload = JSON.stringify({"records": [{"fields": {"OnlineSubmissionLink": [{ "id": linkedRecordID }], // Set the linked record field// "SaleDate": formattedSaleDate,// "SalePrice": donationAmount },"typecast": true}]}); My log says: Constructed Payload: {"records":[{"fields":{"OnlineSubmissionLink":[{"id":"recXE6yQpMi1NyWRx"}]},"typecast":true}]} for my payload, but I'm getting this error: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}} when I attempt to POST the Record ID into the linked record field.  Sorry, I'm no expert so am struggling a bit. Any advice would be ssoooo welcome! 🙏

Hi all,I feel like this question may have a very easy solution, however I have been unsuccessful with my attempts so far. Basically, I have created three interfaces with one or two pages in each. I want to share a couple of my interfaces with some of my team members, and the other interface with my other team members. I am struggling to understand how to accomplish this, such that they do not have access to the other's interfaces.In the sharing options, it gives me the option to share to individual bases via link, however when I test the link i can click back and open the other interfaces (I also tried with another account I can access to test it and the same result happened) I am sure I am missing something. And if there isn't a solution, a work around where I only get one page/interface is acceptable. Thank you,Ben

I'm not normally a scripter, but just spent two weeks trying to put this little routine together and make it work. The script calculates the date one year in the future and uses it to rename a new column in the format MMM'YY.  After loads of trial and twice as much error, I actually got in to work!:Naturally I was really pleased with myself! Now just to apply a trigger. I want it to run on the first of each month. My first idea was to paste it into an automation. But I soon discovered that scripts run from the automation cannot create fields.How frustrating! Why not? Can anybody think of a workaround? Is there a command I can put in the script editor to make it trigger on a regular interval?Any ideas or workarounds gratefully received.

Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be appreciated. TIA. 😊

Hi there: There are two records with to dates, I need to use the DATETIME_DIFF function, but it only works If I have the fields side by side, not in two diferent records. How can I work this out?

TIA - this community is amazing and so helpful when I can't get my head around these more tricky ones. but I am learning more and more! I have a bunch of method steps for our recipes:COOK THE SALMONPat dry salmon with paper towel, remove the skin and cut into bite size pieces, discarding the skin. Add salmon, olives and courgette to the pot. Simmer, gently stirring occasionally, for 5-6mins, or until the salmon is cooked through and all the veggies are tender. Remove from heat. Check seasoning. "MAKE THE AVOCADO DIPCut lemon into wedges. Halve avocado, remove the stone and scoop out flesh with a spoon. Place avocado into a third medium bowl and mash with fork until smooth. Mix in aioli and (1/2 tbsp/1 tbsp) lemon juice. Season with salt, pepper and more lemon juice to taste. Set aside.TIP: If you prefer, add avocado to the salad in STEP 5 and serve aioli on the side. "MAKE THE HERBY VINAIGRETTEFinely chop (half/whole) pack coriander, including the stalks. Add to small bowl with (1

I'm trying to build an IF Formula that seems like it would be straight-forwarded, but is proving to be more complicated than I thought it would be and has got me stumped. Both fields are Lookup fields getting a Rollup value from another table. I started with a basic IF formula, but the problem is it resulted in X $0 values being replaced by the Y value, when I wanted the $0 X value to be returned.IF(X,X,Y) Then I tried to a formula to say if X is equal to or greater than 0, and that worked, but it would not return Y if the X Column was blank. IF(X >=0,X,Y) So, I tried an IF / Or Formula. It still returned the X field correctly, but did not return the Y Field if the X field was blank. (Update: I originally wrote this wrong when I posted. I was trying to say if X is not blank & is equal to or more than 0, return X, otherwise return Y. Also tried with X !="" instead of Blank() - same result).IF(OR(X >= 0,X != Blank()),X,Y) I'm not sure why this is being

I have a fairly niche-type issue that I've not been able to figure out; for context, I've created a check in base optimized for a team of supervisors to check in/out staff using the Airtable mobile app. I have 2 tables linked together, where one represents 1 record for every shift (named "All Shifts"), which is linked to a table (named "BA Data") that houses the staff info of whoever is scheduled for a shift. I would like for my Supervisors to be able to open the linked record (aka "BA Data") while looking at the "All Shifts" table and be able to modify a "Current Location" field and a "Lead Notes" field (both are housed in the "BA Data" table). The navigation to do so seems to work just fine, but when a user opens the linked record from the mobile app, it appears that the Sort is defaulted to newest to oldest fields, in the order they've been modified; I know this because when I converted the oldest field to "Current Location" in order to bump it up to the top, the oldest fi

HiI have two tables Customers and Orders.  They are linked on CustIDI want to be able to find the latest order date (Order Date) for each customerAny ideasThanksMike

I have a base that has a number of tables representing incoming work from different sources (e.g. a jira tickets table, a slack messages table, a spreadsheet process table, a email table).  And I want to combine them into a single 'team workload' table that I can create views in summarising who's working on what type of work item.Airtable's multi-sync feature (https://support.airtable.com/docs/multi-source-syncing) is a great way to do this with 1 drawback - it means I need to create an entirely new base instead of just add a new table to my existing base.Is there any way around this?  I'm not sure why I can't sync/multi-sync within an existing base?  Thanks for any thoughts! 

Anyone have experience with the downgrade process from Enterprise to Teams? We downgraded from Enterprise to Free, and planned to then upgrade to Teams but we have all these deleted users from years ago that somehow showed up on our free plan. I can't upgrade to Teams to remove them because I'd have to pay for the deleted users before I would have access to the feature to delete. Anyone experience this? 

My client has a team of several Creators and one Owner. They want to make an Interface that is only viewable to the Owner. When I create a new Interface and choose not to share with users (I click "Not Now" on the dialogue box shown below), then I go to Manage Permissions, it shows that all Creators have permissions to the new Interface. I can't figure out a way to remove access to Interfaces for Creators. Is this even possible? Or do they need to be downgraded to have permissions set for them? 

I've successfully created a webhook via the Airtable API using the following json: { "notificationUrl": "https://mycallback.app/", "specification": { "options": { "filters": { "dataTypes": [ "tableData" ], "recordChangeScope": "tbla....." } } } } It seems to work in the sense that my callback URL gets called.  Right now all I'm doing is logging the request body that is sent back to my endpoint and it seems to be missing all the important data about what has changed.  This is what I get back: { base: { id: 'app6......' }, webhook: { id: 'achnoA6.....' }, timestamp: '2024-02-22T23:46:02.849Z' } ANy idea what I did wrong or what I should be doing to get the details of what field changed.  I see the change in the UI and I've tried making the change in the UI as well as via code using an Airtable library.  And again, I see the change when viewing in the UI and the l