Here is my DB:
I want to update the fullName of a member in multiple locations all at once. The fullName of a member is inside AnnualDue, MemberFee, and Faculty.
Asked
Active
Viewed 44 times
0
-
Have you tried [Transactions](https://firebase.google.com/docs/firestore/manage-data/transactions) and barched writes? Can you have a look at this [StackOverflow thread](https://stackoverflow.com/a/57653880/18265570)? – Roopa M Oct 21 '22 at 13:50
-
I think it cannot be achieved using transactions and batched writes because the IDs are unknown – Vince Ybañez Oct 21 '22 at 14:01
-
Does this [StackOverflow link](https://stackoverflow.com/a/61136301/18265570) helps you? – Roopa M Oct 23 '22 at 08:24
-
@RoopaM not really. I did not find any solution in that link. In fact, I did not find a solution even in Firestore documentation. I guess I have to run multiple queries from different collections at once and then update at once but I think its a bad practice and can cost me a lot. – Vince Ybañez Oct 25 '22 at 05:22
-
How about considering maps as discussed [here](https://stackoverflow.com/a/46945340/18265570)? – Roopa M Oct 25 '22 at 07:49