Programmability Show and Hide


Example of a form utilising the show and hide option on a control


Instructions

In this example, the mobile phone (cell phone) field will be hidden on a form if the contact already has a mobile phone number saved, and will show if the mobile phone field is empty.
The control used is a simple text box



To meet the requirement of the control, the IQA query must return a result if the Mobile Phone field is empty

IQA Filters & Display
The filter will return data if the ID of the contact record is equal to the SelectedID and the Mobile Phone field is empty. 
Therefore,  the display is returning the ID, not the Mobile Phone.  Whenever possible, the query should be written to ensure only one row of data is returned


Form - when record has a mobile phone number

      

And when the mobile number is removed

        



LAST UPDATED: 3098

Edit