Hi, i use data column to generate List dropdo...

(Arnaud B.) #1

Hi, i use data column to generate List dropdown. It is possible to add, delete or update only one entry in one column ? or need i to configure 1 sheet for each column ?

(Challa Ramakrishna) #2

I think you need separate sheet

(Grant Stead) #3

You could have one table called ENUMLIST with two columns, category and item… Then in your valid if for each, drop a filter on the category… Then you can add/remove to your heart’s content

(Arnaud B.) #4

@Grant_Stead Then it is possible to add only in one column ??? i don’t understand how to …

(Grant Stead) #5

Yes, the table would look like: cl.ly - Image 2018-03-29 at 1.02.57 PM.png Image 2018-03-29 at 1.02.57 PM.png cl.ly

(Arnaud B.) #6

@Grant_Stead OK it’s like standard. Only possible to add an entire line. THX

(Grant Stead) #7

Then elsewhere throughout the app if you want to use those items, you simple filter the table down using the filter… And you would put this filter in the valid_IF FILTER(ENUMLIST, [category] = “Fruit”)

(Arnaud B.) #8

@Grant_Stead ok thx

(Stephen Mattison) #9


wtf is that CloudApp Comments/chat thing on the image you posted here?

What’re you doing with CA?

(Grant Stead) #10

@Stephen_Mattison I just use it to take screen shots and video, super easy…