User to be able to Change?edit his record in DataBase!

Ask the community
,
1

Im looking for a way to give the user an option to edit his own submitted form so he can change or updates the information he submits to the database!
Any help or tutorials are welcome
Thank you

2

Hi

Hope this helps:

  1. Create your form on a member page with your input fields.
  2. Add a dataset to that page linked to the database (set rule to write only).
  3. Link your input fields to the dataset and relevant database columns.
  4. Add a Button to the page (call it submit if you like)
  5. Link button to the dataset and set LINKS TO - SUBMIT
  6. Create another member page
  7. Copy form from previous page to this new page
  8. Add a dataset to that page linked to the database (set rule to read & write) and create a filter OWNER IS LOGGED IN
  9. Link fields to the dataset and columns as previously.
  10. Create 4 butttons

i) BUTTON 1 link to dataset, set to SUBMIT
ii) BUTTON 2 link to dataset, set to DELETE
iii) BUTTON 3 link to dataset, set to NEXT ITEM
iiii) BUTTON 4 link to dataset, set to PREVIOUS ITEM

Rename buttons accordingly.

User can now submit a form on the first page once logged in, and then go onto the second page to view and edit or delete his submission.

Hope this is what you had in mind.

3

hello dear
thanks a lot it seems to be working
I didn’t get how to do the part of
“and create a filter OWNER IS LOGGED IN”
Appreciate

4

All is good and nice working like a charm GOT IT
Thanks