Home > Blockchain >  Save to Database when someone updates notes field in html table (django)
Save to Database when someone updates notes field in html table (django)

Time:10-30

I have found many answers to this on SO but my understanding of all of this is still too new to be able to understand how to implement so just posting my exact question:

I have a table which is a filtered view of my database that shows up on one page of my app. It has a notes column where each cell uses content-id-editable. I want to add a save button and when someone wishes to save that particular notes section cell I want them to be able to press "save" and have the updated cell post to the database.

UPDATED QUESTION:

CodePudding user response:

I wouldn't recommend setting it up this way as the page will refresh every time someone saves a note...

Why don't you instead send the POST data via AJAX?

You will need to write a JavaScript function that you can call when your button is clicked.

You can do something simple like...

Notes.js

function saveNoteAjax() {
    return $.ajax({
        type: 'POST',
        url: 'your route to the function notes function in views.py',
        data: {note: document.getElementById('yourNotesInput_ID').value}
    })
}

async function SaveLoadNote(){
   await saveNoteAjax()
   *use another Ajax call to get the new notes from the DB*
   *insert some function to refresh the notes on-screen*
}

views.py

def notes(request):
   if request.is_ajax():
      note = request.POST['note']
      *insert your code for updating your DB table*
      return HttpResponse('')

 

CodePudding user response:

If you don't want AJAX, you could make your entire table into a Django model formset. Each notes field would be an input element. To get started, {{form.notes}}. Once it's working you can change your html to render the and style the form field any way you want). The other non-editable fields would be accessed with {{form.instance.fieldname}}

The differemce would be that the user would need to explicitly update after making changes, i.e. you need an Update button to submit the change(s)

Formsets and model formsets look complicated to start with, but they aren't really once you have done a few on them!

  • Related