there’s an option to add a multi-select filter to a table on a Text field which contains 2 value either “XYZ” or blank,
i have already applied below options, but all are failed so please help me to resolve this usse on a very urgent basic,
1.Convert text into Picklist and add manual picklist enties values,
2.Convert text into Picklist and getting picklist values from snippet
var params = arguments[0],
$ = skuid.$;
var entries = ;
entries.push(
{ value: ‘XYZ’, label: ‘XYZ’, defaultValue: false},
{ value: ‘’ , label: ‘Blank’, defaultValue: false}
);
return entries;
3.https://community.skuid.com/t/auto-create-blank-as-a-filter-option
when i select blank option from the filter drop down, then after apply it , it removed the blank selection and i want to filter out all the blank records
Add Blank option to the Text field on Table filter
+3
+6Dear Akanksha, thank you for reaching out, blank/empty/null values can be tricky. In case you haven’t found a solution in the meantime, I hope our findings are helpful for you. If we understood your requirements correctly, that you need to be able to offer an “empty” option in a multi-selection filter, below is what we did to make it work. In order to be able to share the page XML with you, we used only Salesforce standard objects and fields: Opportunity object and the fields “Name” and “NextStep”.
- Override field metadata of the "NextStep" text field so that it's displayed as a picklist.
- Manual picklist entry: XYZ
- Please note that we didn't add an extra "blank" option.
- Added an inactive condition named "NextStepEmpty" to filter for empty values.
- Added an inactive condition named "NextStepValue" to filter for multiple values.
- Condition Grouping Logic: "1 OR 2"
- Added a filter of type "Multi-select Option" to the Table component.
- Pick Options and Condition(s) = Manually
- Model Condition to Affect = NextStepValue
- Now we added two different manual sources, first: Picklist option to affect the default condition.
- And "Manual" to affect the other condition, simply to "Activate" the "NextStepEmpty" condition.
If it still doesn’t show the expected result, please share more information about the result you see on the test page and the result you would expect.
Regards, Luzie & team
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.