Presentation of text in a form view

MauriceWhelan · 11-28-2019 11:16 PM

Hi I am using the expression below in the AppFormula of a VC (Long Text Type). However it will return 3 rows of data. Is there a way that I can present each row on a new line in the Long Text Area?

Is this what the INDEX() expression is used for?

Any help would be great, thank you.

SELECT(Create Works Order[Description],AND([Date]=[_THISROW].[Date],[Cylinder]=[_THISROW].[Cylinder 1],[AM/PM]=[_THISROW].[Cylinder 1 AM/PM]))

Suvrutt_Gurjar

Hi @MauriceWhelan,

Presume you mean three records when you mentioned three rows.

If so, I belive you could use SUBSTITUTE() function. Please explore if an expression something like below helps to split the list into three lines.

SUBSTITUTE(SELECT(Create Works Order[Description],AND([Date]=[_THISROW].[Date],[Cylinder]=[_THISROW].[Cylinder 1],[AM/PM]=[_THISROW].[Cylinder 1 AM/PM])) , " , " , "
")

MauriceWhelan

Hi @Suvrutt_Gurjar. Your suggestion worked perfectly. Many thanks.

MauriceWhelan

@Suvrutt_Gurjar Can I just ask what addition I can make to the expression to remove duplicate record values being returned?

Suvrutt_Gurjar

Hi @MauriceWhelan, Please try wrapping the list expression (SELECT expression) with the recently introduced UNIQUE() function.

Something like UNIQUE(SELECT(Create Works Order[Description],AND([Date]=[_THISROW].[Date],[Cylinder]=[_THISROW].[Cylinder 1],[AM/PM]=[_THISROW].[Cylinder 1 AM/PM])))