Skip to main content

Solved

7384 Topics
C
CarboneQuebecNew Participant
asked in Development & APIs
PATCH Request to Airtable using Node-RED gives "Could not find field "fields" in the request body"

Hi, I don't have much experience with API requests. I am trying to understand how it all works. I am currently using Node-RED (visual Node.js) to process the requests. I was able to complete a GET request and i'm now trying to do a PATCH request to update data in Airtable.I get the following error message when trying:type: "INVALID_REQUEST_MISSING_FIELDS"message: "Could not find field "fields" in the request body" Here is the schema in question:I am unsure where the API is expecting the request body.Here is my test JSON:{    "fields": {        "CCISF": 5,        "CORAMH": 5,        "RJCCQ": 5    },    "typecast": true} Do I have to include all fields present in the table or only those i wish to update with the PATCH request? Thank you.

924
C
Kim_Trager1
Kim_Trager1Brainy
asked in Formulas
How to join multiple rollups into one big array with only unique items?

I'm using my airtable to attached keywords images. I have one big keywords table with multiple categories of different keywords. Then i have multiple linked columns to the different categories. However some of the keywords overlap into different categories.So I thought I could rollup all my linked columns and do something like this:  ARRAYUNIQUE(ARRAYJOIN(ARRAYJOIN({RollUp1}) & IF({RollUp2}, ',' & ARRAYJOIN({RollUp2})) & IF({RollUp3}, ',' & ARRAYJOIN({RollUp3})))) However I still have duplicates of keywords in my final array. Does anyone know how I can join my rollups and then filter out all the duplicates? 

18210
ScottWorld
Nikiska
NikiskaInspiring
asked in Base Design
Create a field that is 6 months after the last date entry in that row

Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mid term review and an annual review. My question is...Is there a script/formula that takes the last date entry in Person A's row and creates a date that is 6 months after it so I can then run an email automation 2 weeks prior to that date to remind Person A  their review is coming up. In my example below (DATE FORMAT IS EUROPEAN) As you can see Person B has been employed longer so they are further down the chain they have just had their Y2 annual review and so their Y2 mid term would be 6 months from then (ie 22/7/2024).Person A's however is still in Y1 and has just had their mid term so they are due their Annual review on 6/5/2024.So each row will be a different person who will have different dates as they will be at differen

253
Nikiska
A
Airtable_Padaw1Participating Frequently
asked in Other Questions
Duplicating a table with an image field

Hello, we duplicated one table from a base to a new base and a field that originally contained images got converted into a text field that contains the file name of the pictures and a URL. Is there a way to do duplicate the table without this happening? 

197
A
S
Sobhy_SonbolNew Participant
asked in Automations
Actionable messages in slack updating field with text

Hello Everyone, I am trying to create an automation that sends draft social media posts for approval. The problem I am running in to is being able to reply to these actionable messages in Slack with text that will update an airtable field. So basically here is how the work flow goes. When a new post is created and is in draft it will send an actionable message to a slack channel with two buttons. The first button is "Approve" and the 2nd button is "comment". If the comment button is clicked I would like the slack user to be able to enter some text that will then update a field in airtable. I have been able to get the approve button to work but when the comment button is selected I do not get the option in slack to enter text. How can I solve this problem. I would appreciate your input. Thank You 

532
S
N
Nate99New Participant
asked in Automations
Error while running "Update Record" automation

Should be a simple automation so I'm certain it's user error but I can't find my mistake.I have a date value. When that date value is updated I want a single-select record to automatically update to "Date Changed"Use case is to generate a weekly email via a separate automation that shows all rows that had a changed date in a given week.My error is "Received invalid inputs."Please let me know if you need more details/context and thank you in advance. 

102
N
S
sam-lsf-lstParticipating Frequently
asked in Automations
Automations: Update record when google sheets row is created based on REF

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

1295
ScottWorld
J
JohnDoeInspiring
asked in Other Questions
Billing question

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

61
J
C
Cap_RapsNew Participant
asked in Automations
Auto script to manage interface collaborators

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. 

414
C
S
SHUGNew Participant
asked in Automations
I need help with script to merge Multiple rows with same "User ID".

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

1075
M
M
mmj-916New Participant
asked in Interface Designer
Interface Form - Using Date Field results to help filter Linked Record Options

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?

173
M
airballer86
airballer86Known Participant
asked in Formulas
workback from date field using Dateadd, Workday, and a Holiday String

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 

154
airballer86
D
daniel_hannahNew Participant
asked in Formulas
Returning values of concatenated multiselect fields in an unordered list

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?

164
D
K
KGBParticipating Frequently
asked in Formulas
Date Ranges

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!!!!

324
K
L
leannawisenerNew Participant
asked in Formulas
Using Formulas to create a Task status based on status of Sub Tasks

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})

493
Alexey_Gusev
S
SpelaUKnown Participant
asked in Automations
How to build email with two buttons (choices) and receive choice to AT?

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!

2048
ScottWorld
S
sundevil282New Participant
asked in Other Questions
Counting Yes/No in Roll-Up

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. 

313
TheTimeSavingCo
khoner01
khoner01Participating Frequently
asked in Formulas
Using IF, and AND and OR formula using emojis

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).

182
khoner01
R
RichardLGNew Participant
asked in Development & APIs
Help with payload and Record ID

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! 🙏

172
R
N
ninjaben53New Participant
asked in Interface Designer
Sharing different interfaces with different people

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

2357
Dan_Montoya
P
Paul_ThompsonKnown Participant
asked in Automations
Triggering CreateFieldAsync script by time interval

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.

195
P
H
hauwiInspiring
asked in Formulas
Airtable formula error in 'search records' module in Make.com

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. 😊

142
H
J
Jorge1New Participant
asked in Base Design
Data estructure

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?

104
J
J
jm22New Participant
asked in Formulas
splitting content in long form text in a formula

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

4514
Justin_Barrett
M
MettaSongKnown Participant
asked in Formulas
IF Formula Causing Trouble with Blank and Zero Amounts

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

1978
M

Badge winners

Show all badges
Terms & Conditions