Appsheet Formula in GScript JSON

[tingtingandrea]

Hi all,

Does anyone know if it’s possible to have an appsheet formula in a google script when invoking action:Add? I would like to have extractemails() for my var senderDetails.

Thanks

Here’s my payload:
var body = {
“Action”: “Add”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”,
},
“Rows”: [
{
“Communication Method”: “Email”,
“Communication”: bodyContents,
“Thread ID”: threadID,
“Message ID”: ID,
“Reply To”: senderDetails,
“To”: receiverDetails,
“CC”: CCDetails,
“BCC”: BCCDetails,
“Subject”: subjectText,
“Sent timestamp”: dateTime,

}
]
};