I am having trouble getting the app to perfor...

(Dan Buckingham) #1

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,

(Aleksi Alkio) #2

Your file is probably not shared.

(Dan Buckingham) #3

it says shared publicly?


Hi @Dan_Buckingham

Do you have macros in your excel sheet?

(Aleksi Alkio) #5

But of course you need to redesign your spreadsheet first. It won’t work with your sample sheet if it’s like that.

(Dan Buckingham) #6

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?

(Aleksi Alkio) #7

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

(Dan Buckingham) #8

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?

(Aleksi Alkio) #9

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.

(Dan Buckingham) #10

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.

(Aleksi Alkio) #11

You cant’s see results while you are filling the calculation form because when using sheet formulas you need to save and sync first.

(Dan Buckingham) #12

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?

(Aleksi Alkio) #13

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.

(Aleksi Alkio) #14

It says you need a permission.

(Dan Buckingham) #15

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.

(Aleksi Alkio) #16

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.

(Dan Buckingham) #17

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.

(Aleksi Alkio) #18

Are you able to share that one as well?

(Dan Buckingham) #19

How can I amend that?

(Aleksi Alkio) #20

Copy the link from the “Get shareable link”