Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field with values Direct & Indirect.
Now I need to create a chart that shows all the data by default.
I need to show 2 buttons 1 for Direct 1 for Indirect, when click on the buttons the corresponding data should show.
How to create the buttons and how to make the combined data chart as default..
Please explain me in clear as i am new here.
Hi,
You can create a trigger on button option or use a variable.
look the Example with trigger
Regards
Can u share sample data which is easy to rply ur answer..
Hi,
You can create a trigger on button option or use a variable.
look the Example with trigger
Regards
Hi Jordi,
That's fine.
And by default it needs to show the sum of those 2 means direct data + indirect data..
How it will be done
Hi,
You can make use of triggers.
1) First create a On open trigger to clear a field which has Direct and Indirect Values.
2)Create two buttons named Direct and Indirect buttons.
3)Create SELECT IN FIELD triggers for that two buttons.
Clear all selection it will work as by default value means Addition of Direct and Indirect..
Go to button properties and add actions as mentioned in the below inline images
Hi,
When you open the app you don't have selected any field. If you have selected a field you need to clear it. Another option is create a sheet trigger for clear all selections when open the seheet.
regards
Oh,
Yes, Thank you Mohammad & Jordi for your support..
If you want to avoid triggers then may be this.... Click on the drop down (As circled in the image) to select Direct and In-Direct: