1. Diane Royer
  2. InfoMaker
  3. Wednesday, 24 March 2021 14:45 PM UTC

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?

Accepted Answer
Diane Royer Accepted Answer Pending Moderation
  1. Wednesday, 24 March 2021 20:13 PM UTC
  2. InfoMaker
  3. # Permalink
0
Votes
Undo

Unfortunately, we do not have Power Builder.  Is there any other way to accomplish this?  Even if we can just put a button on the form that will hide and unhide the fields when the button is clicked.

Comment
Hi Dianne;

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
  1. Chris Pollach @Appeon
  2. Monday, 29 March 2021 18:56 PM UTC
That was perfect. Thank you so much for your assistance. I did have a computed column that was in the Update Properties. I took it out and now it works great.
  1. Diane Royer
  2. Monday, 29 March 2021 19:13 PM UTC
That is "Awesome" news Dianne .. thanks for the feedback! :-)
  1. Chris Pollach @Appeon
  2. Monday, 29 March 2021 19:40 PM UTC
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 March 2021 17:13 PM UTC
  2. InfoMaker
  3. # 1
1
Votes
Undo

Hi Diane;

   Yes, an expression on the visible property would certainly achieve the desired effect. The key would be to know if your App User is legitimate as part of the expression's validation. My suggestion here would be to create a Global Function in PowerBuilder to check the User's status. If that can be done in a GF, then copy the GF from the PB PBL to the IM PBL (library). GF's built in PB can then be called by IM Expressions.

   I have personally implemented the above before in IM using GF's.  HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.