Dynamic Inline Table View Display Name

[sarah_t]

I would like to have the Display Name for my Inline View show the Inspection Order Number, [IORN] for all of the records in the inline view. These records are the child records of a parent record with a key column [IORN]. I have attempted the following expressions but I am aware that there are certain column constraints with an Inline View Display Name verses a Form or Detail view. I have also user [_THISROW] in my lookup to reference the parent record but get an error that it cannot find the column (probably because of the Inline View Display Name constraints.

CONCATENATE(ANY(SELECT(LN_QMPTC100[IORN], ([IORN]=[IORN]))), " ", “Test Data”)

CONCATENATE(LOOKUP([IORN], “LN_QMPTC100”, “IORN”, “IORN”), " ", “Test Data”)

These expressions both produce an Inspection Order Number but the wrong one.

For example, “RIO0000032 Test Data” is the output while the actual [IORN] value for all of the related child records is “RIO000193”

Thanks!
Sarah

[Steve]

Please post a screenshot or -shots showing where you’d like the custom text displayed.

[sarah_t]

[Steve]

Unfortunately, there’s no good way to convey the origin row information to the inline table’s display name.

[sarah_t]

Is there any work around for this? Would it be possible for me to handle it with a dashboard? It would be very beneficial for an inspector to be able to confirm they are looking at the correct Inspection Order when they are completing the inspection.

[Steve]

sarah_t:

Is there any work around for this? Would it be possible for me to handle it with a dashboard?

There are several possible workarounds, but each has its drawbacks. A dashboard is worth trying.

sarah_t:

if there was a way to just extract the similar column value from each of the related rows

Unfortunately, the Display name expression is not aware of the data set being displayed.

You might consider giving the app user a way to designate the current inspection order and save that choice in a table somewhere (or in a user setting). Then you could refer to that saved choice. There are downsides to this approach, too.

Ultimately, you’re just going to have to experiment with the possibilities and weigh the pros and cons of each. I don’t know that there’s a general best choice to offer here.

[sarah_t]

I’m pretty stumped so if there’s any choice that could possibly work, that would be very useful to me since I’ve been working on this issue for a while.

[sarah_t]

Also, each of the inline view related records has the value I am trying to display as well. So I wouldn’t even need the origin row if there was a way to just extract the similar column value from each of the related rows.

[sarah_t · Accepted solution]

For anyone who may need a workaround, I have decided to use the “Group by” view option for the Inline table and group by the column IORN. This gives me the visual Inspection Order Number at the top of the view for all of the related test data for that order.