Edit only existing rows

[siclops]

sorry total noob here, cant get app to work.
im quite proficient on excel and have created a t1 diabetic management calculator.
so i have a table with 31 headings on columns and 70 entries in rows below that are currently populated with defaults, desirable outcomes and targets. the aim is that you dont need to enter all 31 comments, only change yes to no if desirables are not met…long story!
I only want to allow editing of these in order 1, 2, 3, 4, ect.
when I use the relevant data sheet linked from dropbox, the emulator is blank, ive tried to create a form, but it is only allowing new data entries. if i uncheck the Add button, the form becomes inactive with an error.
help. thank you.

[Steve]

siclops:

I only want to allow editing of these in order 1, 2, 3, 4, ect.

“These” being columns, or rows?

siclops:

when I use the relevant data sheet linked from dropbox, the emulator is blank

The view displayed by the emulator and the data used by that view should be identified at the bottom of the emulator. Is it?

siclops:

ive tried to create a form, but it is only allowing new data entries.

This suggests the emulator isn’t “blank”, if you can see a form to get far enough to submit it.

siclops:

if i uncheck the Add button, the form becomes inactive with an error.

What do you mean by “inactive”? What is the text of the error? Where is the error displayed?

[siclops]

Thats my table.

and yes i want 70 records listed in rows, 1-70, edited in sequence.

[siclops]

Thats table mode in appsheet

its blank. my 70 entries are not there.

[siclops]

But that is form mode inappsheet.
i have restricted adding.
The read error message is because of this.

My data is not there, but it is allowing me to add to it

[Steve]

Thanks for the screenshots!

I would guess the testtable table in the app doesn’t allow adds, and possibly not updates nor deletes. In the app editor, go to Data > Tables and ensure the Are updates allowed? property allows the changes you want.

[siclops]

sorry i wasnt more precise in my nooby language and thank you for taking the time to respond.

[siclops]

I had a quick play on a rival site to see what it was like… tbh, i much preferr appsheet, but this table on openasapp is what i hoped for. thanx again.

[siclops]

thank you for helping.
i actually solved the table issue last evening, it was simple and silly. It errored my rows because of multirow formulas. It then dawned on me what these were…
I created my record list by doing = [cell above] +1, 1, 2, 3, 4. it rejected!
Manually typing in 1-70 (or doing a paste special > values) solved this error and my table entries now show with default values and are editable.
I would still like to find a solution to sequential editting though, ie, a “save AND next” action.

[Steve]

siclops:

I would still like to find a solution to sequential editting though, ie, a “save AND next” action.

Easy enough! You’ll need to create an action (Behavior > Actions) of type App: go to another view within this app with a target expression that uses LINKTOROW() and calculates the target row key from the current row key ([_THISROW]). Then attach that action to the form view’s Form Saved event action.