Script to Collapse Section

[Tim H]

I a real beginner with scripts in Tap Forms so am finding it difficult to collapse a section based on the contents of a field. Basically I’d like to collapse a section if another field is empty.

I see from Tap Form’s JavaScript API there is something that looks like it should close a Section Heading type field (field.isCollapsed = true;) but when editing a form script the Section Heading type field I want to control does not appear in the list of Available Fields. I was able to get the field ID from the Fields List but still cannot programmatically collapse the section.

I’d appreciate any tips on getting this to work. Thanks
–
T.

[Brendan]

Hi Tim,

This code should do the job:

function Collapse_Section() {
	var section_id = 'fld-7f00598612814de980cb7250d8391570';
	var sectionField = form.getFieldWithId(section_id);
	sectionField.isCollapsed = !sectionField.isCollapsed;
}

Collapse_Section();

[Brendan]

The example above just toggles the section opened and closed each time you run the script. You will probably have different logic.

[Tim H]

Hi Brendan,

I was able to use your bit of code and get the Section to collapse based on whether or not another field was undefined. It works great thank you!

Now is there a way to get this script to “auto-run”? I’ve saved the script as a “form script” i.e. it’s not a script type field in the form but I have to manually run it each time. Ideally I’d like the script to run each time a different record is displayed i.e. collapsing/un-collapsing the section while browsing records.

Thanks again for your help.
–
T.

[Tim H]

Thinking about this a bit more…

Is there a way to auto-run a script based on a saved search? For example lets say I have saved a search that utilizes a rule that a particular field be non-empty. Additionally I have a saved search with a rule that specifies a field to be empty. Depending on which saved search I’m browsing records with, the script would “fire” either collapsing or expanding the section heading.

Basically, I’ve got a long default form with a section containing a bunch of fields that I’d prefer not to see (collapse section) unless there is information in one of the fields within the section.

Thoughts/ideas?
–
T.

[Daniel Leu]

Idea: how about assigning a keyboard shortcut to a script?

[Tim H]

Hi Daniel,

Thanks for the idea. I looked into it and it’ll work but I’d prefer something more “automatic” while browsing records. I could also create another form with a subset of fields but I’m trying to avoid a bunch of forms that only differ by a few fields. I’m holding out for an “automagic” way to collapse/expand a section. :)
–
T.

[Brendan]

Scripts don’t run when you’re just browsing records. Imagine you had a script that took a long time to execute and you ran it for every record that’s displayed. It would make browsing miserable.

So there’s no automatic way of triggering a script when clicking on a Saved Search. You would have to refresh the records list which would run every script on every record displayed.

[Tim H]

Hi Brendan,

Understood, hmm how about a feature suggestion. Save the “state” of section(s) collapsed/expanded in the default single-column list view with a saved search. Similar to how Tap Forms saves the column layout in a multi-column list view for each saved search.

Thanks so much for the help and listening. Tap Forms is a great product that I really enjoy using. It makes keeping track of my data soooo much easier.
–
T.

[Tim H]

Or, maybe save a specified single-column layout with a saved search.
–
T.

[Brendan]

The isCollapsed state property lives on the field itself, which has no direct relationship to the Saved Search. But perhaps in a future version I could make an association there.

Happy New Year!

[Author]

Posts