I have 12 "yes/no" fields that are "available slots." Once a person selects a "slot," I would like the "slot" that was selected not to display anymore on subsequent new items/forms. I know how to hide directly on the form but this is more along the lines of hiding or disabling a field that someone else has selected.
Anyone have any thoughts or ideas for the most efficient way to achieve this?
Use a calculated value for each slot with formula like
Lookup("List Name","Slot field Name","Value if True", "Any Field Name")
and then add a formula to each slot so if its related calculated value is empty, hide it.
I'm having trouble with the 4th parameter (output) in the string. I'm selecting one of my fields/columns, that is a "single line of text" field, called "outcome," but I am not getting the results that I would have expected.
Did you try replacing Outcome with "outcome".
If yes and still doesn't work, please send me a screen shot of the browser dev console error since it's a REST call.
Here is the formula:
This is what it looks like before its checked:
This is what it looks like when I check the box:
Nothing on the console until after I uncheck the box and then this is what appears:
[Department Sites-d1ce0353-c428-411f-86f9-1b6c308fb03e] - Lookup runtime function is missing valid parameters. Check that the list name, filter column, filter value and return column are specified in the function. Parameters - list: Department Sites, filter column: false, filter value: Yes, return column: NWF.FormFiller.Functions.GetTypedValue('','Text')
Thank you for your continued help with this.
I removed the qoutes and now, whether or not the box is checked, the field is not calculating at all:
and here is the message from the console:
[Department Sites-54ab11ff-f52a-410a-b2bc-29dbfe79986d] - Lookup runtime function is missing valid parameters. Check that the list name, filter column, filter value and return column are specified in the function. Parameters - list: Bank Notes Department Sites, filter column: true, filter value: Yes, return column:
Just to make sure - "Oct2018Slot2" and "Outcome" are variables on the form containing the actual column names? I'm asking because they are look like references in the formula, but the formula actually expectes the names of the column(s).
I used the "Named Controls" fields rather than the "Item Properties." I'll try using the "Item Property" fields since those fields are the actual column names.