Re: Dependent Dropdown Question

NCD · 02-25-2022 05:35 PM

Hi,

I made both Artist Name and Song Name a Enum, and a Dependent Dropdown.

How do I go about, if I wanted the Album name to pop up in parentheses next to each Song Name in the same box, or shows the album name if I hover the cursor over it?

TeeSee1

I don't think that functionality is available (I like to know if I am mistaken..)

What is your intention? Just show the user the album name?

A workaround is a virtual col.

I think it is both AppSheet's strength and weakness that its functionality is more or less limited.

If one wants absolute customizability, one needs to go with other solutions, which most likely would require a lot more coding.

Just my opinion.

Happy NO-Coding! 😀

NCD

Thank you!

And truly sorry for the poor analogy, made myself confused as well😅

With your help, I made it to work by creating a Virtual Col. and

CONCATENATE([SubCategory],” (“&[SubCategoryDescription])&”)”

in App Formula.

and I call this Virtual Col. SubWithText

But the issue now is, I have this SubWithText a Dependent Dropdown of Category and also to be my first couple of values in my ProductSerial as well by:

[SubWithText] & "-" & RIGHT("00" & RANDBETWEEN(100, 999), 3)

in ProductSerial Initial Value.

So Really when I just want my ProductSerial to be F5-123,

at the moment I’m getting F5(These are Cotton)-123.

Is it possible to make it work?

TeeSee1

[SubWithText] & "-" & RIGHT("00" & RANDBETWEEN(100, 999), 3)

-> [SubCategory] & "-" & RIGHT("00" & RANDBETWEEN(100, 999), 3)

Doesn't this work??

Steve

@NCD wrote:
How do I go about, if I wanted the Album name to pop up in parentheses next to each Song Name in the same box, or shows the album name if I hover the cursor over it?

Not possible.