I want to know for each "country" the number of "places" => Custom Function, Cloud Function ?

Hello

  • DATA :

    • List of countries

    • List of places (with document ref to a single country)

  • CONTEXT :

I want to have the information of number of places for each country.
In order, to list only Country with Places and the corresponding number of PLaces (for sorting list)

  • QUESTION :

what can be the best way to do that ?

    • Custom code ? Cloud function ? Firebase Cloud function

    • Create a specific field in Country that is updated on each CRUD of cities OR to have a function that computes it and update the specific field ?

    • or is there any analytics tools in firebase that can do such statistics

I am new in FlutterFlow and not an expert of Data architecture. I have tried codepilot but the code has bugs.

Thanks and regards

1 reply