Example: Col 1 | Col 2 | Col 3 | Col 4 | Col 5 Value is: Col 1: - Empty - Col 2: SAMPLE 2 Col 3: SAMPLE 3 Col 4: SAMPLE 4 Col 5: SAMPLE 5 The Result in my another Sheet (When the value is moving from original FormResponses to the another Sheet with my script). Col 1: SAMPLE 2 Col 2: SAMPLE 3 Col 3: SAMPLE 4 Col 4: SAMPLE 5 Col 5: - Empty - Note: I try input form from link Google Form (not from formfacade link), the result it's work properly the empty value or null data is been skip not overwrite.. there's solution for this problem? Thank You

When you use the Formfacade share link to collect responses, the responses will be recorded in Formfacade and Google Forms. You can also sync the Google Forms responses to Google Sheets. This is a Google Forms feature. When you fill the form using the Formfacade share link and submit it, are the responses recorded correctly in Google forms? If you submit the same response using the Google Forms link, does the response recorded in Google Forms the same as the response recorded when submitted using Formfacade share link? Please check and confirm.

When you fill the form using the Formfacade share link and submit it, are the responses recorded correctly in Google forms? - Fill the form using formfacade share link and submit it = the result: - The responses has been recorded in Google Form correctly - The responses has been recorded in Google Sheet (FormResponses) correctly - The responses in another sheet (moving with script form) not correct - Fill the form using direct google form link and submit it = the result: - The responses has been recorded in Google Form correctly - The responses has been recorded in Google Sheet (FormResponses) correctly - The responses in another sheet (moving with script form) correctly I think the problem is my script can't read type dropdown (when empty value) in formfacade, but in google form the script can read.

Hi William, thanks for checking this. Just to confirm, you have added an Apps script in Google Forms to read the submitted responses in google form and update the google sheet in a specific format? If the responses recorded in Google Forms is the same when using the the Google Forms link as well as the Formfacade link, then the script should work without any issues. Can we have a call?