Jump to content
  • 0

Batch update



Is it possible to update an entire column of a table?

The scenario... We have a field which indicates whether or not a record has been processed. This field is the query term used to filter records for the resulting table so that only unprocessed records are displayed. Our staff person typically processes all the new records in one sitting and would like to be able to click a checkbox at the top of the table column which would change all the no entries to yes rather than having to go into the details page for each record in order to change the entry as this is very time consuming.

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0


I have the same scenario where I have status fields that need batch updating. I have been downloading, batch updating in Excel, and uploading. I woull really like to eliminate some of the risk and labor of doing it this way if at all possible. Everytime you do an offline manipulation and then upload you run the risk of losing some data due to web updates that may have occured in teh interum or other possible errors in the uploading.

Has anyone figured out how this may be accomplished with some JS coding? or Cron job?

Link to comment
Share on other sites

  • 0


Just want to update this post, Caspio has new feature where you can "Bulk Update/Bulk Edit" your records.  Bulk Edit – Available in all report types, user can select any number of records and update them all at once. Bulk editing is performed through a web form that overlays on top of the results set and the user can specify which of the provided fields should be modified.

You may check this link for reference: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/

I hope that helps.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...