any tricks for auto formatting a formula in the Formula editor?
What do you mean?
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]
)
)
1 Like
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…
3 Likes
hmm, I did actually start using that extension just today. (Highly useful, thanks Crew). But not seeing the formatting feature kick in yet …
I’m not aware of any tool that works as you want.
1 Like