Mar 30, 2023 09:37 AM
Hello amazing people! I am working on my film workspaces and trying to build a table to use for a Page Designer for a Call Sheet. I have several tabs I need to pull details from, all based on the Date Field. This Scenes tab is one of the places to pull from, and it has a Filming Date field.
I am pulling IN to this Call Sheet tab
What I need is if the Date on a record in the Scenes tab matches the Date in this Call Sheets record, I want the records to link. I will be using a number of associated lookup fields from the containing records.
I assume I will need to use a Formula? I have trouble wrapping my head around those for some reason 😖 I've tried various other options and none will allow me to just say "If this date matches that date please link" and I can't restrict to a view because I would need to change that parameter for every new call sheet.
I hope this makes sense! If anyone has any suggestions I would really appreciate it!
Solved! Go to Solution.
Mar 30, 2023 07:59 PM
It won't be a formula. Here are two methods I can think of:
Let me know if you'd like me to explain either of these further.
Mar 30, 2023 07:59 PM
It won't be a formula. Here are two methods I can think of:
Let me know if you'd like me to explain either of these further.
Mar 30, 2023 08:29 PM
Oh...my....goodness!! I had been staring at it so long it never occurred to me to look at it from the other direction!! Thank you so much, this solves so many things and let's me actually streamline a few other things. This community is absolutely fantastic ❤️
Mar 30, 2023 08:46 PM
No problem!