Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
From sample table we want to display only product which is selected in sheet. We are using GetFieldSelections(Product) but it is displaying multiple product if we select multiple product instead we want to display only one product at a time in text box in sheet.
We do not want to use "Always one selected value" option for Product field.
MySalesData:
LOAD * INLINE [
OrderID, Product, Quantity, Price
101, "Laptop", 2, 1200
102, "Mouse", 5, 25
103, "Keyboard", 3, 75
104, "Monitor", 1, 300
105, "Webcam", 4, 50
];
Hi @Tool_Tip , How do we determine which value to display when multiple selections are made? We need to define the logic or rule that decides the priority or condition for display. Once that definition is clear, we can apply the same logic in our implementation.
Hi Amit,
For now lets consider, first value from multiple selection.
Hi @Tool_Tip , You can use the following string function to achieve the desired result in this case.
SubField(GetFieldSelections(Name), ',', 1)