Skip to main content
Solved

Linking Multiple Records via Automation

S
Forum|alt.badge.img+2

Hello,

I want to be able to import transactions from Quickbooks, and link those transactions to a Client record from another table (Clients) in the base (relational).

The first issue that I ran into was having an automation update multiple records at once. It seems the solution to this is a script.

I modified one that seemed popular here to the following:

let config = input.config()
let records = config.QBRecords //.step2Records must match the Name field of the input field.
let table = base.getTable("Quickbooks 7-14-22 YTD"); // Replace with your table name.
for (let record of records) {
    await table.updateRecordAsync(record, {
      "Client": [{id: config.clientRecord}]
    })
}

However, it’s throwing an error: “Error: Field “fldOyEuNcD7vGj42h” cannot accept the provided value.
at main on line 5”

Can anyone help with this? I have a feeling it’s something dumb… but I can’t seem to fix it.

Thank you in advance.

Script:

Automation:

Quickbooks table:

Best answer by Kamille_Parks11

The “list of record ids” is an array, even if its just one value. You need to adjust your script to handle the array.

"Client": config.clientRecord.map(x => ({id: x}))

^ that should do it. It takes each record ID from the array and formats it the way airtable needs it (an object with a single key-value pair).

View original
Did this topic help you find an answer to your question?

2 replies

Kamille_Parks11
Forum|alt.badge.img+25

The “list of record ids” is an array, even if its just one value. You need to adjust your script to handle the array.

"Client": config.clientRecord.map(x => ({id: x}))

^ that should do it. It takes each record ID from the array and formats it the way airtable needs it (an object with a single key-value pair).

S
H
2 people like this
  • S
    Snoochy_boochie
  • H
    Hendrik_Yang
S
Forum|alt.badge.img+2
Kamille_Parks11 wrote:

The “list of record ids” is an array, even if its just one value. You need to adjust your script to handle the array.

"Client": config.clientRecord.map(x => ({id: x}))

^ that should do it. It takes each record ID from the array and formats it the way airtable needs it (an object with a single key-value pair).


You’re amazing… this worked perfectly. Thank you!

Reply


Most helpful members this week

Terms & Conditions