I am trying to create a "product selection" tool using checkboxes as the filter. Ultimately I am trying to get it to work conceptually like a common website shopping cart filter.
Notes:
Examples:
Hi @AGS94 ,
Could you tell me are color,component and material three fields?
If so, you could try this formula:
(color is checkbox1-3, component is checkbox 4-6, material is check box 7-9)
Set checkbox1-3's OnCheck and OnUncheck:
ClearCollect(a,{color:"Red",value:Checkbox1.Value},
{color:"Blue",value:Checkbox2.Value},
{color:"Green",value:Checkbox3.Value})
Set checkbox4-6's OnCheck and OnUncheck:
ClearCollect(b,{component:"Button",value:Checkbox4.Value}, {component:"Snap",value:Checkbox5.Value}, {component:"Zip",value:Checkbox6.Value})
Set checkbox7-9's OnCheck and OnUncheck:
ClearCollect(c,{material:"Cotton",value:Checkbox7.Value}, {material:"Wool",value:Checkbox8.Value}, {material:"Blend",value:Checkbox9.Value})
Set the drop down's Items:
Filter(tablename,color in Filter(a,value=true).color,
component in Filter(b,value=true).component,
material in Filter(c,value=true).material
)
Set the drop down's Vlaue: Numbers
Best regards,
Community Support Team _ Phoebe Liu
Thank you Phoebe. I will take a closer look at your recommendation.
Hi @AGS94 ,
Have you solved your problem?
Best regards,
Community Support Team _ Phoebe Liu
User | Count |
---|---|
135 | |
133 | |
79 | |
75 | |
71 |
User | Count |
---|---|
210 | |
201 | |
69 | |
62 | |
53 |