I am having trouble getting the app to perform anything other than very basic tasks. I have attached the excel file that I am working with, the Calculator tab is where the data will be input, with the Depth value being the output. Could someone please review and tell me if this is indeed possible with this software? Thanks,
Your file is probably not shared.
it says shared publicly?
But of course you need to redesign your spreadsheet first. It won’t work with your sample sheet if it’s like that.
Yes the excel contains macros, but only very basic scripts for the reset function. I don;t understand why Appsheet cannot input data into a cell, then report out the result of another cell?
You can do that with the app, but your table structure is just not correct at this moment for that functionality. Please check this article for start… help.appsheet.com - Columns: The Essentials Columns: The Essentials help.appsheet.com
But I didn’t think I was looking for the app to read a table? I have the calculations already in the excel worksheet, is the idea to recreate this in Appsheet? I thought I am only linking fields in the app with specific cells in the worksheet?
If you need to have the result(s) at the same time when you are filling your form, you need to do the calculation directly in the app. If that’s not needed, you can make all calculations in your Excel. But still you need to redesign the calculator tab.
I don’t understand what you mean. The idea is to fill out the requirements on the calculation tab, and then have the “Depth” option calculated using the data in the other tabs.
You cant’s see results while you are filling the calculation form because when using sheet formulas you need to save and sync first.
So it cannot calculate in real time? Although disappointing, that shouldn’t really be an issue, but the app builder seems to be trying to recognise tables as opposed to single cellular input fields?
Yes, both are correct. When you save the form, you are sending the data into your spreadsheet, then sheet formulas are calculated and finally it writes the data back to your app. That’s why you won’t see the data at the same time when you are filling the form. If you need that, you should use app formulas instead of sheet formulas.
It says you need a permission.
As I said, that isn’t an issue. The issue I am having is that the app creation page seems to be looking for entire columns of data, as opposed to the single cell inputs needed for the calculation.
Yes you can do that. The reason why you need to redesign your sheet… with the app your cells need to be in a same row, not in the same column. You need to transpose your sheet… like one header row and one data row with formulas.
I transposed my first page into this format, and appsheet recognised some of the fields, but refused to acknowledge the existence of any of the slightly more complex functions. To top it all, it still would not feature the “depth” field as an output, which is the whole point of this endeavour.
Are you able to share that one as well?
How can I amend that?
Copy the link from the “Get shareable link”