How to display the row occurrence labels dynamically.

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
manishcspro
Posts: 67
Joined: June 26th, 2017, 2:15 pm

How to display the row occurrence labels dynamically.

Post by manishcspro »

I want to display the row occurrence labels dynamically.
I have 294 items for which data is to be collected. These 294 items are distributed among 23 tables or departments.
Each 7 digit item code has an starting 2 digits for 2 digit table/department code starting from 01 to 23.
I want to display the items and their occurrence labels only for selected tables or departments.
For example if I chose Table "01" in ID dropdown then items having item code with prefix 01 will display.
How to implement the above method.
The table having item codes and their labels is attached for the reference.
Please guide me...
Attachments
occurenceLabels.xlsx
(22.37 KiB) Downloaded 125 times
sherrell
Posts: 397
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: How to display the row occurrence labels dynamically.

Post by sherrell »

Hi Manish,

You'll basically want to use the valueset object.

You'll need 2 dictionary variables; 1 for the parent/top level codes (1-23), then a second for the subcodes. Based on the person's selection of the first, you'll restrict what they see in the 2nd variable by using setvalueset. See this post for links to other questions about this. In case you aren't aware, you can just copy and paste your Excel tabsheet values into the 2nd variable's valueset. No need to retype.

https://www.csprousers.org/forum/viewto ... 06&p=14082


Sherrell
Last edited by sherrell on August 17th, 2021, 12:33 pm, edited 1 time in total.
manishcspro
Posts: 67
Joined: June 26th, 2017, 2:15 pm

Re: How to display the row occurrence labels dynamically.

Post by manishcspro »

Thanks a lot..
sherrell
Posts: 397
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: How to display the row occurrence labels dynamically.

Post by sherrell »

Manish, I just changed my response to you above (old habits die hard!). I meant to say you'll want to use the valueset OBJECT, not the setvalueset FUNCTION. The latter has been deprecated. Sorry for the confusion.
Post Reply