We are currently using Infomaker 2019. We have some forms that were created with Infomaker. We are adding some fields to one of these forms. However, the fields we are adding have some confidential information. As a result, we want the user to verify his or her identity before viewing the fields or at least have them click a button before the fields are visible. Is there a way for the fields to be hidden by default and then made visible by clicking a button or checking a box?
-
Diane Royer
- InfoMaker
- Wednesday, 24 March 2021 14:45 PM UTC
Retrieval Arguments are not used any update SQL. So that approach should not cause any update errors.
However, if you used an SQL "Computed Column" (CC) for expression visible control, IM "assumes" that CC's are part of the DB Table "entity".> Thus need to be referenced on any Insert or Update DML command. The key here for using CC's only for Retrieve only purposes, is to use the RHMB on the Form's data area and then select "Update Characteristics..." from the resulting pop-up menu. In the Update dialogue, make sure the CC is *not* highlighted in the "updateable Columns" list. Thus, no SQL will be generated for that CC and thus, no DML errors should occur now on an update. HTH
Regards ... Chris