Specialty code in forms

Ask the community
, , ,
1

I have a database with many fields, and among them I have the fields gold, gold price, sold gold, and account. I would really like my members to be able to log in, and fill out a form selling their gold. I want the gold they want to sell to be subtracted from the amount of gold they currently have in the database, and added to the sold gold field. And, I also need to take the amount of gold they sold, multiply it by the gold price, and add that amount to the account field. All of these fields could have data that is already in them as well. I would like to be able to add to the appropriate fields, and add to the amount currently in those fields. I’m pretty sure I have to use some front end code and back end code. However, I am stumped after weeks of trying different combinations. Any help, with any of this, would be greatly appreciated.

Thank You!
Sincerely,
Harry

2

Hey
To be able to help you out, design your pages like you want them to look for your users. Then take screenshots with JING and comment and draw the workflow you want on the different screens. Then it will be easier for me or anyone to help you and send you code.

3

Ok, Thanks! I’ll do it right now.

4

1303×561 249 KB

Here is the page ad some notes. Sorry, it is kind of sloppy. If you need more info I will gladly supply it. There is no code on the page right now. However it is a dynamic page, and, it is only accessible by members who can edit their own information.

5

981×606 204 KB

Here is a live view with me signed in. Obviously it is not completed yet. However, once I can figure this coding issue out, I can go on and finish it up. So, any help, would be highly appreciated.