Button URL specific record with Everyone on the Internet

I have not totally thought this through, but what if you made a formula field of the [Record ID#] of [Related employee]  plus 98765. Call this field [Calculated Secret Code] So employee record ID #1 would have a value of 98766.

Then when you send the link populate that field on the record called say [Access code].

For that EOTI Role, make a permission that they can only see records where the [Secret Code] = [Calculated Secret Code]

That is something is was trying to figure out as well.  How if I have a field with a "secret" code within record can I send it in on the URL to bring up that specific record.  More importantly, how could I then limit that EOTI Role to only that record based on that "secret" code.  I think we are both going down the same thought path, I just may lack the experience in the URL with an extra field. 

Can I see the code for the link that you are sending?  Is it to add a record or view or edit a record? 

The code is simple:  

URLRoot()&"DB/"&[_DBID_xxxxx]  &"?A=API_EDITRECORD&rid="&[Record ID#]&
"&_fid_22=" & ToText(Now())&
"&rdr=" & URLEncode(URLRoot() & "db/" &[_DBID_xxxxx] & "?a=er&key="&[Record ID#]&"&dfid=12")


I have two fields, one called security code that I am setting, and other field called access code that I would want to set to equal security code. Then only allow users to view the page when those two match.  After a save of the record I would blank the access code through dynamic rules to prevent any unauthorized acess as a futher measure. 

Try this

URLRoot()&"DB/"&[_DBID_xxxxx]  &"?A=API_EDITRECORD&rid="&[Record ID#]
& "&_fid_22=" & ToText(Now())
& "&_fid_999=" & ToText([Calculated Secret Code]


&
"&rdr=" & URLEncode(URLRoot() & "db/" &[_DBID_xxxxx] & "?a=er&key="&[Record ID#]&"&dfid=12")


//999 is the fid of the secret code field 

Yes, that should work perfectly.  I guess that was pretty "thick" of me not realizing that line. 

Last question, the custom permission rule, can you have a rule that says Calculated Secret Code is equal to [secret code]  

It is an open text field for the second caparison factor so I wasn't sure if I could just add the field name or not. 

Right, I often forget that the custom permissions are not very flexible. So you need to make a formula checkbox field to check that they equal and then the custom permission Rule will test if that formula checkbox field is checked.

Great idea, thanks for all your help! 

I created the formula checkbox for the custom permissions, but my users still receive an error that they must login to edit.  I know the formula is working, but could this be because I am trying to update fields in the URL sending them into the record? 

That does seem odd that they need to sign in if the app is open to everyone on the Internet for editing.  Are you sure that the EOTI Role is allowed to edit? (subject to that secret code rule)?