Grid edit- disable editing for some columns

Question

Can I disable editing for some columns/ not to be edited in the grid edit mode?
In my report, there are 2 columns which only needs to be updated by user so I wanted to keep remaining columns read only/ non-editable. Is there way to do this?

------------------------------
Mrunali Kadam
------------------------------

markshnier__you · Answer

Since you cannot directly control that the best way is to have a report with mirror formula fields and of course formula fields will not be editable.

I would name then like.

[Expected Arrival Date.]
with a formula of [Expected Arrival Date]

no one will notice the . in the field name.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

mrunalikadam · Answer

Great idea! I'll try this. thank you.------------------------------Mrunali Kadam------------------------------

mrunalikadam · Answer

For example in this case I've "Expected Arrival Date" field which I want to make non-editable in the grid edit mode.
If I'm understanding correctly, I need to create one new field/column "Expected Arrival Date." as a formula-text and then put [Change Type] in the formula text box in the properties section.

Sorry, I'm new QuickBase user.

------------------------------
Mrunali Kadam
------------------------------

markshnier__you · Answer

NO!!! do not make any changes to your existing field or you will lose all your data! Make a new formula date field.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

mrunalikadam · Answer

Yes, got it. I'll create a new formula field and refer old field in the formula section.&nbsp;Thank you!!------------------------------Mrunali Kadam------------------------------

Forum Discussion

Grid edit- disable editing for some columns