Search Results for 'script'

[Daniel Leu]

Script fields are very powerful vehicles to fetch, format, and process data from different forms, among others.

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[Martin Inchley]

That’s very helpful, Daniel. Because I came to Script Fields after first experimenting with Form scripts and the TapForms JavaScript API, I have up until now been using them to achieve an action rather than present a result.

[Daniel Leu]

You can do both with a field script.

1. Display a field from a linked form without it obviously being enclosed within the “Link to Form” field that was used to set up the link. I want it to appear like any other field on a layout.

var child_link_id = 'fld-c22501cc3910474aa1c59387fde30d82';
var child_name_id = 'fld-8b8f3b0cd59b4b4c9180a8903685e7ee';

var childs = record.getFieldValue(child_link_id);

// show first child
childs[0].getFieldValue(child_name_id);

First I define the child link field id (in the parent form) and the name field id from the child form. Next I fetch all childs. Assuming I only have one child record, I just fetch the name of the first record found.

If there is more than one child record, I can simply loop over them:

// combine child names
var child_names = [];
for (child of childs){
	child_names.push(child.getFieldValue(child_name_id));
}
child_names.concat();

2. Display a field that is two links away. Form A links to Form B. Form B links to Form C. I would like to display a field from Form C on a layout associated with Form A.

If I want to get data form a child’s child form, eg grandchild, the process is very similar. Following script just returns the name of the first grandchild record from the first child record:

var child_link_id = 'fld-c22501cc3910474aa1c59387fde30d82';

var grandchild_link_id = 'fld-9d399af0d72b4c8fbc3cb95fa6127203';
var grandchild_name_id = 'fld-9485e9dd29474745acee87bb3a60fff5';

var childs = record.getFieldValue(child_link_id);

// get grandchildren from first child
var grandchildren = childs[0].getFieldValue(grandchild_link_id);

// get name of first grandchild
grandchildren[0].getFieldValue(grandchild_name_id);

To get the ids for the granchield fields, I opened a field script in the child form and copied the necessary entries over to the field script in the parent form.

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[Stephen Abshire]

I have a script field that is contained within a table field. Since there are ‘n’ rows in this table and the script executes within each row how do I get the index number of the current row so that I can use it within the script?

[Stephen Abshire]

Thank you and appreciate the code sample. This is actually what I was working on myself but I was having issues that you answered in another thread regarding setting field values that trigger scripts and using the third parameter of ‘false’ when writing field values. Once again appreciate the help!

[Simon Inchley]

Hi there. I trying to create a check box field (called “paid”) that then generates todays date in another field (called “date paid”) when checked. I used a calculation field for the “date paid” field and wrote this:

if( PAID =”1″;TODAY();0)

I turned the calculation result type to “date”. On the “date paid” field I turned the default date to dd/mm/yyyy which gets rid of the seconds.

It works great except for it shows 01/01/1970 when the “paid” field is unchecked, which I understand is to do with how when is calculated from time.

So my question is: is there any way for the calculation to leave a blank field if the date field is not checked, just giving me a date for when I check it? Or do I have to do this through scripting?

[Sam Moffatt]

Reposting because my original reply got flagged as spam.

I’m uploading a sample form template that shows what I mean. It has two fields in it, a text field and a script field. I also included the form logger script with an update that prints out field ID’s in Javascript variable syntax. That’s used at the top top populate the field ID’s because by default the script editor doesn’t expose script fields. I also use this syntax because it includes the form name which makes it easy to keep track of variables in larger documents with lots of forms and lots of fields. There’s a commented line to ensure that Tap Forms registers this script to the field that works even if the line is commented out. I then grab the text field and the contents of the script field.

For the script field, I check to see if it is set and provide a default dictionary if it isn’t set already. If it is set to a value, I assume it’s JSON and parse it back into an object.

Then at that point it’s a quick comparison of the deserialised JSON payload and your new one. I added a message in so you can see a note, always useful after the fact for some of these scripts even if you hide the field by default, you can unhide it to see what it has in it.

Lastly the script field ends with JSON.stringify to return a JSON string as the fields contents. This object can obviously contain what ever you want in it so if you have multiple values instead of setting multiple fields, you just return a value at the end of your field script with the data you need to keep track of from each execution.

Sample execution:

Field script:

// Script Field State
var script_field_state_formID = "frm-86fd53d1f9ab47548636fc2e2d1d0d35";
var script_field_state__main_field_fldID = "fld-2177d4bf8500482d8fc6242faa80c5e6"; // text
var script_field_state__watcher_fldID = "fld-7e997368aef740f68f126d2c8509d148"; // script

// Make sure the field is watched to pick up changes.
//var main_field = record.getFieldValue('fld-2177d4bf8500482d8fc6242faa80c5e6');

var main = record.getFieldValue(script_field_state__main_field_fldID);
var state = record.getFieldValue(script_field_state__watcher_fldID);

if (!state)
{
	state = {'previous':undefined,'message':'Initial setting'};
}
else
{
	state = JSON.parse(state);
}

if (state['previous'] != main)
{
	state['message'] = `Field value changed from '${state['previous']}' to '${main}'`;
	state['previous'] = main;
}

JSON.stringify(state);

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

It is possible that your script can be re-entrant if it watches multiple fields and you call setFieldValue on one of those fields. There is a third parameter to setFieldValue that controls if scripts are executed, flip it to a falsy value and scripts won’t be executed from that setFieldValue invocation. I used to write my own guards because Javascript instance is reused so you can share variables between the other scripts triggered by setFieldValue. Photo fields can also exhibit the same behaviour but I there isn’t a flag to disable them. For those I try to ensure that the field ID is obscured to prevent Tap Forms from triggering my script field for it.

[Stephen Abshire]

I am writing a script that touches (read/write) several fields on the form. I am guessing at this point but I think that as each of these fields are touched within the script they are invoking the script again on their own which is causing strange results. Can anyone confirm that this is either possible / not possible and if it is possible how can I stop this behavior so that a script is only executed when one of the fields that are being touched invokes the script?

[Sam Moffatt]

I use a hidden field to save state of what fields used to be and then compare the new field value against the old one. There is no before change data so you have to grab it yourself.

I also have another technique where with the script field, you can return a value. So you can use the script field itself to store the previous state and by accessing the script field with getFieldValue, you can then get at the previous value. When you finish up your script field, you return the previous value. If you have a few different values you want to track, you can use JSON.stringify and JSON.parse to serialise and unserialise the field value into an object in JSON.

Hopefully that helps.

[Daniel Leu]

Richard, is your ‘Notes’ field of type text or note? Brendan’s description is for a note type field.

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[Brendan]

If you have a Script field and you use record.getFieldValue(field_id) within the script, Tap Forms will add that field_id to a watch list. So when the value of that field changes, the script will execute.

[Victor Warner]

I am having difficultly making this work for me – would Brendan or another user be able to provide a simple worked example how this operates?

I am finding JavaScript difficult and general guides are not, at least for me, helping in understanding how to apply much of the example snippets that Tap Form provides.

Any help would be very gratefully received.

[Stephen Abshire]

Greetings,

Is there a way that I can detect when a text field that uses a pick list has had a value change? Say for example it used to be ‘ABC’ and now it is ‘DEF’. How can I catch when the value has changed so I can script it? I suppose a hidden field could be used as a form of global variable but that seems like a hack.

[Stephen Abshire]

Got it working just wrote a script for it.