Table 1 name โsubmissionโ has columns named [user] [key result 1], [key result 2].
Table 2 name โcheck inโ has columns named [user] [date] [Input 1] [Input 2].
Question:
For some users, [key result 2] is empty. For these users, the check-in form should not ask for [input 2]
I canโt figure out how to filter out [input 2] from the check in form depending on the user and the value of [key result 2].
I tried to apply this filter but it is not working
ISNOTBLANK(lookup(USEREMAIL(), โSubmissionโ, โuserโ, โKey Result 2โ))
Apologies in advance if this is a really simple question.
Thank you,
Maiga
@maiga
If your Submission table contains more than 1 record for any single user, than the LOOKUP expression will return the 1st matching rowโs [Key Result 2] column value.
Try Filter()
Thank you @FREDY_ORTEGON and @LeventK for the reply.
The โSubmissionโ table has only 1 record per user. This is why I want to use it as a reference.
This is what I want:
column [input 2] from table โcheckinโ does not show in the form
when:
column [key result 2] (from table โsubmissionโ) is empty for the same [user].
Iโll give a try tomorrow with fresh eyes but if there is an obvious solution I would very much appreciate it.
Thank you both!
Hello, from what I can understand in the formula, you are looking for the email in a table and if it is correct, then this formula would return โTrueโ, is it correct? If so, then use the formula IN for example:
in ( useremail (), records [Email_registered])
use this formula in the field show if the column you want to be displayed or not. the IN formula validates if the user is already registered, if registered it returns โtrueโ, then at this moment the field you want is displayed. Let me know if Iโm helping
Your reply helped me see that I was looking for the wrong info. Thank you.
You could try an alternate show_if formula
COUNT(SELECT (Submissions [key_result2],[user]=USEREMAIL ()))=0
However you seem to say that your formula is working so Iโm not sure what the issue could be.
User | Count |
---|---|
44 | |
34 | |
27 | |
23 | |
15 |