Share
Report
12For context, I have 3 ovens to bake cakes with different names.
Currently I have 3 Sharepoint lists for those ovens:
1) Status list named STATUS: only contains 2 elements, which are "In operation" and "Completed".
2) Historical list named HISTORICAL: it contains past or actual events of the ovens. This list contains a lookup column to the STATUS list. It doesnt contain specific informations about the cooking process.
3) Maintenance list named MAINTENANCE: containing maintenance informations about the ovens. Condition: the ovens must be "In operation" in order to perform a maintenance (sounds dangerous but it is).
I'm making an application in which I created a formula for manual entries.
In the first field, the user enters the oven's name via a drop-down menu.
In the second field, it should show the event's ID (from HISTORICAL list) since one oven = one baking.
The question is, in the second field, how do I only propose bakings with the "In operation" mention?
I've tried typing this in Items in the DataCardValue1 but the dropdown menu becomes empty.
Filter(BAKING; Status.Value="In operation")
Categories:
I have the same question (0)
All responses (
Answers (
