I am designing an app that helps Billers manage billing Payers. It is solely designed for Billers and Payers will not have access to my app. Billers are responsible for adding Payers and inputting their bill details. I am trying to better understand how all this data is managed within the Glide template in order to leverage Glide in the most appropriate way.
Some questions that I was hoping to get feedback on:
Should I consider each Biller to be an Administrator? Or am I the Administrator and each Biller a User?
Will all of my Billers data reside in a single Google spreadsheet that is on my personal Google Drive and that I (the app owner) own/control? Will each tab (eg. Payers) have a listing of all Billers info (eg. all Payers for all Billers) differentiated only by the Users email address?
What concerns should I have (if any) with respect to lag time etc. if multiple people are simultaneously using the app?
@ThinhDinh do you know if a Lookup value calculated within the Data Editor can be used in a formulae that only exists in your google sheet? To be clear, there is a specific value I have calculated that exists in my data editorâŚI am trying to used this value within a formula that is in my spreadsheet. I know how to display this value in the appâŚbut I donât know how to actually access it from my spreadsheet.
@ThinhDinh I fully understand your recommendations regarding the increased lag time if calculations are done on the sheet. But I was more interested in finding out how you âpushâ data from a Lookup value calculated in the Glide editor into a specific cell in your sheet (if you want to). I did not know you could âpushâ data from the Data Editor into a specific cell in the sheet. How is that done? Can you please explain?
I am trying to get a derivative of a value that is selected by a user when a form is submitted. Right nowâŚthat value is going to cell b2 in Tab 1. The derivate is calculated in cell b4 of Tab 1 using a Lookup function in the data editor. I would like this b4 value in Tab 1 to automatically appear in cell a1 of Tab 2 and have written an index/match function (that points to b4 in Tab 1) to get it. Hence, my interest in finding a way for the Lookup results to be accessible to a formulae that is within my sheet. I hope that makes things clearer.
You can use a form to capture that via âColumnsâ component, not sure if that works with your flow but currently thatâs the only way to push Glide-calculated columns to the sheet.