Skip to main content
Solved

Use string variable for table.updateRecordAsync

  • March 1, 2021
  • 2 replies
  • 40 views

Forum|alt.badge.img+8

Is there a way to tell table.updateRecordAsync what field to update with a variable? I have a table that tracks the date a person receives multiple trainings. Each training has a date field. I’m able to hard code the field in table.updateRecordAsync, but I haven’t figured out a way to do it with a variable, even a string type variable. This would allow me to have one script where one could select the training to update, rather than a script for each training. Here is my code:

await recordTable.updateRecordAsync(record,{
    '*INSERT VARIABLE HERE': date
});

I also tried using the usual javascript way of inserting variables into strings like this:

await recordTable.updateRecordAsync(record,{
    `${fieldString}`: date
});

This just gives me lots of errors.

Best answer by kuovonne

await recordTable.updateRecordAsync(record,{
    [fieldString]: date
});

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • Answer
  • March 1, 2021
await recordTable.updateRecordAsync(record,{
    [fieldString]: date
});

Forum|alt.badge.img+8
  • Author
  • Inspiring
  • 21 replies
  • March 1, 2021

Thanks, @kuovonne! That did the trick!