Auto format formulas

[Scott_L]

any tricks for auto formatting a formula in the Formula editor?

[MultiTech]

What do you mean?

[Scott_L]

Code editors often have a way to format code into something more legible. Taking something like

SeLeCT(Territory[OriginalCountry],anD([OriginalCountry]<>[Country],[OriginalCountry]<>[_ThISROw].[Name],[Country]=[_ThISROw].[Name]))

and reformat it to something like

SELECT(
Territory[Original Country],
AND(
[Original Country] <> [Country],
[Original Country] <> [_THISROW].[Name],
[Country] = [_THISROW].[Name]
)
)

[Steve]

FREE Chrome Extension that enhances the Expression Assistant [AppSheet Toolbox/QREW Tools] Tips & Tricks 💡

Hi AppSheet Community As someone who is in the App Editor 24/7, I frequently catch myself trying to remember the syntax for a particular expression, re-reading a formula several times to figure out where my missing parentheses are, or searching my mind for some fancy formula I put together ages ago. I know many of you have experienced the same. To make life a little easier on our favorite app making platform, the QREW Technologies team has released the first version of a Chrome Extension, QR…

[Scott_L]

hmm, I did actually start using that extension just today. (Highly useful, thanks Crew). But not seeing the formatting feature kick in yet …

[Steve]

I’m not aware of any tool that works as you want.