coherentkris

Custom Function Request

Discussion created by coherentkris on Sep 16, 2016
Latest reply on Sep 16, 2016 by David Moyer

I need a custom function that i can replace this mess with...

Substitute ( "<filter " &

List (

If ( IsEmpty ( field_one ) ; "" ; "field_one=" & Quote ( field_one ) ) ;

If ( IsEmpty ( field_two ) ; "" ; "field_two=" & Quote ( field_two ) ) ;

If ( IsEmpty ( field_three ) ; "" ; "field_three=" & Quote ( field_three ) )

) & " />" ; "¶" ; " " )

 

This essentially turns a record into a line of xml.

If record values field_one="family" and field_two=""" and field_three="values" would output

<filter field_one="family" field_three="values" />

 

I would like to supply a list of fields into the function.

 

Been a long day and my brain is full.

Outcomes