How to Add data into a table

[OGCOESPHA]

I currently have a tbl_membership table, with data currently in it over 2,000 records.  I added a new column in my table and now I need to populate it with all the same content "2016 DB Update".  How can I do this so that all my 2,000 plus records are update with this new column?

 

[Mathilda]

7 hours ago, OGCOESPHA said:

I currently have a tbl_membership table, with data currently in it over 2,000 records.  I added a new column in my table and now I need to populate it with all the same content "2016 DB Update".  How can I do this so that all my 2,000 plus records are update with this new column?

 

Hi, welcome to forum!

You may create a tabular report and fill our this column with the same value using the bulk edit feature. You can read more about this feature here

Hope this helps

[OGCOESPHA]

Hi, thank you for responding, this would work great but I added it to my edit fields but the Bulk Edit doesn't display this field in the pop-up window which would allow me to do the bulk edit.  How can I get this field to show in the Pop-Up window for the Bulk Edit?

Edited November 1, 2016 by OGCOESPHA
Adding picture of Bulk Edit Screen

[satch]

1 of the page settings is which fields should be shown in the bulk edit.

I'm not behind Caspio now, but if you follow the different screens you'll find it when you setup your datareport

[OGCOESPHA]

Here are the pages, and I have added it on for Bulk edit...(see attached)

 

Any suggestions....

[satch]

I'm not seeing the config page as in the screenshot.

There's where you can set which fields are possible for bulk editI

[OGCOESPHA]

That's what I was missing, THANK YOU!  I am now able to perform the bulk edit.