Add record and update values in tables

[Ray Robillard]

I have a movie database in which I’d like to keep an history of every time I watch my movies.  I have a field in which I save the last viewing date.  With a script, I was hoping to copy this value to an history table field.

So far, I am able to get the current watched date (console.log shows that I am ok there), add a blank record to my table (I can see that when I run the script manually) but I am at a loss to update this newly added record and trigger the script automatically.

Here’s the script :

function Update_Last_Viewed_Date() {

     var watched_date_id = ‘fld-0d50c9c744b14f89bcfcaa1295650845’;

     var date_to_log = record.getFieldValue(watched_date_id);

     var viewings_id = ‘fld-edf6c517ee814c059b9abe34846eb65c’;

     var newRecord = record.addNewRecordToField(viewings_id);

     var date_id = ‘fld-da18c2d927f443a3a5cac5b35f705aff’;

     record.setFieldValue(date_id, date_to_log);

     document.saveAllChanges();

}

Update_Last_Viewed_Date();

How can I update the recently added record ?  And, most importantly, how do I trigger this script ?  I read that it should be triggered automatically since I used “getfieldvalue” of the last viewing date.  But it doesn’t.  If I input a new value in that field, it doesn’t call the script (because no blank record is added to the table).

I added screen captures to better explain what I am trying to do.

Thanks  in advance !

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

With addNewRecordToField() you receive a new record object. Now use this to set the values like newRecord.setFieldValue(date_id, date_to_log).

[Ray Robillard]

newRecord.. Of course !!  Thanks, new record added and contains the desired value.

 

Now, how can I have this script triggered automatically ?

[Daniel Leu]

Make it a field script instead of a form script.

[Ray Robillard]

Got it, thanks!  It’s working now, but there seems to be a bug, or something, the script is executing twice, resulting in two rows being inserted in the table, with the same values (the date I input).  Here’s my script :

 

function Update_Last_Viewed_Date() {

    var watched_date_id = ‘fld-0d50c9c744b14f89bcfcaa1295650845’;
    var date_to_log = record.getFieldValue(watched_date_id);

    var viewings_id = ‘fld-edf6c517ee814c059b9abe34846eb65c’;
    var newRecord = record.addNewRecordToField(viewings_id);
    var date_id = ‘fld-da18c2d927f443a3a5cac5b35f705aff’;

    newRecord.setFieldValue(date_id, date_to_log);

    document.saveAllChanges();

}

Update_Last_Viewed_Date();

I checked to make sure, the script exists only in one entry, amongst the list of fields.  I also did different tests (empty viewing history list, list with one date already existing, quit and relaunch Tap Forms) and every time I input a new viewed date, it gets inserted twice.

Am I doing something wrong ?

Attachments:

You must be logged in to view attached files.

[Ray Robillard]

Saw your explanations on this thread, but it didn’t work for me.  I was able to change two var for const with getId(), and now the script won’t auto execute…

 

Source : https://www.tapforms.com/forums/topic/pre-processing-field-entry/

function Update_Last_Viewed_Date() {

    const watched_date_id = form.getFieldNamed(‘Watched date’).getId();

    var date_to_log = record.getFieldValue(watched_date_id);

    const viewings_id = form.getFieldNamed(‘Visionnements’).getId();

    var newRecord = record.addNewRecordToField(viewings_id);

    var date_id = ‘fld-da18c2d927f443a3a5cac5b35f705aff’;

    newRecord.setFieldValue(date_id, date_to_log);

    document.saveAllChanges();

}

Update_Last_Viewed_Date();

If I execute it manually, I get one row inserted with the correct value.

[Ray Robillard]

Ok, found the bug.  My initial script works perfectly.

If you input the date manually (with the keyboard), the script is called twice.  If you use the date picker, however, it’s only executed once.

Where do I file a bug report ?

 

[Daniel Leu]

I just tried with my own script and it works as expected:

function Update_Table() {
console.log("Add entry");

const table_id = "fld-xxx";
const table__date_id = "fld-xxx";
const table__name_id = "fld-xxx";

const name_id = "fld-xxx";
const date_id = 'fld-xxx';

let date = record.getFieldValue(date_id);
console.log("   Date: " + date);
let recTable = record.addNewRecordToField(table_id);
recTable.setFieldValue(table__date_id, date);
document.saveAllChanges();

}

Update_Table();

Using double quotes prevents the field script to be executed.

• This reply was modified 9 months, 4 weeks ago by Daniel Leu.

[Ray Robillard]

With my current script :

function Update_Last_Viewed_Date() {

var watched_date_id = ‘fld-0d50c9c744b14f89bcfcaa1295650845’;

var date_to_log = record.getFieldValue(watched_date_id);

var viewings_id = ‘fld-edf6c517ee814c059b9abe34846eb65c’;

var newRecord = record.addNewRecordToField(viewings_id);

var date_id = ‘fld-da18c2d927f443a3a5cac5b35f705aff’;

newRecord.setFieldValue(date_id, date_to_log);

document.saveAllChanges();

}

Update_Last_Viewed_Date();

The update works fine, except when I enter the date manually, the script is fired twice.  See the video.

To me, this is a bug.

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

Something for @brendan to look at. He’s the developer, I’m just a user. Can you share your document? Maybe send it to support@tapforms.com or attach it here.

[Ray Robillard]

I will sent a shared link to support@tapforms.com, the archive file being 126.6 MB.

 

Thanks !

[Brendan]

Hi Ray,

Sorry I haven’t had a chance to look at the file you sent me just yet. But I will.

Thanks,

Brendan

[Ray Robillard]

It’s ok because there’s a functional workaround, take all your time.

[Author]

Posts