Updating a status field when button is clicked

[DDNex]

I am trying to create a tabular view with a button on each record.  Upon button pressed I want to update the status field of that record and refresh the page.  How would I go about accomplishing this

[Lepidoptera]

This is an interesting question. Have you already made a solution for this?

[Volomeister]

Hi there!

Such functionality could be added using some JavaScript coding. 

I wrote a script that you can test here and let me know if this is something you are looking to achieve:

https://c7eku786.caspio.com/dp/7f80b000996248acff124d7d8b06

Upon clicking on "Update," it changes the value of the Status field to "updated."

Here is a script that you can add to the header of your report datapage:

<script>

document.addEventListener('DataPageReady', _=> {

const observer = new MutationObserver( mutationRecords => {
    let inputSelector = 'input.cbResultSetTextField';
    let inputUdatedValue = 'updated';  
    let inputToUpdate = document.querySelector(inputSelector);
       if(inputToUpdate!=null) {
       inputToUpdate.value = inputUdatedValue;
       let row = inputToUpdate.parentElement.parentElement.parentElement;
       row.style = 'opacity: 0';
       window.setTimeout( _=> {
       if(document.querySelector('input[name="Mod0InlineEdit"]')!=null) {
           row.style = 'opacity: 100';
        document.querySelector('input[name="Mod0InlineEdit"]').click()
        }}, 100)
    }
    
}
)

document.querySelectorAll('.cbResultSetData').forEach(input=> {
observer.observe(input, {childList: true, subtree: true});

})

})

</script>

 

[CaspioUser1523]

@Volomeister How do you define which field to update using the script above? Can you update a Boolean field?