
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2023 08:33 AM - edited ‎Jul 17, 2023 08:34 AM
Hello
The need is quite simple : portfolio management -> based on the value of a field, I want to assign a record to a collaborator / if project is in a list of regions, then it is assigned to toto.
Following lot of examples, and assembling pieces of codes (i'm not dev), i came with this :
// set the table
const table = base.getTable("Saisons")
// get the record from the trigger
const config = input.config()
const trigger = config.triggerID
console.log('trigger',trigger)
const allrecords = await table.selectRecordsAsync()
const record = await allrecords.getRecord(trigger)
console.log('record',record)
// get the formula value
const region = record.getCellValue("Region (from Dpt-Reg) (from Bénéficiaire)")
console.log(region)
if (['Normandie','Bretagne','Hauts-de-France','Pays de la Loire','Centre-Val de Loire'].includes(region))
{
let update = await table.updateRecordAsync(record,
{
'Suivi': 'toto1@ds.org'
})
else
if
(['Ile-de-France','Corse','Auvergne-Rhône-Alpes','Provence-Alpes-Côte d\'Azur'].includes(region))
let update = await table.updateRecordAsync(record,
{
'Suivi': 'toto2@ds.org'
})
else if
(['Occitanie','Nouvelle-Aquitaine'].includes(region))
let update = await table.updateRecordAsync(record,
{
'Suivi': 'toto3@ds.org'
})
else if
(['Grand Est','Bourgogne-Franche-Comté'].includes(region))
let update = await table.updateRecordAsync(record,
{
'Suivi': 'toto4@ds.org'
})
console.log(update)
However I still get an error and the "Assignee" type field is not updated.
Could you please provide help ?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2023 04:52 PM
Hi @Support_IT ,
For user fields, creation and update require ID specification.
This document may be helpful for information on collaborative users
Collaborator - Airtable Scripting
Cell write format
TYPEDEF
{
id: string,
}
Cell values & field options - Airtable Scripting
