Hi: I’m refining my project management app: I have a Task that already has a Workflow field “State”. I wanted to add another Workflow field: “Blocked” (which be auto-assigned via an automation). However I’ve just discovered that when I got add a Workflow field: it’s only available if the Database …

It’s true that there can only be one workflow, but the single-select workround suffices in most cases. It might be possible to use filters in one or more automations to achieve the dynamic setting of a single-select value. It depends what you need to achieve. Alternatively, you can dynamically set…

Thanks: so is using a formula to set a single-select field a non-starter? ie. formulae can only create numbers, text, checkboxes, etc. but not single-selects? I’ve got the formula working for a checkbox, but unfortunately I can’t use a checkbox as a column in a Board View: hence wanting to use a s…

Hey Masp what are you trying to achieve that would require 2 workflows in a database? Maybe there is a different way to reach your objective?

I’ve got a Task Database: I’ve created a self-relation many:many Task<->Task which represents dependency (“Blocks” and reciprocal “Blocked By”): that works fine. Then I created a formula “Blocked” defined as: If(([Blocked By].Count() = 0) or (State.Name = "Done"),false,[Blocked By].Filter((Blocked…

BTW this brings up an issue I noticed a few days ago when I created another self-referential relation (in my Tag Database): if a Database has a self-referential relation which is 1:1 or 1:many then the List view and Smart Folder both provide a wonderfully useful feature: a small circular arrow icon …

[image] masp: Now I’m just trying to figure out how to surface blocked Tasks Couldn’t you just create a table view with a filter for Blocked = true (and with the workflow column showing so that you can update any tasks as necessary)? [image] masp: Then I created a formula “Blocked” defin…

[image] [DONE] Many-to-many relationships should be usable for levels in lists Ideas & Features I have [Product] *------* [Feature]. (Features belong to products, but some features span multiple products; e.g. “2FA” is a feature of both the backend CMS and of the mobile ap…

Perfect! (I think you actually referred me to this before, so apologies for not comprehending the relevance at the time!!). Any idea how long that feature is likely to take? I see development just started, so I would guess it’s a few months away?

Can I have more than one Workflow field in a Database?

Get Help

Chr1sG February 5, 2022, 9:20pm 8

Topic		Replies	Views
Cannot create field (in workflow) Bugs & Issues	7	289	March 21, 2023
Ability to set single-select formula value? Get Help	23	1598	November 26, 2024
Conditional Workflow State Management Get Help	10	164	June 9, 2025
Create a multi-select field whose options equal all item names in a database Get Help	5	38	March 12, 2026
Best way to define new workflow states Get Help	6	831	May 6, 2022

Can I have more than one Workflow field in a Database?

Related topics