@wpda_wp_user_id

Hi @mahoney,

Could you send us more details about your table? Is this for a data table or a data project?

You can also send us a message in Contact | WP Data Access if you want to share more information privately.

We’ll wait for your response!

The table is simple: id, item, image, wp_user_id

what I need to happen is when a logged in user creates/edits a record is for the @wpda_wp_user_id to be passed into the record for wp_user_id.

I guess this would be a data project since it needs to be on the front end forms.

Hi @mahoney,

Thanks for the clarification!

I think you need to set a trigger for that if you want the current logged in ID to be entered when editing/inserting a new record.

Please see more information here: WordPress user ID – Database triggers

Let us know if that helps! ??

Thank you for the reply. I found that using the Environment Variable $$USERID$$ placed in the Default Value under Project Templates >>Data Entry worked for me. I unchecked Visible and checked Read Only.

Triggers look very interesting, where would I place the code for a Trigger?

Hi @mahoney ,

On behalf of Kim, you are most welcome!

You can execute the triggers via query builder.

Please see: https://wpdataaccess.com/docs/query-builder/query-builder-getting-started/

Let us know if you have further questions.