online beautifier for complex formulas?

[Joachim_Mund]

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

[Joachim_Mund · Accepted solution]

This one is not so bad: Excel Formula Beautifier 

[dbaum]

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. 

[Joachim_Mund · Accepted solution]

This one is not so bad: Excel Formula Beautifier 

[Joachim_Mund]

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."

[dbaum]

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

[SkrOYC · Accepted solution]

I think the best way is by doing it yourself.

You get used to do it manually