May 12, 2017 05:45 AM
I would like to lookup entries from another table. But ONLY if they have a certain value in a special field. Is this possible?
Table 1: Matchdays
Table 2: Players
In Table 2 players can either be “available” or “not available”.
In Table 1 I want to ONLY list the names of the players that are available. Not ALL players that are linked to that matchday.
May 12, 2017 07:42 AM
Create a Lookup field in Matchdays that displays the “Available/Not Available” field in Players and then create a View that filters on that field.
Conversely, you could filter the Players table by “Available” and by a new field that looks up the “Match Day” in the Matchdays table.
I might have missed what you’re trying to do.
If you’re not interested in filtering but, instead, you want to display a Player’s name ONLY IF the player is available, and display nothing otherwise, then you would still need a Lookup field based on “Available”, and you could hide it if you want, and then create a Formula field with an IF statement that evaluates the Lookup field and then displays or doesn’t display the Player’s name, which would come from the Linked field, which in turn could be hidden in a particular View.
Jan 03, 2019 03:36 AM
I know what you are trying to do :slightly_smiling_face:
It can be done but with some effort … try create other database(s) and sync them with Zappier :winking_face: it worked for me … the refresh is preeety quick
Dec 11, 2021 01:30 AM
I think you’re on to something here. Can you further illustrate how to it can work.
I’m trying to do something similar. I want to create a lookup for the contacts of a certain vendor, but only the contacts of a certain department,
Dec 11, 2021 11:31 AM