I am stuck with a type of constraint I am trying to setup.
In my database I have 2 data types, that each have fields:
> Credits (number)
> Notes (text)
I want to do a search with the following constraints:
Show me all users whose Credits value is greater than the amount of notes they have created.
In my workflows, I do a search for users. Then I add a constraint:
Credits > Search for Notes:Count
The above search is not correct because it is looking for users that have credits value that is greater than the count of note entries for all users. Now I need to add a constraint to “Search for Notes” so it only compares the users credits to notes that user has created.
When I click “Search for Notes” I can add a constraint. I can choose “Created by”. I am not sure what to make this equal to.