Rollbase - auto filling fields when object selected

Hi,

I think this can already be achieved by adding a trigger. After selecting the country, a trigger can be fired off to look up the country code.

Have you tried this already ?

Thanks,
Sven

FYI... there is an "Ideas" section in Community where Ideas for Rollbase new features such as this one can be posted.  Other users can see your ideas and vote on ones that appeal to them.  

Ideas can be posted at: https://community.progress.com/businessusers/i/rollbase/default.aspx

The root page for all Ideas is here.

Hi,

Yes by triggers it's possible. But the triggers execute after clink-on the Save button. I would like this operations run just after selecting the country.

Thanks.

Sorry Bill,

I wasn' t aware of this section.

Hi,

This feature is already possible in Rollbase using field events and client-side APIs. For more information on this topic, please refer to chapter 7 of Rollbase in Action. Below is the link to the latest version of the documentation:

https://www.rollbase.com/download/Rollbase_in_Action.pdf

Regards,

Godfrey

Thanks for your replies !

I read the Chapter 7, but not work.

I have a Contact object. With first name, last name fields and related object Company.

I would like auto fill the email field. Composed by "firstName.lastName@company.com".

On my page,  I add Javascript, but not working.

<script>
function setEmail() {

if ($("#nom").val().length > 0 && $("#prenom").val().length > 0) {
        $("#email").val($("#prenom").val().toLowerCase() + '.' + $("#nom").val().toLowerCase() + "@");
    }
    
if ($("#email").val() == ".") {
    $("#email").val("");
}    
}

//select company
function my_callback(relName, objId, values) {

    alert(relName + '-' + objId + '-' + values);
}

function getSociete() {
    rbf_getRelatedFields("R11603", id, "name", my_callback);
}
</script>

Thanks and Regards,

Have you tried binding the getSociete() function to the onchange event of the field? You may do this by navigating to the events window of the lookup field.

Also, I recommend you to use Google Chrome as your browser in debugging client-side codes. Once installed, you may press F12 to enable the developer tools. The console tab should display any error in your script.

Yes,

getSociete() function is already on the event field. And chrome is my default web browser. But when I'm in debugging mode, the callback function not called.

I noticed an error in the script you made. The variable id is not defined. A record id needs to be assigned to this variable for your script to work.

Kindly replace your function with the code below and see if it works:

function getSociete() {

   var id = rbf_getFieldValue("R11603");

   rbf_selectValue("SELECT name FROM your_object WHERE id="+ id, my_callback);

}

Important: Replace your_object with the integration name of the object you are trying to query.

Hi,

Thanks Godfrey. It's work !

I told myself, the variable id isn't defined.