When you create a form the single select field only allows for the person inputing information to select from the options in the drop down. You can limit options a bit more by selecting the field and enabling "Limit selection to specific options" Ho...
Sorry you are having trouble @CPMSM I'm not really sure why you might be getting an error. I tested the formula in my test base before I sent it to you. Here is a link to it working. Perhaps that might help. I remember getting a error at one poi...
I would likly do this by adding in the switch function. For this I woudl create a field call 'Rubric' which Swtich() evalauted as being one or another condition. In the example below I use the term 'Piano' or 'Instrumemental' as single select optio...
