The solution which was found collaborating with @cwlind was a Bot which activated an App Script. Sample Code below. Many thanks to Clark for his continued help in my pursuit of solutions.
Process:
A Form is filled out and submitted from Table B
The addition of a row in Table B activates a bot and the script to update a specific column in a specific row in Table A.
function approval_date_process(tableId,recordId, newValue) {
var linkedRecordName = 'tables/' + tableId + "/rows/" + recordId;
var columnName = 'Approval Date';
var newValue = newValue;
update_record( linkedRecordName, columnName,newValue);
}
//no changes below this line
function update_record(recordName, columnName, newValue){
Logger.log('update:', recordName, columnName, newValue);
// We need to pass along an object that specifies the column we want to
// update, and what the new value of the column is.
var updatedColumnValues = {};
updatedColumnValues[columnName] = newValue;
;
// We call the Tables API using the Area120Tables Apps Script bean.
var response = Area120Tables.Tables.Rows.patch({values: updatedColumnValues}, recordName);
Logger.log("response:" + JSON.stringify(response)); // Log the response
}
and Job Done.
LinkedIn
Twitter
