Update drop-down depending on multiple field values?
Confluence User - 08 Aug, 2020
Hi everyone,
I have a drop-down "Price" that, if not filtered would take its values from:
"select c_menuprice , c_menuprice from app_fd_menu"
I then have 3 fields A, B, C and I would like to filter my "Price" in order to do:
"SELECT c_menuprice, c_menuprice FROM app_fd_menu WHERE field1 = A and field2 = B and field 3 = C "
A,B and C are the value that selected at the select box
What is the best way to do that? Can JavaScript done it? If yes, Can you provide the solution or sample code please? Or can I have multiple dependency for the "Price"?
Thanks a lot
forms;javascript;selectbox;multiple;validate;filter;dependency