Differences in User data manipulation options for App Info vs. User Table selected user vs. trigger editor specified user

Support, Troubleshooting, & Help
, , , ,
1

I am noticing some differences in trigger behavior when trying to save user data to tables. There are inconsistencies between using a trigger acting on the attributes of the (1) app info current logged in user, vs. (2) a users table record placeholder or (3) a specific user selected in the trigger editor (including the User>Current Logged In User drop-down option).

image
image332×100 4.52 KB

  • Not all Users Table fields visible in the CSV exports (both “standard” and “custom fields” CSV exports from the Users Table) are exposed for data manipulation triggers, e.g. “Badge ID”
  • Table Field: User
    I am able to use a trigger to write the User data type for a user to tables data for all three scenarios
  • Table Field: User Text 1
    I am able to use a trigger to write the UserName data only for the current logged in user (“Username”), not for a trigger-drop-down specified user (“User Name”), nor for a users table record placeholder user (“User Name”) - for the (“User Name”) I can specify in the trigger but there is no result in the table
  • Table Field: User Text 3
    I am able to use a trigger to write the User’s Name for the current logged in user (“Name”) and a trigger-drop-down specified user (“Name”), but not able to specify this in a trigger for a users table record placeholder user
  • Table Field: User Text 3
    Casting TOTEXT(user) works for all three scenarios

image
image1418×228 14.1 KB

Top= (1) app info current logged in user
Middle = (2) a users table record placeholder
Bottom = a specific user selected in the trigger editor (including the User>Current Logged In User drop-down option)

image
image1333×782 50.6 KB
image
image1301×706 45.4 KB

image
image1329×783 52.3 KB

image
image360×513 17.1 KB

image
image363×517 21.1 KB

2

Thats right. There seems to be no propper way to get the User-Details from a User type Variable, App Info or Table Record.
Only the hardcoding of a User (in Expression editor or in the user select dropdown in the trigger) allows this (or a Placeholder on the Users Table).

This detailed selection should be available on User objects in the Trigger editor for variables, App Info and Table Records as well…

@Beth Is there a bet practice to display details from variable user types?