p.s. While waiting for your suggestion guys, i reorganised the whole Worksheet and combined the PAYMENT METHOD in the same row as the SUM changing the whole Form structure (removed 4 Payment Method colunmns and added single SUM column insted) simplifying the Form this way (i think…).
Making this way the needed data to be collected being extracted with some Excel Formulas in to another Worksheet.
MANAGED TO MAKE IT WORK!
But im now facing new issue O_O The thing is that the Worksheet I input data to is integrated with other type of data being collected from aother Source. NOT the FORM being discussed here. And it has some other Columns being filled in the same Worksheet.
Every Data type has its own Column and Some Columns with formulas.
For example TOTAL(Customer’s Debth) column formula is the following:
=(- “Price column” * “Hours column”) + Bank Transfer sum + Cash sum + Check sum + Credit Card sum.
The Header row contains SUM or AVERAGE of the whole Column.
Two more simple formulas in two more columns in the Worksheet.
The issue and the funny part: BEFORE I started testing (when got stuck on this Post’s original issue) it seems that combined Worksheet is working perfect.
Filling in the needed Data Columns ignoring the irrelevant columns. (depending on the Source Type data is being pulled from). At some point the filled forms seems to corrupt the Worksheet: Example, While a Form is Saved and Data send to the Worksheet: BEFORE
I touched something and corrupted its functional
The saved form was IGNORING the Columns that are irrelevant for the form, and not corrupting the FORMULA columns. NOW if i save a Form; the Columns that are irrelevant to the form is being filled in like if the CELL contains a Formula and showing ERROR in the Cell BECAUSE IT IS BLANK and the Header with SUM\AVERAGE formula as well get an error… although the cell is not supposed to contain data according to the FORM columns !!
Now neither the previous column order neither the new one is not working properly.
Any ideas what have i done ?
Cant figure it out.
Neither Hiding the Columns from the APP or making them Mandatory \ Not Mandatory is not canceling this issue…