Pick lists w/ comment

[Glen Forister]

I need a field that is a number that can be used in a graph against time.
To fill that field I would like it to be a quick pick list. That is easy.

The number represents certain conditions which I don’t always remember.
The only way to do this is with a text box describing each number that shows up in the pick list.

Is there a more elagent way to do this within the pick list instead of having those descriptions on the face of the form?

[Daniel Leu]

Hi Glen,

You could use a picklist format like ‘1: Red’, ‘2: Blue’, ‘3: Green’ and then add a field script to extract the value before the column:

function Picklist_Value() {

    const picklist_id = 'fld-xxx';

    const picklist = record.getFieldValue(picklist_id);

    // check that picklist has a value
    if (picklist) {
        // split picklist value and use first element
        const number = String(picklist).split(':')[0];

        // return number
        return Number(number);
    }
}

Picklist_Value();

This script returns a ‘Number’ so you have to set the return type accordingly.

Now you can create your graph using the return value of this script and don’t need to remember the values when using the picklist.

Hope this helps!

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

Cheers, Daniel

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

[Glen Forister]

That sounds possible if I understand it. I’ll play with that.
Thanks.

[Brendan]

I’ve just made a modification to Tap Forms Pro that will extract out the number values from a Pick List attached to a Number field. So you’d be able to setup a Pick List like this:

10 Red
20 Blue
30 Green
40 Yellow
199.23 Unknown

And when you select the value, just the numeric part will be assigned to the Number field.

Attachments:

You must be logged in to view attached files.

[Glen Forister]

Tahnks Daniel.
I tried it and got an error off the bat. What I learned of scripting a year or so ago I’ve forgotten.
======= I typed the following and got this comment.
3/16/26, 4:14:05 PM / !Poop / Condition+
Condition+: SyntaxError: Unexpected identifier ‘Picklist_Value’, line:1
=================
Function Picklist_Value(){
const pickllist_id=’fld-3bf9d801a4334f17815a4e131c3fa83c”;
const picklist=recordxgetFieldValue(picklist_id);

//check that picklist has a value
if (picklist){
//split picklist value and use first element
const number=String(picklist)xsplit(‘;’)[0];

//return Number
return Number(NUMBER);
}
}
==========
So, Q1 – Is that Picklist a reserved word and we can’t use it?
and Q2 – Is the field id # that have there supposed to be another field? I dont think so, I used the field # associated with the field this script is written into (is that correct?).
I guess this will take a while. Thanks.

[Daniel Leu]

There are many typos in your script. Please copy it from https://www.dropbox.com/scl/fi/kxvy7lpsepka5atnd8ymk/picklist_value.txt?rlkey=idzgqadkaba4co05o2x49h87i&dl=0. I already added your field id. So it should run just like this.

Oh, don’t forget to set the return type to number.

I run the script in one of my forms to verify that it works.

Cheers, Daniel

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

[Glen Forister]

First, I couldn’t past into that window so I had to type it in. Then later I discovered pasting from my keyboard doesn’t work, but the edit menu “paste unformatted” does the job. So, pasting your script in did work.

Thanks for the patience. That works just like I wanted. Sorry, I just don’t have time to keep the skills of scripting. Wish I did – it can be lots of fun.

[Author]

Posts