Filter row in form looking up value on a different table

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.

1 Like

Try Filter()

1 Like

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 tried filter() but I can’t make it work.
  • The lookup formula is correct but I still see the colum in the form view
    ISNOTBLANK(lookup(USEREMAIL(), “Submission”, “user”, “Key Result 2”))
  • I was thinking of a show_if restriction on the column but I’m not sure where to put that or how to do it.

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

1 Like

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.

2 Likes

Your reply helped me see that I was looking for the wrong info. Thank you.

1 Like