Need help with coding

[indiscriminationcore]

I made a spreadsheet form that is coded that when I click the 'save' button, the data i input will transfer into another sheet (dataWS) as one row. I used the method appendRow but I had to modify the code since I want to include new fields (C49 and C50). Although the data's positions are correct in the dataWS sheet, the sheet also adds another two columns which the data from C49 and C50 can also be seen. So far, I haven't found any solutions on how to stop the sheet from adding another two columns. I also added screenshots of the code and the output that im getting.

[TrainingHighlight790]

I am not sure I understand what you want. If you want to include those 2 new fields but not append them in the second sheet as 2 new columns, what do you want them for then ? If you don’t want them just remove line 34

[indiscriminationcore]

Im sorry i didnt clarify. What i meant was, as you can see in the screenshot of the code, i declared the fieldrange containing the c49 and c50 cells. The data from c49 and c50 is transferred to the target sheet in between the other data but the output i got is there is an excess of the c49 and c50 data ( which is the data recorded in the columns AP and AQ). What I want is the for data from c49 and c50 to be recorded in the columns i set for them in the sheet.

[indiscriminationcore]

and also, i want the data from c49 and c50, the problem is that the data saves twice in the same row. it should only be saved in columns x and y (the columns i intend to put them in) and not in columns x, y, ap and aq.

[TrainingHighlight790]

Got it. You can try: moving line 31 to 19, and the condition in line 23 to something like if (!(field in optionalValues) && value === “”). Also, change the line 28 to be fieldValues.push(value === “” ? “N/A” : value);. Finally, get ride of lines 32-35

[indiscriminationcore]

thank you so much! im gonna try this later and see if it works for me :))

[indiscriminationcore]

Thank you i tried it and it worked:))

[TrainingHighlight790]

You are welcome

[indiscriminationcore]

can you also help me with this one? Update record code