hallo my name is tunggul and i need help from everyone to solved my problem

[Tunggul Permono Wicaksono]

hai guys thank for reply this email im really need help from everyone because im still new in app script, by the way sorry if im breaking the rules in this community

my problem is, i want to make a form using spread sheet like in sheet name "AIF" and collet data to sheet name "master database". and i can call the data from master database to AIF so i can edit again if there is any update.

i already using google form to input AIF to master database but i cant call back to AIF. i try using formula but when i try to update i must delete the formula in cell. 

gemini suggest me to using GAS but i still can understand the script can any one help me?

 

this my spreadsheet dan form response

https://docs.google.com/spreadsheets/d/1cCpoCPgVzGTi_go77xM6EVYvwsQW7M35vWFQgoBASb4/edit?gid=1201610528#gid=1201610528

this the script im using

function submitForm() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var sheet = ss.getActiveSheet();

  // Ambil data dari sel A3 dan B3

  var name = sheet.getRange("A3").getValue();

  var tanggal = sheet.getRange("B3").getValue();

  // Buat formulir baru dan tambahkan item

  var form = FormApp.create("Formulir Baru");

  form.addTextItem().setTitle("Nama").setValue(name);

  form.addDateItem().setTitle("Tanggal").setValue(tanggal);

  // Submit formulir

  var formUrl = form.getPublishedUrl();

  var response = UrlFetchApp.fetch(formUrl, {method: 'post'});

  // Hapus formulir setelah submit (opsional)

  // form.deleteForm();

}

[Tunggul Permono Wicaksono]

Thank you for replying my message

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/ZZzQazodU4I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1f34a12b-7ee6-4200-8a90-eae3909d6f3an%40googlegroups.com.