Is there a way to have a formula field to output a select field? That would simplify my fields so much! And make it easier to create a filter, by year, quarter, month…
Maybe it’s posible through a formula?
Thanks!
A formula cannot result in a select field, but you might want to consider using the Periods integration and an auto-linking self-relation to allow entities to be linked to the week/month/quarter/year they are in.
I will try… I did have a look when it came out, but I just find it too complicated, just to get the year/Month from a date… I want to simplify my space, and to mee that sound like an extr athing to take care of.
Being able to select what the output of the formula field is would open up so many other possibilities. But maybe I’m just used to it…Thanks
Its sounds like you simply want Fibery to support grouping by date field (week, month, quarter, year, etc.) and that the use of a formula to output a select field is a workaround.
Are there other cases where a formula giving a select field data type is needed?
A date field broken down by year, month, etc. would definitely be useful. However, I’ve come across situations where formula-driven fields in Coda produced outputs beyond just numbers or text. One example that comes to mind is invoice payment tracking - when a bank amount is entered, I used to have a formula that would automatically categorize INvoices as PAYED into a select field. Also, when enterincg an Expenses, depending on the SHop provider would categorize the expense as well… I know that this can be achieved via automations, but it just takes extra steps, and sometimes Fields, and makes it more complicated to maintain. I think this kind of dynamic formula output becomes especially powerful now that we have Pin Filters available. Hope that makes sense!