Re: List of IDs CreateRecordsASync

Rose_Haft1 · ‎May 01, 2022

Hi there - How is it possible to add a list of IDs into a createrecordasync function?

For instance, we have:

id_array: [recK0FKsUDicD8Lar,recP4uFoqMq9qJquY,recudo4XILtrW5IYd]

const table_Output = base.getTable(“Output_Results”)
table_Output.createRecordsAsync([
{fields: {
Client: [{id: clientID}],
Symptom: [{id: {id_array}]}
}])

where we replace id_array with the actual array

Thanks!

Alexey_Gusev · ‎May 05, 2022

I would use mentioned function ‘map’, which loops through array of IDs and returns array of objects like {id: recordID}

const symptom=id_array.map(recordID => ({id: recordID}))
const toCreate={fields: {Client: [{id: clientID}], Symptom: symptom} }

Rose_Haft1 · ‎May 16, 2022

Thanks @kuovonne and everyone. It is working:

kuovonne · ‎May 16, 2022

Glad you got it working. Do you mind sharing what specifically solved your issue? (It can be hard to identify the key concept in an entire base share.) This could help anyone else with a similar issue who later reads this thread.

Rose_Haft1 · ‎May 16, 2022

@kuovonne

Here is the code I used. It worked when I did what you asked. I originally thought you meant to do the mapping in the loop, so it wasn’t working but it worked when I put it in the createrecords command:

var t_links = base.getTable("Table 1")

var t_links_aw = await t_links.selectRecordsAsync

var t_table = base.getTable("Test linking")

var t_table_aw = await t_table.selectRecordsAsync

var arr_id = []

arr_id.push("recmi56Y9WQiRd3B5")

arr_id.push("recOQdZvyp7AKDOFm")

arr_id.push("rec4cHGYeA1S6p9y1")

t_table.createRecordAsync({

    Name: "This is a name",

    linked: arr_id.map(recordID => ({id: recordID}))

    })