topic Single value in text in App Development

Single value in text

Tool_Tip — Wed, 08 Oct 2025 05:26:55 GMT

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
];

Re: Single value in text

Amit_Prajapati — Wed, 08 Oct 2025 06:40:18 GMT

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.

Re: Single value in text

Tool_Tip — Wed, 08 Oct 2025 08:01:36 GMT

Hi Amit,

For now lets consider, first value from multiple selection.

Re: Single value in text

Amit_Prajapati — Wed, 08 Oct 2025 08:47:38 GMT

Hi @Tool_Tip , You can use the following string function to achieve the desired result in this case.

SubField(GetFieldSelections(Name), ',', 1)