I Want to Have condition in the in the field[Square] valid_if to check if the Field [Province]="Salalah" then do dependent dropdown list else show the field[Square] to the user for data entry
I have tried to use IFS() but not of my tries worked
First attempt
IFS(
[Province]="Salalah",Cities[Square],
AND([Province] <>"Salalah", [Square]="")
)
Second try
IFS(
[Province]= "Salalah",Cities[Square],
[Province]<>"Salalah", [Square]="",
)
Solved! Go to Solution.
If you'd like to sort the list of provinces, set the Valid If for Province of the Properties table to:
SORT(
SELECT(
Cities[Province],
TRUE,
TRUE
)
)
Similarly, for State:
SORT(
SELECT(
Cities[State],
([_THISROW].[Province] = [Province]),
TRUE
)
)
And for Village:
SORT(
SELECT(
Cities[Village],
AND(
([_THISROW].[Province] = [Province]),
([_THISROW].[State] = [State])
),
TRUE
)
)
For Square, use Suggested values instead of Valid If:
SORT(
SELECT(
Cities[Square],
AND(
([_THISROW].[Province] = [Province]),
([_THISROW].[State] = [State]),
([_THISROW].[Village] = [Village])
),
TRUE
)
- LIST("")
)
IFS(
Province]<>"Salalah",[Square],
Province]="Salalah",Cities[Square]
)
Error
Column Name 'Square' in Schema 'Properties_Schema' of Column Type 'Text' has an invalid data validation constraint '=IFS( Province]<>"Salalah",[Square], Province]="Salalah",Cities[Square] )'.
You cannot mix dependent dropdowns with other conditions. Since you have another condition, you will need to implement the dependent dropdown behavior for this column yourself.
Please provide the Valid If expressions of all columns involved in the dependent dropdown.
I have two tables as shown below
In DATA of the Table [ Properties] i need to do dependent dropdown in Valid_if in Following Fileds
Cities[Province]
Cities[State]
Cities[Village] I need to order the Villages from (A-Z)
Cities[Square] IF Cities[Square] is not blank for that Village than do a dependent dropdown list of Cities[Square] else allow the user the enter date the Square Field
[Cities]
ID | Province | State | Village | Square |
1 | Dhofar | Salalah | Adhan Valley | c |
2 | Dhofar | Salalah | Brisut Industrial Zone | B |
3 | Dhofar | Salalah | Awqad South | B |
4 | Dhofar | Salalah | Awqad Al Sharqiah | B |
5 | Dhofar | Salalah | Adhan Valley | B |
6 | Dhofar | Salalah | Brisut Industrial Zone | a |
7 | Dhofar | Salalah | ambi | a |
8 | Dhofar | Salalah | Al Shati neighborhood | a |
9 | Dhofar | Salalah | Awqad South | a |
10 | Dhofar | Salalah | Awqad Al Sharqiah | a |
11 | Dhofar | Salalah | Awqad Western | a |
12 | Dhofar | Salalah | Awqad Al Wusta | a |
13 | Dhofar | Salalah | Ain Arzat | a |
14 | Dhofar | Salalah | Ain Jerzeez | a |
15 | Dhofar | Salalah | Ain Hamran | a |
16 | Dhofar | Salalah | Ain Sehnout | a |
17 | Dhofar | Salalah | Adhan Valley | a |
18 | Dhofar | Salalah | Atheno | |
19 | Dhofar | Salalah | asnot | |
20 | Dhofar | Salalah | Aiboot 1 | |
21 | Dhofar | Salalah | Aiboot 2 | |
22 | Dhofar | Salalah | Adoration | |
23 | Buraimi | Buraimi | Abu Nakhila | |
24 | Buraimi | Buraimi | Al Ghurayfa | |
25 | Buraimi | Buraimi | acceptor | |
26 | Buraimi | Buraimi | Agran valley | |
27 | Buraimi | Al-Sanaina | black | |
28 | Buraimi | Al-Sanaina | Buhaisah | |
29 | Buraimi | Al-Sanaina | Al-Sanaina | |
30 | Buraimi | Al-Sanaina | Al Ghubaira | |
31 | Buraimi | Al-Sanaina | cheek | |
32 | Buraimi | Al-Sanaina | Ain El Helweh |
[ Properties]
ID | User_email | User_name | To advertise | Date | Province | State | Village | Square | Plot no | property type | Area | Total income | Rent value | Details | Price | OmanReal Link | Google Link | Property Photo |
If you'd like to sort the list of provinces, set the Valid If for Province of the Properties table to:
SORT(
SELECT(
Cities[Province],
TRUE,
TRUE
)
)
Similarly, for State:
SORT(
SELECT(
Cities[State],
([_THISROW].[Province] = [Province]),
TRUE
)
)
And for Village:
SORT(
SELECT(
Cities[Village],
AND(
([_THISROW].[Province] = [Province]),
([_THISROW].[State] = [State])
),
TRUE
)
)
For Square, use Suggested values instead of Valid If:
SORT(
SELECT(
Cities[Square],
AND(
([_THISROW].[Province] = [Province]),
([_THISROW].[State] = [State]),
([_THISROW].[Village] = [Village])
),
TRUE
)
- LIST("")
)
Thanks You are the best 👍
I hope that there is an option to sort data as a check mark within the program
For people like me who are not good at coding
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |