when i use Valid if to limit my drop list to certain values i found the icon shown in the photo
However, i used the ref type with other dropdown list without any valid if statement, and it works perfectly.
The Expression used in the valid if part is :
Blockquote
SELECT(SUBMITAL NO[Submittal No],
AND(
[Project_id]=[_THISROW].[Project],
[Submittal Type]=[_THISROW].[Submittal Type],
[Discipline]=[_THISROW].[Discipline]
)
)
as shown in the photo:
Am i doing any thing wrong? how to get rid of that icon?
Solved! Go to Solution.
You would need to create your expression so that you select Engineers who have projects - i.e. a filtered list of Engineers.
Something like this:
SELECT(Engineers[Engineer ID], IN([Engineer ID], Projects[Engineer]))
In english - โSelect the Engineer ID from the Engineers table where the Engineer ID is IN the list of engineers from the Projects tableโ
NOTES:
You can read more about the IN() function here:
Is [Submittal No] your โkeyโ coumn?
No
[Submittal No.] is a REF column so the values presented in the dropdown list MUST be key column values from the โSource tableโ AND they must be in the list designated by your Valid_If expression. If either of these are not true you will see the yellow โwarningโ icon.
In your case you have, in the Valid_If, the expression as:
SELECT(Submital No[Submital No]....
Submital No is your table. For REF column to work, [Submital No] column MUST be the key column for the table. If it is not, change it to the key column.
Actually i cant make it key in referenced table, i am using a concatenate expression to represent a key, the submittal No could be repeated.
is their any problems may occur because of this warning icon?
Whichever column is set as the key in Submital No table, you MUST MUST MUST use that column in the SELECT() expression in the Valid_If.
The next issue beginners will encounter is that the dropdown list doesnโt show the value they want shown. That is what the Label column is for. It is the value that is displayed instead of the key. So, in the Submital No table in the Label property column, check which value should be displayed in the dropdown list.
I will follow as per your respected advice and i will re adjust my table to follow as advised.
Really Thank you so much
Sorry for coming back, i did as per your advice, and magically all warning weird thumbnails were disappeared.
However, i have tables with many to many relationships.
i have โEngineersโ Table and โProjectsโ table, many Engineers has many projects, and many projects has many engineers, so, I created an โEngineer projectsโ table contains just the idโs from both โEngineersโ and โProjectsโ tables in addition to a key column โeven if it is not requiredโ.
i cant use the method you taught me above to show the actual Engineer name from โEngineer projectsโ table in a list to assign him a task from referenced column at tasks.
any idea
Thank you
You would need to create your expression so that you select Engineers who have projects - i.e. a filtered list of Engineers.
Something like this:
SELECT(Engineers[Engineer ID], IN([Engineer ID], Projects[Engineer]))
In english - โSelect the Engineer ID from the Engineers table where the Engineer ID is IN the list of engineers from the Projects tableโ
NOTES:
You can read more about the IN() function here:
Honestly, Thank you.
It works perfectly. Actually, it solved other difficulties i was facing too.
The Return of the Son of the Weird Thumbnail
Classic AppSheet movie
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |