topic Re: Create a field from a list of variables in App Development

Create a field from a list of variables

Domino3145 — Thu, 25 Jan 2024 10:11:57 GMT

Hi all,

I'm trying to convert a list of 6 number variables I've generated in script into a single field so I can use a Rank() function on them in the frontend.

Say I have: v1, v2, v3, v4, v5, v6. How do I go about converting this into a field that I can perform functions like Rank(), FieldValue() etc. on?

Re: Create a field from a list of variables

Digvijay_Singh — Thu, 25 Jan 2024 14:12:18 GMT

Not sure of your use case but check if you need something like below -

let V1 = 1;
let V2 = 2;
let V3 = 3;
let V4 = 4;
let V5 = 5;
let V6 = 6;

table:
Load * inline [
Data
$(V1)
$(V2)
$(V3)
$(V4)
$(V5)
$(V6)
];

Re: Create a field from a list of variables

Domino3145 — Thu, 25 Jan 2024 17:04:28 GMT

Hi,

Thanks so much for the reply, thats mostly working out great!

My only issue now is if two values are the same, one is lost in Load * Inline

It seems to be returning distinct values only, any ideas on how I could get around this?

Thanks again

EDIT:

Figured it out, thanks for the help!