Adding data to fields in currently selected record

[Victor Warner]

I have the following script which writes data from a .csv file to several fields. It does so by adding a new record and then writing the data to the fields. I would like to know how to do so to the currently selected record.

Any help would be gratefully received.

// this imports the Papa Parse script

form.runScriptNamed('PapaParse');

// replace with your field ID's

var date_of_invoice_id = 'fld-1b800a91fac14b329ef47d23c7cdacb0';
var date_paid_id = 'fld-60fa17dec2a24d9588ce4aafa3dccd5c';
var date_of_receipt_id = 'fld-9ed8f17873a642b4a2ee58ff24eba421';
var method_of_payment_id = 'fld-15b719109ab64053a5c46427622f81f5';
var payment_notes_id = 'fld-3a22501b3096443f8f92c6cf6c7e2de5';

function Import_Entries() {
//let filename = "file:///Users/victor/vwdata/data/Notary/client database/not in use/FileMaker/notary/vPaymentDetails.csv";
let filename = "file:///Users/victor/Library/Mobile Documents/com~apple~CloudDocs/filedtoday/vPaymentDetails.csv";

 

let csvFile = Utils.getTextFromUrl(filename);

if (!csvFile) {
console.log("No CSV file?");
return
}

var output = Papa.parse(csvFile);

// abort if there are any errors and log to console.
if (output.errors.length > 0) {
console.log(errors.join("\n"));
return;
}

// read each line
for (let line of output.data) {
var newRecord = form.addNewRecord();
newRecord.setFieldValues({
[date_of_invoice_id]: line[0],
[date_paid_id]: line[1],
[date_of_receipt_id]: line[2],
[method_of_payment_id]: line[3],
[payment_notes_id]: line[4],
});
//var job_completed_id = 'fld-ba0622aac1ea42ff9e5e9272c4314fa7';

//record.setFieldValue(job_completed_id,"Yes");

document.saveAllChanges();
}
}

// Import entries to form "Who" from filename "Whom.csv"
Import_Entries("Notarial Act", "vPaymentDetails.csv");

• This topic was modified 8 months, 3 weeks ago by Victor Warner.

[Daniel Leu]

To refer to the current record just use record. To set a value, it would be record.setFieldValues();.

 

[Victor Warner]

Daniel,

Thank you for the information.

Victor

[Author]

Posts