Workflow expression

doubts
New Member

I receive a report every time a column is edited, but in my report all columns are displayed, even those that have not been changed, it is possible to ensure that columns that have not been edited do not appear and receive the report with only those columns that have been changed changed?

0 3 245
3 REPLIES 3

You could hide blank columns by wrapping the column label and value in an IF() expression.
https://help.appsheet.com/en/articles/2697069-template-if-expressions

Each line of your template would look something like this:
<<IF( ISBLANK( [ColumnName] ), "", "ColumnLabel: " & [ColumnName] )>>

You will have to experiment with line return placement. There will probably be a blank line in place of values, unless you can include the line returns inside your expression, and remove the ones around/outside it.

Thank you the information was very useful

@GreenFlux If you use << IF: >> & << EndIf >> formula, it should not add a line return if the field is blank.

Top Labels in this Space