Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm currently debugging my data model and I need to view the selection of my hidden field. Is it possible to view the hidden field selection in a current selection box. Or do we have other workaround? Thanks!
If you mean 'conditionlly hidden', conditionally hidden field selection is visible in the current selection box. If you want to view the object, then goto the sheet->right click ->properties->object->show mode (you will find 'conditional: hidden')-> select the object->properties, and then change the condition to set it to a true value.
Hi Khim,
Is it hidden using hidesuffix or hideprefix functionality?
If so, go to select fields(under Sheet Properties) and check the Show System Fields in the left bottom which will show the hidden fields.
Cheers,
Naresh
Hi Naresh,
I want to know what are selected in the hidden field. (not adding the hidden field listbox)
Nope... not the show mode. As mentioned by Naresh below, it is the hidden field with prefix. But I want to check the selected value of the hidden field. I have edited my first post with an image example.
Alternate way:
In a textbox, expression : =GetFieldSelections(_InvoiceNo)
Follow my screenshot.
When you enable the System fields, the fields which are hidden(also the selection will not be shown in the current selection box), all the hidden fields will be visible and so you'll be able to see the selections applied to those fields from the current selection box. Hope it is clear.
Cheers,
Naresh