Greetings Guys,
I was told that possibly thru hooks I could achieve what I am working on. I am new to the whole program and not a coder by any means but have my database down to the last little "hard coding" that AppGini cant do.
I am looking to take the registered "user" and tie them into an employee record that echos their company information in place of it. I created a table called "security_officers" and inside it I have multiple fields however I am only wanting to echo in place of the registered "user" the: "officers_name" and "badge_number". I will have it echo in the other tables as a lookup field or so I had planned out. A friend that turned me on to this program mentioned I might be able to do this if I added a field in the "security_officers" table called "username" and put in the registered "users logon" in that field.
Please help, maybe there is any easier way to do this?
Thank You!
How to link "users" to record users
Re: How to link "users" to record users
Where are the "officers_name" and "badge_number" stored?
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Posts: 8
- Joined: 2014-05-30 02:56
Re: How to link "users" to record users
In the security officers table.
Re: How to link "users" to record users
Okay ... so, if I understand correctly, each officer would have a username that he can use to access the application. So you want to link each record in the officers table to a user, in a one-to-one relationship, right?
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Posts: 8
- Joined: 2014-05-30 02:56
Re: How to link "users" to record users
Yes so user submissions cant be altered.
ie:
user: jd135
badge: 100
name: john davis
reported as: john davis - 100 on records.
ie:
user: jd135
badge: 100
name: john davis
reported as: john davis - 100 on records.
Re: How to link "users" to record users
Hmm ... you could add a field for storing the username in AppGini, and set its default to the "Created by username" automatic value and also set it as unique ... this will effectively limit each user to a single record in the officers table.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.