Skip to content

x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 70 subscribers
  • Views 167 views
  • Users 0 members are here
Browse Forums
Announcements
143
topics
32
replies
General Discussion
5k
topics
16k
replies
More Content
RBC_1

Using an On Change event for a user select - can I set a field value to a user field value?

Posted By

Hi
On a custom entity entry screen I have a user select field and also a 'rate' field (Proj_Rate). 
I'd like to set the rate field to the value in the selected users user_rate field, but I'm struggling to pick up the selected users value instead of the current users!
Any pointers?
I need this to be stored against the record as the rates can change weekly, so all entries will have the current rate for reporting purposes.
Thanks

Parents
  • 0

    Hi RBC_1

    If it is not needed immediately, then I always tend to use SQL Triggers, so once you have selected your user and then saved the record. The trigger kicks in and populates what other fields are necessary (e.g. a Rate field, or to perform a calculation).

    I tend to do this only as that is where my strengths are. 

Reply
  • 0

    Hi RBC_1

    If it is not needed immediately, then I always tend to use SQL Triggers, so once you have selected your user and then saved the record. The trigger kicks in and populates what other fields are necessary (e.g. a Rate field, or to perform a calculation).

    I tend to do this only as that is where my strengths are. 

Children
No Data

*Community Hub is the new name for Sage City