Hello all, I'm looking to create a loan calc...

(Jason Denniston) #1

Hello all,

I’m looking to create a loan calculator app that collects user data and, also, pulls data from a Google sheet in the same workbook coming from a particular cell based upon the user’s entry.

How might I accomplish this task with AppSheet?

(Aleksi Alkio) #2

Yes you can read values from another tab from the same spreadsheet or either using different spreadsheet in the same app. Without knowing your structure, you should create relationships between the user’s entry and the existing data.

Good place to start is this document… help.appsheet.com - Data: The Essentials Data: The Essentials help.appsheet.com

(Praveen Seshadri (AppSheet)) #3

And this sample appsheet.com - Quote Calculator - An app for a contractor to calculate payment owed based on services rendered. Quote Calculator - An app for a contractor to calculate payment owed based on services rendered. appsheet.com

(Jason Denniston) #4

Thank you for the replies. Say, for instance, I have a field in my app call amortization term and another field called Products. If the user chose 5 yr on amortization and 5 yr on products, I would like the rate field to auto populate 3.15%. Is that possible?

(Aleksi Alkio) #5

Your table structure should be constructed in a different way. You would need 4 columns… ID, Prod, Year, Percent. Values in those columns could be like… ID01 > 1 YEAR FIXED > 1YR > 2.95 ID02 > 1 YEAR FIXED > 2YR > 2.95 … ID10 > 1 YEAR FIXED > 30YR > 2.95 ID11 > 2 YEAR FIXED > 1YR > 3.00 …

When the structure is like above, you can call that percent with a formula like ANY(SELECT(TableName[Percent],AND([Prod]=[_THISROW].[Products],[Year]=[_THISROW].[Amortization])))

(Jason Denniston) #6

That sounds like a good idea, Aleksi. Thank you for sharing that with me, I really appreciate it.

Would I be able to link these cells from this table to a different table in the same workbook through google sheets and just update one spot and the other worksheet get updated automatically?

(Aleksi Alkio) #7

If you want that the update should happen automatically, you would need to do that with the virtual column. If you read the value from this “Percent” table in a normal column (using app formula), it will update the value only when you open/save the record.