My goal is to have a simple gSheets based calculator that is publicly available and usable by multiple users simultaneously. I am open to different ways of doing this, but my approach so far is like this:
-Have 3 unique numerical input fields
-Have 1 numerical output field
The issue I am having is that:
- Input from one user overrides the input from another user, so it can only be used by one user at a time.
- The output field is very slow to update. It takes about 6 seconds to multiply 3 triple-digit values together on the Glide portal. Note that the output field in gSheets updates instantaneously.