Hide/Show button based on two different lookup values

(0) Share

Report

Posted on by EBMRay

901

Hello everyone,

I created a button using the RibbonWorkbench tool on the Work order table.

I would like to show/hide the button based on the below simple criteria:

If the work order status = "Scheduled" and the Work Order Type = "Visit" and the Primary Incident Type = "Visit" the button should be visible else it will not be visible on the ribbon.

It seems that to achieve this requirement, I need to inject a JS as a CustomRule and JS action to the command for this button as the setup that I did below:

The JS code that I did is the below is working and returning data as expected as I have tested it in OnLoad event of the form as below:

function getFormatedName(query){
    if(query.getValue()!== null)return query.getValue()[0].name.toLowerCase();
    else return null
}

function RibbonShowHideButton(executionContext) {
    debugger;
    let formContext = executionContext.getFormContext();
    let status = formContext.getAttribute("msdyn_systemstatus").getValue();
    console.log(status);
    if(status === "690970001" || 690970001){
        let work_type = formContext.getAttribute("msdyn_workordertype");
        console.log(work_type);
        let incident_type = formContext.getAttribute("msdyn_primaryincidenttype");
        console.log(incident_type);
        let agreement = formContext.getAttribute("msdyn_agreement");
        let service =formContext.getAttribute("msdyn_serviceaccount").getValue();
        let flag = false;

         
        if(flag === false){
            if(getFormatedName(work_type) === "visit" && getFormatedName(incident_type) === "visit"){
                console.log("COndition entered");
                return true;
            }
        }
    }
}
function refreshRibbon(executionContext){
	var formContext = executionContext.getFormContext();
	formContext.ui.refreshRibbon();
	
	
}

However, after I published and opened a record that satisfies the above condition, the button is always hidden and not visible at all.

I tried to debug the button by using the command checker but it does not show the details needed.

Could you please advise why the button is always hidden and not showing?
Would highly appreciate it if you can provide an example.

Thank you,
EBMRay

All responses (7)

Answers (0)

EBMRay 901 on at

Like (1)

Report

RE: Hide/Show button based on two different lookup values

Asmaa Bouhmidi

Thank you so much, it worked perfectly!
Suggested answer

Asmaa Bouhmidi 141 on at

Like (1)

Report

RE: Hide/Show button based on two different lookup values

do not forgot to publish the solution
EBMRay 901 on at

Like (0)

Report
RE: Hide/Show button based on two different lookup values

Hi Asmaa Bouhmidi ,

Thank you for replicating the same scenario.

Could you please provide screenshots of the ribbon command settings?

I changed the code to the below but it is still not showing at all:
function RibbonShowHideButton(executionContext) { debugger; let formContext = executionContext; let status = formContext.getAttribute("msdyn_systemstatus").getValue(); let buttonVisible = false; console.log(status); if(status === "690970001" || 690970001){ let work_type = formContext.getAttribute("msdyn_workordertype"); console.log(work_type); let incident_type = formContext.getAttribute("msdyn_primaryincidenttype"); console.log(incident_type); let agreement = formContext.getAttribute("msdyn_agreement"); let service =formContext.getAttribute("msdyn_serviceaccount").getValue(); let flag = false; if(flag === false){ if(getFormatedName(work_type) === "visit" && getFormatedName(incident_type) === "visit"){ console.log("COndition entered"); buttonVisible = true; } } } return buttonVisible; } function getFormatedName(query){ if(query.getValue()!== null)return query.getValue()[0].name.toLowerCase(); else return null } /*function refreshRibbon(executionContext){ var formContext = executionContext.getFormContext(); formContext.ui.refreshRibbon(); }*/

Awaiting your response.

Best regards,
EBMRay
Suggested answer

Asmaa Bouhmidi 141 on at

Like (0)

Report

RE: Hide/Show button based on two different lookup values

hello the problem is in you code try the following

function showHide(executionContext)
{
let formContext = executionContext;
let status = formContext.getAttribute("msdyn_systemstatus").getValue();
let buttonVisible = false;
if(status === "690970001" || status === 690970001){
let work_type = formContext.getAttribute("msdyn_workordertype");
let incident_type = formContext.getAttribute("msdyn_primaryincidenttype");
console.log(incident_type);
let agreement = formContext.getAttribute("msdyn_agreement");
let service =formContext.getAttribute("msdyn_serviceaccount").getValue();
let flag = false;

if(flag === false){
if(getFormatedName(work_type) === "visit" && getFormatedName(incident_type) === "visit"){
buttonVisible = true;
}
}
}

return buttonVisible;
}

it worked for me

Please mark my answer ad verified if it worked for you
EBMRay 901 on at

Like (0)

Report

RE: Hide/Show button based on two different lookup values

Hey Asmaa Bouhmidi ,

Thank you for your reply.

I already did that configuration as you mentioned below:

I was missing to assign false for the InvertResult. However, after I published the button stays hidden knowing that the record I am inspecting already satisfies the condition.

It is really strange why it is not showing.

Could you please try to replicate the same scenario?

Awaiting your response.

Best regards,
EBMRay
Suggested answer

Asmaa Bouhmidi 141 on at

Like (0)

Report

RE: Hide/Show button based on two different lookup values

an could you try to the invert result to false
Asmaa Bouhmidi 141 on at

Like (0)

Report

RE: Hide/Show button based on two different lookup values

Hello,

can you make sure you have added the command to the button and the action and enable rules to the command