I have one layout that shows all bookings from today for a set period of time which is based on set fields and a perform find script. The resulting records also have a portal that shows what items have been ordered. Is there a way to do the script so if any items are NOT in the category ingredients it doesnt show that record.
If I try to do a find field based on the records having "Ingredients" in the category it shows nothing and assuming its because its in the portal
I am trying to make it so I can show all upcoming jobs for the next two weeks but only if they have food items ie ingredients in the booking