
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 09:14 PM
I have a requirement for a couple of fields to be populated with the appropriate information once a customer adds the name of the 'owner' of a dashboard - that persons email and department needs to then be added to the appropriate fields.
I have checked a number of forum posts similar, tried most of them and still can't get it to work, so here I am asking directly.
So based on the Owner name being added (which shows as the first name and surname - eg: Joe Bloggs) - note: it is almost certainly not going to be the name of the user entering the details.
owner_section would map to the 'Department' field
owner_email would map to the 'email' field
I believe all are available through sys_user
Also as a side question - is it possible to allow free text in a reference field if someone needs to enter something that is not available to select?
If someone could let me know how to do this I'd certainly be grateful.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 10:41 PM
Can you make that variable as reference and refer to cmn_department table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 09:29 PM
Try below code in onChange catalog client script,
var caller = g_form.getReference('owner_name', doAlert); // doAlert is our callback function
function doAlert(caller) { //reference is passed into callback as first arguments
g_form.setValue('owner_section',caller.department);
g_form.setValue('owner_email',caller.email);
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 09:36 PM
Nope, still nothing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 09:39 PM
Can you share youre code? also database name of all the fields. And don't forgrt to set UI type to ALL in client script to work it on portal.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 10:01 PM
Thought I did that in my original post?
These are variables and I've named them what I have on the original post
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2018 10:15 PM
Hi,
The code provided by me has worked for me. Can you share screnshot of onchange client script?