AnsweredAssumed Answered

A new question for the experts having problems finding the correct way to use a value list with text and number to then show only a fixed number in the fiels

Question asked by signmaker on Nov 28, 2017
Latest reply on Nov 28, 2017 by signmaker

Like • Show 0 Likes0
Comment • 3

Hi All

I need to create various value lists with a text and number description(all are unique), I then need when a user selects a description it will only display the number (not the text) in the same or a different field.

example "03 bla bla bla" , would only display 03 after selecting in the value list.

I have used replace text and substitute text but I'm not sure if that's the correct method , also I cant get either to work on more than 1 value at a time in the calculation.

No one else has this question

Outcomes

signmaker Nov 28, 2017 10:10 AM

Should be fields no fiels by the way hahaha too much tequila last night I think.

Actions

philmodjunk Nov 28, 2017 10:37 AM

Use a drop down list instead of pop up menu.

Or use a pop up menu and show both fields.

Either way, the value list would be “use values from field” with the first field the number Value.

Actions

signmaker Nov 28, 2017 10:40 AM

THANKS FOR THAT WILL GIVE IT A TRY.

WHAT I ENDED UP WITH WAS

Substitute(MAIN LIST USO in text;"AB";"What you see is what you get.") & Substitute(MAIN LIST USO in text;"AA";"What you see.")

Will give the value list another go though as that seems easier

Actions

3 Replies

signmaker Nov 28, 2017 10:10 AM
Mark Correct
Correct Answer
Should be fields no fiels by the way hahaha too much tequila last night I think.
Like • Show 0 Likes0
Actions
philmodjunk Nov 28, 2017 10:37 AM
Mark Correct
Correct Answer
Use a drop down list instead of pop up menu.

Or use a pop up menu and show both fields.

Either way, the value list would be “use values from field” with the first field the number Value.
Like • Show 0 Likes0
Actions
signmaker Nov 28, 2017 10:40 AM
Mark Correct
Correct Answer
THANKS FOR THAT WILL GIVE IT A TRY.
WHAT I ENDED UP WITH WAS
Substitute(MAIN LIST USO in text;"AB";"What you see is what you get.") & Substitute(MAIN LIST USO in text;"AA";"What you see.")
Will give the value list another go though as that seems easier
Like • Show 0 Likes0
Actions

A new question for the experts having problems finding the correct way to use a value list with text and number to then show only a fixed number in the fiels

Outcomes

Related Content

Recommended Content