I am trying to learn formulas in QB.

Question

Clearly I am new to formulas.&nbsp;I am trying to replicate examples listed in the Sample Formulas Home. The formula I am trying to work through is:&nbsp;Color rows based on who a user is it uses this example:&nbsp;If([Assigned To]=ToUser("baker@example.com"), "pink", ""). I created a user field and then a formula to display the associated email for that user.&nbsp;My field names are [Salesperson] type: User and then [Email] type: Formula EmailWhat confuses is me is where I place this code. Does it get added to my formula email field? If so, how would the syntax look? Do I create an additional formula field and add my modified code (from the example)? Hopefully this will start to makes sense soon :)

quickbasecoachd · Answer

It looks like you are trying to color rows on a table report.&nbsp; There is a formula box on the report configuration to do row colorization. That is where the formula goes.

montgomeryhepne · Answer

That did it. It must be me, but I find the reference material lacking in that basic information. Regardless, thank you Mark.

quickbasecoachd · Answer

Well, the alternative to the help text is sitting yourself down for 30 minutes a day, every day, and getting though the free and actually quite comprehensive Quick Base university videos.

montgomeryhepne · Answer

That is fair, however, I have done that completely and still find that the formula portion is sorely lacking much detail when it comes to being thorough. I will say that they have helped me in many areas, just not that particular area.

jasonjohnson2 · Answer

The formula portion is probably always going to be lacking. The community is a great resource but takes time to search in. Another aide in formulas is taking some of the sample apps and dissecting them. I learned a lot when I first started using Quick Base by doing that. A good example is trying to learn formulas for buttons and Kirk Trachy's Magic Buttons app. I took his great foundation, learned and elevated my skills beyond what he made.&nbsp;

Forum Discussion

I am trying to learn formulas in QB.

Related Content

What are the best ways to learn how to create formulas efficiently?

Trying to calculate On Time delivery

Trying to Create a Attendance Checklist

Delete Formula Button Error

Trying to create a report with an ask users filter, but with a multiselect