Read-only data form and unbound fields

[matthewmoran]

Fairly new to AppSheet. Lots of experience with Google Apps Script, SQL, Power Platform, and more.

Question:
How does one build an app that only uses a sheet for lookup data - no records are created or saved. It is simply a guided window/app to view existing data and a form to provide some calculation results.

I'm building a small app (1 view) that will read data from a sheet primarily for cascading lookups. The users will not be adding or editing rows.

Fields in sheet: Region, Site, EmployeeType, Rate

View will display:
-Region (drop down)
-Site (drop down based on the region)
-EmployeeType (drop down based on the Region & Site)
*Rate will not be displayed

I'll provide two text/numeric entry fields - though the data will not be stored. Those fields are:
- Contract Weeks
- Weekly Hours

Once they enter the weeks and hours, it will calculate an amount based on:
- (Rate * Weekly Hours) * Contract Week

I'm struggling with understanding how to create a form when the underlying data is read-only. AppSheet gives an error message. However, the data is only meant to create drop-down list that are populated only by prior drop-down list selection. Additionally, how do I create two textboxes that are not bound to any data?

I have already created drop-down list that work based on prior selections. But that was with editable data.

This is, of course, SUPER simple to do if I code the HTML myself or if I use Powerapps. I can add fields that are unbound and attach actions to those fields. Hmm...

Any guidance is appreciated.

Thanks,
MM