I have a table where my employees submit orders/requests.
I would like to automatically show a column in the table by who submitted the request. I would like to pull this info from the members data instead of having to type it in every time.
Any ideas?
Hello.
If your employees submit this information while logged-in, you can do the following:
- Get currently logged-in user email;
- Query the PrivateMembers collection for the email;
- Return the Name (name) field of the PrivateMembers collection and insert it to the orders/requests database with the rest of the order information.
Good luck!
Sam,
Thank you for the response…
Any idea of how the code would look or where I could find something similar?
I have very basic coding knowledge… any help would be appreciated!
Thank you!