Multiple dependant dropdowns using the same dataset

Hi legends.

I'm trying to make an app to keep a simple record of my tasks with a total hours at the end of it all. Dependant dropdowns are giving me a headache ๐Ÿ˜ซ 

Using the valid_if section for creating a dependant dropdown works great, but if there's multiple dropdowns drawing the data from the same sheet, every one (after the first) only offers the same list choices as above. My noob thoughts are telling me that if the column name is different then it would be an independant field. Yes?

How do I get around this problem?

 

See attached screenshots for example

 

Screenshot_20230326_204016_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204035_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204042_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204054_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204059_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204124_AppSheet.jpg

โ€ƒ

Screenshot_20230326_204130_AppSheet.jpg

โ€ƒ

Screenshot_20230326_205811_AppSheet.jpg

โ€ƒ

Thanks for reading my post. Any advice would be greatly appreciated!

DAN

0 2 122
2 REPLIES 2

Always post the actual expressions that you're using when asking for help.

I'm assuming you're using basic table[column] expression in your valid_if? If so, you're activating appsheet's built in dependent dropdown functionality. If you need to avoid it, you'll have to create your own SELECT() expression.

https://help.appsheet.com/en/articles/961554-dependent-dropdown

https://help.appsheet.com/en/articles/2357314-select

 

Thanks Mark, I'll look into it ๐Ÿ‘ 

Top Labels in this Space