I need to add the logged in user id to a hidden field when they do an insert into the database.
How is this done?

Regards

Matt

Hello Matt,
You do not need to add the validation to the hidden field. You can add it directly in the insert step.
The session is generated like: SecurityProviderName+"Id"
So if your security provider name in the server connect is called: dbUsers then your session name is: dbUsersId
So you can define this session under Globals > Sessions in your server action and use it as a value in the insert step.

HI Teodor

I have followed your instructions.
My Security Provider =dbUser
My User id field in DB = user_id
My server action : Projects/Insert
In my steps I have
Dtabase connection: localhost
Database insert: Insert_Project
Security Provider:dbUser

In the Database Update Action Builder
I am inserting into the Projects table in DB successfully except the session logded in user.

In the page code I have the following for the Server Connect Action Executors: Insert_Project

The session id is not created.
Am I missing something in the steps or Globals?

In the dmxconnect/api/projects/insert

the session is set as


"$_SESSION":

"type": "number",
"fieldName": "user_id",
"name": "dbUseruser_id"


Any idea what I have done wrong?

Regards

Matt

"id": "Insert_Project", "url": "dmxConnect/api/Projects/Insert.php", "form": "#new_project", "data": {"user_id": "{{$_SESSION.dbUseruser_id}}"}, "onSuccess": "MM_goToURL('parent','index.php')

If your security provider name is dbUser then the session, which stores the user id is called: dbUserId and not dbUseruser_id that you used ...

Hi Got it figured out - Thanks