Advertisement
Guest User

Untitled

a guest
Nov 9th, 2016
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. function onOpen(){
  2. var form = FormApp.openById('239jelkwpeowppd-3843ikeifd89wered');
  3.  
  4. var conn = mySQL();
  5. var itemList = getEmpList(conn);
  6.  
  7. var item = form.getTitle('Approver:');
  8. item.setChoiceValues(itemList);
  9. }
  10.  
  11. function getEmpList(conn){
  12. var sql = conn.createStatement();
  13. var ds = sql.executeQuery('SELECT empNAME FROM emp');
  14. var columns = ds.getMetaData().getColumnCount();
  15. var list=[];
  16. while (ds.next()) {
  17. var rowString = '';
  18. for (var col = 0; col < columns; col++) {
  19. rowString += ds.getString(col + 1) + 't';
  20. list.push(rowString);
  21. }
  22. }
  23. return list;
  24. }
  25.  
  26. function mySQL(){
  27. var dbConn = Jdbc.getConnection("jdbc:mysql://dbURL","user","password");
  28. return dbConn;
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement