cavis

$(function() {
  $('.signupform form').submit(function(e) {
    e.preventDefault(); //don't submit
  
    var teamName = $('.signupform form input[name="teamname"]').val();
    var email = $('.signupform form input[name="email"]').val();
    console.log("SUBMIT FORM", teamName, email);

cavis

prod> select out_uuid, out_meta from outcome where out_meta is not null;
+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| out_uuid     | out_meta                                                                                                                                                                        |
+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 86f289f22713 |  melissabirch@comcast.net                                                                                                                                                       |
| cdec920c22f3 |  n/a                                                                                                                                                      

cavis

FROM BinSource bs 
LEFT JOIN bs.Source s 
LEFT JOIN s.SrcEmail e WITH e.sem_primary_flag = true 
LEFT JOIN s.SrcPhoneNumber p WITH p.sph_primary_flag = true 
LEFT JOIN s.SrcMailAddress m WITH m.smadd_primary_flag = true 
LEFT JOIN s.SrcOrg so WITH so.so_home_flag = true 
LEFT JOIN so.Organization o 
LEFT JOIN s.SrcResponseSet srs WITH srs.srs_id in (select bsrs.bsrs_srs_id from BinSrcResponseSet bsrs where bsrs.bsrs_bin_id=97) and srs.srs_inq_id in (select pinq.pinq_inq_id from ProjectInquiry pinq where pinq.pinq_prj_id in (select porg_prj_id from project_org where porg_org_id IN (961))) 
LEFT JOIN srs.Inquiry srsi 
LEFT JOIN srs.SrcResponse sr