Display Name for UX

Hello-

I’m trying to make a custom Display of some UX with this formula:

CONCATENATE(“Comments Form (”, [order_slip_no], “)”)

It says unable to find the column because I’m not seeing order_slip_no and I’m pulling the columns from another table. Am I doing it wrong?

Believe it or not, the display name does not know which row is being displayed within the view, so there’s no (easy) way to include anything from the row’s content in the display name. If you can elaborate a little on what you’re trying to accomplish, we can probably offer alternatives.

I just want to include the order_slip_no in the display name.

The best you can do is add a column into your form to display the order slip number. The column type of Show is well suited for this. Show columns are discussed here:

Thanks for that Steve but is it possible to include it at the title at the top of the app?

image

No

1 Like

Alright Steve. Thank you :slight_smile:

1 Like

I There i have a similar problem.

We have a google sheet, with tab name A SEP.
Each month i have to change to name to the next month.

And i want that the ux view name changes there also to A SEP.
I want to use the display name: formula in de UX view.

But i have the same problem as above, adding an extra column with monthname(SEP) is not reallly a solution. Becaus the formula will look like A Sep[Sep], it works.
But when i change the monthname the formula isn’t working any more because the tabname is changed.

Can you give me another solution?

already thanks.

Wilco,

Trying using this formula

INDEX(
LIST(
“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”,
“Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”
),
MONTH(TODAY())
)