Workflow:
- User fills out number inputs in bubble.io app.
- Those numbers are sent to GSheet to certain fields in the table (e.g. E12, G12, T5)
- In that GSheet there are OUTPUT fields where GSheets formulas are made and I want those fields to be sent back to bubble.io app.
I have 2 problems:
- I have several users and they work with the same GSheet and same resources, therefore, there are conflicts. (I was thinking about having separate resources(e.g. fields/sheets) per user but don’t know whether it harms scalability)
- GSheet in theory should proceed formulas only when Gsheet is opened.
Do you have any experience with similar issues, guys ?