Continuation of the modification for creation of the query that will be used in saving the data in the blue yonder, saving data in blue yonder will be executed after the data is saved in MySQL, the library where the data should be saved in blue yonder will be based on the selected library before the data to be added is inputted in the textbox and selected in the dropdown, tested the adding of the location to check if the data will be saved on the given test environment from blue yonder, as per checking, an error is encountered, it is when the data is to be added in MySQL, the date is not saving the correct value, modified the value for the date to fix the error, tested the modified web app, as per checking, the date is now saving in MySQL but it does not meet the data types for blue yonder, changes the data types in MySQL and set as int(6), then substring the data value for the output of 211012 (yearmonthdate), tried to test the web application again to see if saving the data in MySQL is now OK, as per testing, it is now OK. Tested to input data for all textbox as only tried to input for some required field. to check if the no error will now be encountered, as per checking, no error is encountered, tried the same on editing the location, as per checking, all is ok, the changes in date are applied. Created the query in updating the blue yonder as well when updating is made in the web application before it is tested once.