Google sheets


Joined
Jun 14, 2018
Messages
46
Reaction score
0
hi basically i have created a database in sheets
but thing is i do not know where i am going wrong

i put all the info in and save but the persons name seems to keep going into the email section
and not the first name section
the search won't for some reason work? here's my sheet

yes it's open to anyone to edit

if anyone could help that would be great!
the email isn't working either


also here's the code





JavaScript:
// Clear Form
function ClearCell() {
  var ss        =SpreadsheetApp.getActiveSpreadsheet();
  var formS=ss.getSheetByName('Form'); //Form Sheet
  var rangesToClear=["B6","B8","B10", "B12", "D6","D8","D10"];
   for (var i=0; i<rangesToClear.length; i++) {
   formS.getRange(rangesToClear[i]).clearContent();
  
    
   }
}
//------------------------------------------------------------------
//input values
function SubmitData() {
  var ss        =SpreadsheetApp.getActiveSpreadsheet();
  var formS =ss.getSheetByName('Form'); //Data entry Sheet
  var dataS=ss.getSheetByName('Data'); //Data Sheet

  var values = [[formS.getRange('B6').getValue(),
                 formS.getRange('B8').getValue(),
                 formS.getRange('B10').getValue(),
                 formS.getRange('B12').getValue(),
                 formS.getRange('D6').getValue(),
                 formS.getRange('D8').getValue(),
                 formS.getRange('D10').getValue()]];
 dataS.getRange(dataS.getLastRow()+1,1,1,7).setValues(values);
 ClearCell();               
}
//---------------------------------------------------------------------
var SEARCH_COL_IDX= 0;
function SEARCH() {





var ss    =SpreadsheetApp.getActiveSpreadsheet();
var formS=ss.getSheetByName('Form'); //Form Sheet

var str  = formS.getRange('D3').getValue();
var values=ss.getSheetByName('Data').getDataRange().getValues();
for (var i =0; i <values.getlength; i++) {

  var row= values[i];
  if (row[SEARCH_COL_IDX] ==str) {

    formS.getRange('B6').setValue(),
    formS.getRange('B8').setValue(),
    formS.getRange('B10').setValue(),
    formS.getRange('B12').setValue(),
    formS.getRange('D6').setValue(),
    formS.getRange('D8').setValue(),
    formS.getRange('D10').setValue()



  } }}
  //----------------------------------------------------------------------

  function Update() {
  var ss     =SpreadsheetApp.getActiveSpreadsheet();
  var formS=ss.getSheetByName('Form'); //Form Sheet
  var dataS=ss.getSheetByName('Data'); //Data Sheet

  var str  = formS.getRange('D3').getValue();
  var values=ss.getSheetByName('Data').getDataRange().getValues();
  for (var i =0; i <values.getlength; i++) {
    var row= values[i];
    if (row[SEARCH_COL_IDX] ==str) {
      var INT_R = i+1

      var Values1 = [[formS.getRange('B6').getValue(),
                 formS.getRange('B8').getValue(),
                 formS.getRange('B10').getValue(),
                 formS.getRange('B12').getValue(),
                 formS.getRange('D6').getValue(),
                 formS.getRange('D8').getValue(),
                 formS.getRange('D10').getValue()]];

        dataS.getRange(INT_R, 1 ,1 ,1, 7).setValues(Values1);
         SpreadsheetApp.getUi().alert( 'Data Updated');

    } }}
    //-------------------------------------------------------------------------

    function Delete() {
  var ss     =SpreadsheetApp.getActiveSpreadsheet();
  var formS=ss.getSheetByName('Form'); //Form Sheet
  var dataS=ss.getSheetByName('Data'); //Data Sheet

  var ui = SpreadsheetApp.getUi();
  var response = ui.alert('Delete ?' ,ui.ButtonSet.YES_NO);

  // Process the user's response
  if (response == ui.Button.YES) {

  var str = formS.getRange('D3').getValue();
  var values =ss.getSheetByName('Data').getDataRange().getValues(); //Data Sheet
  for (var i =0; i <values.getlength; i++) {
    var row = values[i];
    if (row[SEARCH_COL_IDX] ==str) {
      var INT_R = i+1

      dataS.deleteRow(INT_R);
      ClearCell();
      }}} }
 
Ad

Advertisements

Ad

Advertisements

Joined
Jun 14, 2018
Messages
46
Reaction score
0
no i don't want google forms i'm trying to do a form
within exel and would like someone to help please
if this is you're excuse of google forms then i'll go elsewhere
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top