online beautifier for complex formulas?

AppSheet AppSheet Q&A
1

Hi all,

I would like to “beautify” complex formulas and looking for an online tool.

e.g.:

AND(CONTAINS(LOOKUP(USEREMAIL(),"Mitarbeiter","MA-Email","MA-Rolle"),"Team-Manager"),CONTAINS([Vorg-Status],"3"),ISNOTBLANK([Vorg-intern weitergeleitet an]))

should be beautified to:

AND(
   CONTAINS(
           LOOKUP(
                 USEREMAIL(),
                 "Mitarbeiter",
                 "MA-Email",
                 "MA-Rolle"
                 ),
           "Team-Manager"
           ),
   CONTAINS(
           [Vorg-Status],
           "3"
           ),
   ISNOTBLANK([Vorg-intern weitergeleitet an])
   )
1 Like
2

I don’t know of any tool to automatically format (e.g., insert line breaks and indents) AppSheet expressions. In case you’re not already aware, @QREW_Apps 's appsheettraining.com has a great Chrome extension that helps with many aspects of expression editing. See https://appsheettraining.com/article/appsheet-toolbox-chrome-extension.

3 Likes
3

Thank you @dbaum , I am using this toolbox and it is very helpful.
Unfortunately the “Quick Access to AppSheet Documentation in the sidebar” is not working any more, “support.google.com hat die Verbindung abgelehnt.” which means “support.google.com has refused the connection.”

1 Like
4

They probably haven’t updated the extension following the migration of AppSheet help to a new location.

1 Like
5

This one is not so bad: Excel Formula Beautifier

2 Likes
6

I think the best way is by doing it yourself.

You get used to do it manually

3 Likes