Use a Cell Value as Input

[pablogomez]

Hello, I am starting with Airtable Scripting.

I need to use the content of two cells as input text for a function that formats the text in a specific way.

Using this way I only get the value of the first row [0], but this needs to work for every row. It is triggered once a row is added and/or modified. 

if (record && record.records.length > 0) {
  const inputText1 = record.records[0].getCellValueAsString("Index"); // Replace with the actual field name
  const inputText2 = record.records[0].getCellValueAsString("Script"); // Replace with the actual field name

  // Combine the content of the two cells
  const inputText = inputText1 + "\n" + inputText2;

  const jsonOutput = convertToJSON(inputText, sentencesPerSection);​