How to mass update field in one form with information from another form in Zoho Creator
Hi,
We have a database in our Zoho Creator app with thousands of records. We have a 'Waiting List' form for children who register for our programmes and once they are enrolled (there is a button that 'enrols' them) they are pushed through to 'Students' with all of their information being copied over. When this system was set up, there was a piece of information that was not coded to be pushed across from the 'Waiting List' record to the 'Student' record. I have since added this into the function so all new student records will copy this info from the waiting list record, however for the thousands of previous records, is there a way I can push all of the data across/do a mass update?
The information in the Waiting List record is a radio button with Yes or No options and the corresponding field in the Student record is a checkbox (checked if the waiting list radio question is answered as 'no'). There is also a corresponding ID that follows the record from the waiting list to the student record.
Is there a function I can set up to push this information across for all of our records?
Thank you!