Include logged-in user's detail in database after they submit an online form 
Autor: Emile Brown
Visitado 1593,
Followers 3,
Compartido 0
Please create an option to "include SPECIFIED details of the logged-in user's profile" when posting to the database when they submit an online form or contact sheet.
I have created a "Job Requisition" site with restricted access to the "Job Requisition" page.
I do not want the user to fill in their name and contact details in the form every time that they post a new job. I would like the user's "first_name" and "last_name" to be updated automatically, together with the newly submitted information.
At this stage, the database for "first_name" and "last_name" is not updated unless I have included the "Requested by" and "eMail Address" it in the contact sheet.
Publicado en
Hello. I sent a notification about your idea to the company employees, expect an answer from them here in the comments.
Hello Emile
You could avoid redundant data by doing it yourself, by making a "simple" PHP script where you join your contact table and the user table, and then display the result.
But you need to have the e-mail in the contact-sheet.
Another possibility is to have a database tool where all is done automatic.
Take a look at the AppGini software . This is quite affordable and simple to use - but powerful.
Doing it this way, you "move" the login to the database software, where there are more possibilities.
There are also more advanced tools but then the prices go sky-high.
Using a database tool, you can give users the right to create a "job"-card, and afterward he can ( when logged in ) see his own "job" cards. You can set user access so that users can create and view own cards but not afterwards edit.
You can have an admin or a manager that are allowed to see "job" cards for all users.
You can have a child-table to the "job" cards so you can have different entries ( could be status changes or messages) for each job -card.
If you use the "job" cards operational, you should consider a database solution.
I have just made a simple test so you can see what I mean.
it is here : https://pindown.eu/demo02.html
It is not styled - it is a quick one. You can log in as user Emile with passw. Emile.
Emile is not set up to allow editing but is set up to allow to view for all users.
I have created 3 users that are allowed to edit but only view their own records.
If you are interested in trying to be one of the users, you can contact me on Calendarforum.dk
http://calendarforum.dk/contact.html
Hello Emile
Tomorrow I will remove my test.
Here you see ( integrated in X5 ) how it looks when not logged in.
Here you see when logged in as Emile
And her when logged as a "normal" user (Peter )
the testinstallation will be removed tomorrow - until then, it is possible to see it "live".