Populate parent field with data from child field

Support
3

Hi @tghoward!

You can definitely do these complex types of queries, I do them a lot!

  1. They do currently use async_assign and queries.
  2. You can filter the records using queries and SQL syntax. See this example: Working with Repeat groups (now Sub-forms) - #4 by Larry_Li we filter to count the # of people in the household based on the household identifier.

You could just add an age<20 to that query and get what you want. You can do something similar with counting the number green.