This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

App input to output on spreadsheet error

Posted on 09-01-2022 08:03 AM
opdemonchy
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

 

Hello people, 

I am having a big problem at the moment. I have been working on an App for a while now. A few days ago everything worked fine. I tested the app and every input in the App appeared on my spreadsheet I linked it with. After that I have been adding things and changing things.  I have 71 Columns so I have been changing a lot. Appsheet gives me these small warnings (but it has been doing that the whole time). However, I don't think this is the problem. I will show the warnings here:

opdemonchy_1-1662043302656.png

So everytime I put in data in appsheet and I sync, it also syncs with my spreadsheet, the only thing is that the given input will not show in google spreadsheet. I got a feeling it has to do with some new colums I put in within the spreadsheet. These colums are 4 columns with functions within spreadsheet (not within appsheet). Everytime I fill in things in appsheet, the functions dissapear in the 2th row in spreadsheet. So the whole row 2th row is blank except for 2 columns (2 with functions) the other 2 dissapeared.

opdemonchy_2-1662043895415.pngopdemonchy_3-1662043947519.png

As you can see everything is blank and the two functions on the 2th row dissapeared. 

Another column I newly added was without a function. In these pictures below you see the NEW column I added, but did not want to show (injury prevention score). I don't know if it is of any use but I want to show as much as possible. As you can also see below is that I added 'a new client' (the input) and it is not showing in the spreadsheet. 

opdemonchy_4-1662044118933.pngopdemonchy_5-1662044355555.png

I have been working on this for a lot of hours. And now I have the feeling it gives up on me. I am really lost, since I am a newby in this field of work. I really hope one of you can help me. If I need to provide additional information I will be happy to. 

Best regards,

Olivier

 

 

0 1 77
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
1minManager
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

So I think the most immeditate issue is that you're using a combination of Appsheet and spreadsheet formulas.  The later is why you're getting the read only warning.  If appsheet sees that spreadsheet cell has a spreadsheet formula then it sets that as read only in the appsheet editor.  So in the example above where you have this in column U:

P2+Q2+R2+S2+T2

you need to delete that and instead go into the settings of the [TOTAL SCORE VRAGENLIJST] column and set the App Formula to be

[Vraag1]+[Vraag2]+[Vraag3]+[Vraag4]+[Vraag5]

 Do that with all the spreadsheet formulas and see if that fixes some or all of the issues

Simon@1minManager.com

Top Labels in this Space