I would like to create a field with a read-only default value that appends / concatenates two values from the current record into one unique string. Is this possible with the 'default' setting in the Appgini field definition? If so, I haven't had any luck getting the syntax right so far
For example, perhaps the username (from the list of automatic values) appended to the record's primary key (which is an auto increment field) or ideally with a random number to get something like "username5982496".
Basically, this would create a second unique field that I could use instead of the record's primary key to access a specific record.
I need something like this because I have a page that outside of my Appgini application that generates a report accessible by URL using this table's primary key as selection criteria within the URL. However, since the primary key is an auto increment field, it's very easy to change that part of the URL and view a report intended for a different user.
If a different unique (but not simply auto incremented) field can be used instead of the primary key in the URL for that report, then it would be more difficult to guess the url for a different user's report - though not impossible, of course.
I want users to be able to easily and quickly view their own report without necessarily having to log in anywhere first. Although there is no personal information displayed in these reports that would lead to any privacy concerns, I still want to discourage users from looking at content not intended for them.
Thanks for any tips and advice
