HELPPPPPP......i have a column "assigned tabl...

(Tammi Canelli) #1

HELPPPPPP…i have a column “assigned table” that for whatever reason data keeps being entered to the column immediately to its left.

I regenerated the table thinking that was the issue but it’s still happening.

Any idea what causes this and how I can fix it?

(Tammi Canelli) #2

Is it because the very first col of the sheet is a read only reg ID column?

I had tried unchecking read only but the system keeps rechecking it.

(Stephen Mattison) #3

@Tammi_Canelli I’m guessing this has something to do with your Key column.

I had similar shenanigans when

I overlooked something here. What do you mean “reg ID”?

Best practice is to have a separate UNIQUEID() column that assigns a very unique number to each row.

This can NOT be Read Only because App knows it must write a new ID to each new row.

To make my IDs read only, I add an Editable_If, like =ISBLANK([ClientID]).

Check it out and report back with more details.

(Levent KULAÇOĞLU) #4

@Tammi_Canelli what is your column structure? Is your RegID column have a sheet formula??

(Tammi Canelli) #5

I found the problem - had a hidden column in my sheet.