Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

I have a page that has a Plus and a Minus button that when clicked will increase or decrease the current value displayed in a label by one. In my database I have a column whose data I would like to place in the label to be adjusted by the Plus or Minus buttons (if the value of the column in my database is 5, then 5 would appear in the label and the Plus or Minus buttons could adjust that number). Then I would like to take that new number and update the column in the database to reflect that number. I have tried many of the tutorials and documents (as well as some youtube webinars) but I can't quite figure it out. I'm new to Appery.io so I apologize if this is a really basic question.

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Reading, Modifying, and Updating database column values

Hi Dustin,

Please show us what exactly you tried and what doesn't work.

Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

I've tried using the read service for the database to retrieve the number from the column in the database and have that sent to the label by mapping the response to the label. Then I have the Plus and Minus buttons to adjust the number, then the submit button invokes the update service for that database which has the label mapped to the appropriate column. I can send more images once I'm back at my PC this evening if it will help. I've attached a picture of the error I'm getting. I know I'm either doing something wrong or missing something...I don't have a lot of programming experience so a lot of this is very new to me.Image

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Reading, Modifying, and Updating database column values

Hello! Could you post your mapping screenshot and JS you use for + and - buttons?

Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

Hopefully this helps. Here are the mapping shots...JS is on the wayImageImageImageImage

Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

And here's the JS...sorry for the photos...the system I had access to doesn't allow screenshotsImageImage

Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

Sorry for the photos...the system I'm on at the moment won't allow screen shotsImageImage

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Reading, Modifying, and Updating database column values

Hello Dustin! Sorry for delay, but photos are not readable. Could you please post them in other size?

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

Reading, Modifying, and Updating database column values

Hello! Could you share your app with a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a?

Dustin Moore
Posts: 0
Joined: Thu Dec 12, 2013 6:03 pm

Reading, Modifying, and Updating database column values

It has been shared. I think I have more to learn about databases so I'm going over more of the support material and I'll try again once I have a better understanding. Thanks

Return to “Issues”