Hi everyone - I made this form/calculator on google sheets/ excel and I’m trying to turn it into a streamlined webpage on my Google Sites website. I was directed to this app to help with the coding/integration. I’ve watched all of the intro videos that I found, but it doesn’t seem to point me into the right direction on setting up inputs/outputs (and if possible, a lot of if-statements). If there are any videos or tutorials out there that would help, I would greatly appreciate it! I’ve uploaded this .xlsx into my project, but don’t have any clue of where to start on the data table. I just want users to be able to open the webpage, type in some numbers, and get a handful of output results. There is no data storing or accounts, just a simple calculator website.
Hey @angeliKITTYx, and welcome to Glide!
Check out Glide University or for a faster solution:
Check this out and take a look at his other videos as well, u will learn a lot!
I checked the formula you have in the sheet. They should all be replicable in the Math column in Glide.
Please let us know if you need any help. Set up a form with user-specific column for “purple” inputs, and then calculate them using math columns to display the results.
Think of it this way. A traditional database has rows of data. Each row represents a single item with multiple pieces of information (columns). Your Excel sheet does not resemble a traditional database. You are basically representing one item (one calculation scattered across multiple rows and columns of inputs and outputs). You have inputs in multiple rows and your calculations cherry pick from multiple cells in multiple rows to to give you a result. In Glide however, everything would need to be in a single row to get the same result.
In your case you will most likely only need a single row. You will have multiple basic columns to store the inputs and multiple math and IF columns to handle the logic. So everything will happen on that single row instead of jumping around across multiple rows. You will need to build it out from scratch since the way you have your Excel sheet designed will not translate to the same experience in Glide and traditional database structures in general. The front end layout is where you add the entry components for the user to fill out and and display the results from the math and IF columns.
The next thing to consider is how you expect the results to be displayed. In excel, all calculations happen in real time as you type. Do you want that same experience, or do you want more of a form experience where a user types their inputs, clicks on submit, and only then do they see the results? Will you be storing all of these results to view later, or is it is more of a throw away calculation? Your answers would determine how you configure a few things, such as using a form or a detail screen (custom form), or whether or not you should use user specific columns.
