About HelloFOlks

HelloFOlks · 12-21-2023

Hello,For the following tables, I want to limit the dropdown options so that when a record in the parent table's Completed? = Yes, it is no longer shown in the dropdown for MO# in the Child table. Parent table: MO# , Completed?Child table: RowID, MO#...

HelloFOlks · 12-27-2023

Ok, turns out there is a very simple solution (which of course took like 3 hours to figure out lol).Valid_If = FILTER("Parent table", [Completed?] <> "Yes") Thanks for the help!

HelloFOlks · 12-27-2023

Hey thanks for getting back to me! I just tried this solution (I've also tried contains()), but instead of limiting the dropdown options, it just tells me the entry is invalid. I am hoping to not have it show as an option. I haven't had this issue wi...

My Stats

Mark_Pathfinder's Bio

Badges HelloFOlks Earned

Recent Activity

Limit dropdown options in a child table based on condition in parent table

Re: Limit dropdown options in a child table based on condition in parent table

Re: Limit dropdown options in a child table based on condition in parent table