• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

replace field info with stars or something but on export view original info

I am using Filemaker 6.0 and store personal information into a field.
There is one user that inputs the information and others that view.
My goal is to input the information the first time in the field and verify it is correct and then every time after that hide the information in that field until  needed again.
It gets a little confusing becasue I need to export the original information without the stars.
So basically what I am saying is that I want to input the information into the field correctly and then hide it until the user who has rights can view it to export the info.
I never want to just open the database and see the full information from that field.
I know I can limit access to a databse with passwords but I want to do it at the field level.
Thanks in advance
0
kcassone
Asked:
kcassone
  • 5
  • 4
  • 3
  • +1
1 Solution
 
JoJohn2004Commented:
The easiest way to do this is to create groups with different privilege sets. You will have to give different passwords to each group but you can limit access to both the layouts and the individual fields that way. Filemaker 7 and above are MUCH more friendly with regard to privileges and their creation. If you are unclear on how to create groups, let me know and I will provide more detailed information. I am not clear on where the stars fit in.
0
 
kcassoneAuthor Commented:
I am aware of privlege sets by groups but I am trying to avoid that.
A good example of what I am talking about regarding the stars are like in a credit card situation.
Instead of showing the entire credit card number in the feild you can put stars or x's in the first part of the  number and only show the last four digits of the card.
I want to be able to do the same for the personal information in a field.
I will use the credit card example to explain a little further  of what I am trying to accomplish.
Obviously you must first input the original credit card data into a field and then create another field that shows the credit card number with stars and last four digits.
I know I can then limit users to seeing the layout with the original credit card numbers, but I want to take it a step further,  I want to hide the original credit card number information after it is entered and only allow access via another script or field behavior...or other approach.
I don't know if that is possible, that is why I am asking the experts.
Thanks
0
 
JoJohn2004Commented:
In order for the program to permit an action for one person but not another, it needs to know who is currently using it. Even if you put the actual data on another layout, what is to prevent anyone from accessing the other layout or script. You can simplify the issue a little by auto entering a lower level of password at startup so that data entry people would not have access to the data and administrative levels would have to log in with a password to modify data or see the actual info. It would of course mean that virtually anyone with access to the file would have access to the 'public' data though.

You can create a calculation field using the substitute function to create a masked password and use that as the display for the entry level users.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
kcassoneAuthor Commented:
Can you please be specific:
You can create a calculation field using the substitute function to create a masked password and use that as the display for the entry level users?
0
 
JoJohn2004Commented:
If you have a credit card number called cc you can use this to mask out the numerical data to only show the last four digits:
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(Left(cc,Length(cc)-4),"1","*"),
"2","*"),
"3","*"),
"4","*"),
"5","*"),
"6","*"),
"7","*"),
"8","*"),
"9","*"),
"0","*")
&Right(cc,4)

This only masks numbers. If you want to do letters, you will have to add then to the calculation.
0
 
kcassoneAuthor Commented:
Sorry, maybe theres a miscommunication. I know how to mask the information in the field but you had stated a possibility of a masked password/
0
 
JoJohn2004Commented:
I am sorry but I am completely confused about what you want. If you want to mask fields of data you can use the calculation above. If you are going to use passwords to limit access, they are masked already. I suppose you could create a login script that takes you to a global where the user enters a 'password' and that can be used in the masking calculation to display data or not. If gPassword = Admin then display full data otherwise display masked text. I guess you are going to have to be a bit more specific.
0
 
lesouefCommented:
I would use a custom dialog for data entry if the field is empty and disable that script step if the field is already populated. You can either use the field itself in the dialog window or use an intermediate global field to make some post-entry check on the number, then copy the value to the required field.In tha latter case, don't forget to clear the global field before showing it again. example upon request on monday.
0
 
JoJohn2004Commented:
Fortunately, in a hosted solution, a global will clear itself as long as it is blank when it is made active on the server. It sounds like a custom dialog or a global field is likely to be the only way you can do this without entering a password at startup.
0
 
kcassoneAuthor Commented:
OK,
Lesouef, what you are saying makes sense and an example would be greatly appreciated.
0
 
lesouefCommented:
here it is:
https://filedb.experts-exchange.com/incoming/ee-stuff/4330-custom_dialog.zip
this asks data entry in password mode (displays stars), checks its length (you can check whatever you need here) before putting data in the final field.
in my example, data is visible in the table for test, but you would of course remove this field.
0
 
lesouefCommented:
kathy, wake up!
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now