Query Editor Custom Column text editor?

[SHDJason]

Hi. This may be a simple thing, but I can't find the answer. When I go into Query Editor and want to make changes to some custom columns, it gives me a form instead of a text box. How do I switch back to the text box? I like it better for creating columns with lots of conditions. Using the select boxes is slow. Is there a setting to toggle back and forth? Thanks.

[v-piga-msft]

Hi @SHDJason,

Have you solved your problem?

If you have, could you share the solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, could you share some screenshots to specify your problem, so that  we can help further investigate on it?

Best Regards,

Cherry

[Anonymous]

Am not sure what you mean by text box and form. If you click on the custom column creation step ( Right click-> Edit settings) in the applied column, you will see the below column settings where you can type your custom formula in the text editor. This is what you are looking for?

Thanks

Raj

[SHDJason]

Hi Raj,

That text box view is what I'm looking for. But I keep getting this interface. How do I switch?

[v-piga-msft]

 Hi @SHDJason,

From your screenshot, it seems that you added the conditional colum before.

There is no option for us to switch the two different box each other directly in Query Editor. By my test, if you want to get the Custom column editor box view, you could add a step above add Location. Then click Custom column like below.

Best Regards,

Cherry

[SHDJason]

Hi Cherry,

Thanks, but that is what I do every time. However, sometimes it seems to convert it to a Conditional Column even though it was created as a Custom Column. Maybe, if the logic is not complicated, it thinks its a Conditional Column and presents that interface?  

[v-piga-msft]

Hi @SHDJason,

---

Maybe, if the logic is not complicated, it thinks its a Conditional Column and presents that interface?   

It seems that your're right.

By my test, if I create a simple custom column with if function. It will be recognized as a conditional custom column.

So if we want to open the custom column edit box, we need to add a custom column. If the custom colum you want to modify is still a conditional column, you could edit it in Conditional  column text box.

Best Regards,

Cherry