How to make reference column as Required?

[Karthick_Rajave]

Hello,

I am trying to make reference column as required but i am not getting the enable option for rest of 3 columns. Any reason why i got enable option for 1 column & why not for rest of 3 columns? Attached the screenshot FYR.

[Aleksi]

Is your first column a normal column where as the rest of are all virtual columns?

[Karthick_Rajave]

No… all the columns are normal.

[Aleksi]

You have created those columns manually by yourself?

[Karthick_Rajave]

No… it’s system created reference column…

[Aleksi]

Then it’s a virtual list column… not a normal column. You can see it from the color… if the box with a pen icon is blue, it’s a virtual column.

[Karthick_Rajave]

Yes, its virtual column, i am getting enabled option for 1 column but not getting enabled option for the rest. Any reasons?

Ref the screenshot.

[Aleksi · Accepted solution]

For me it sounds that your first virtual column has been set as required with the old editor when it was possible to do that. If you want, you can open the old editor if you add &OldEditor=true right after the AppName-123456 in your URL.

[Karthick_Rajave]

Thanks @Aleksi. Its solved. But like to know, why this function is not available on new editor.

[Aleksi]

I’m afraid I don’t know the exact reason for this change… I need to check that.

[Stan]

It seems that I can’t open the old editor anymore? Is there another way to make a reference column required?

[Bahbus]

Ref columns can be marked required, but I believe only normal columns can be marked as required. You can’t set the auto-created Related virtual columns as required because at any given point there may or may not be appropriate references to…well…reference. There is no need to set these as required because their expressions will ensure they do their jobs. Why on Earth would you want to mark these as required?

[Stan]

When a seller makes an offer, it should be required that he makes a picture of the place where it is built. We want to have a possibility to make multiple pictures, so we used a ref table. In the old editor it was possible to set such a column to required and then you needed to upload at least one picture.

[Aleksi]

Yes it’s true that you can’t set the virtual List column as required. Though you could add the same functionality with other column’s Valid If as well. It could be like COUNT([Related Records])>0

[Stan]

Yeah, I think that would be a good alternative, thanks!