About Bus_Mom

Bus_Mom · 11-30-2019

Regular expressions are my favourite. They’re amazing for processing data of all kinds, especially in the context of data input by many people because it recognises patterns. They’re also so universal, which makes them great for AppSheet, which integ...

Bus_Mom · 06-02-2020

Woohoo!! This is awesome. I was trying to figure out a way to put multiple columns side by side in a report and adapted the MOD() suggestion (thanks, @Aleksi). I tried using row numbers like the example, but that only worked for 2 columns and those c...

Bus_Mom · 05-29-2020

I do this using SWITCH() and CONTEXT() in the Display Name expression. Then I can show different labels based on View Type (table, detail, etc) or on specific Views (name of the view where you don’t want to show the column name). SWITCH works well be...

Bus_Mom · 05-19-2020

Haha. Stumbled across this and I totally feel ya, @Brady_Lovell. It’s an old topic but figured I’d put my workaround in here in case anyone else wants to control phone number format. I’ve got the [phone] column with data type Phone, which only shows ...

Bus_Mom · 12-02-2019

Oh nice!! I see what you’re doing there. It makes a lot of sense that you can reference a virtual table that was automatically created through relationships, but I hadn’t realised that yet. What an awesome new way to understand the AppSheet data conn...

Bus_Mom · 12-02-2019

@SKETCHwade Ooh. Actually, on second thought the formula needs to be set as an action triggered by a workflow, not in the app formula. If there’s an app formula, the user can’t override the value, so mechanics won’t be able to change any record to [F...

My Stats

Bus_Mom's Bio

Badges Bus_Mom Earned

Recent Activity

Regular Expressions, Please

Re: Columns on report template

Re: Change appearance of headings or "display names"

Re: How can I force my users to populate the phon...

Re: Search for latest date in another table

Re: Only show latest row from each ID

Bus_Mom's Ideas (1)