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
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
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.
ASKER
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
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
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.
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.
ASKER
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?
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?
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(
"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.
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(Left(cc,Length(
"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.
ASKER
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/
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
OK,
Lesouef, what you are saying makes sense and an example would be greatly appreciated.
Lesouef, what you are saying makes sense and an example would be greatly appreciated.
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.
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.
kathy, wake up!
Forced accept.
Computer101
EE Admin
Computer101
EE Admin