Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Difficult to explain this clearly I'm afriad.
We have several fields (up to six) in our data records that may need to be accessed if a single record is selected. These are free-text fields and may be quite long (hundreds of characters) or they may be blank. I'd like to have it appear a bit like an Access form. So if the data looks something like this (although there are a lot more fields I'm not including here)...
Date | Time | ID | ...lots more columns... | Comment 1 | Comment 2 | Comment 3 | Comment 4 | Comment 5 | Comment 6 |
---|---|---|---|---|---|---|---|---|---|
1/2/17 | 08:34 | 170130a | This is the first comment on this event | This event has another comment that is longer than the first one, it is however the last comment for this event. | |||||
1/2/17 | 10:48 | 170201b | Nil | ||||||
2/2/17 | 06:12 | 170202a | This event has several longer comments | This one is short | But this one is longer and still should be displayed fully without having to scroll the window | This event even had more comments that were entered in this field | This is the last comment for this event. | ||
2/2/17 | 13:52 | 170202b | |||||||
2/2/17 | 21:27 | 170202c | Only the one comment here |
What we'd like to be able to do is select an ID, or group of (very few) IDs in another table and have displayed something like (in a separate sheet object):
Header 1 | Header 2 |
---|---|
ID | Comment 1 (if exists) |
Comment 2 (if exists) This event has another comment that is longer than the first one, it is however the last comment for this event. | |
Comment 3 (if exists) This is the first comment on this event | |
Comment 4 (if exists) | |
Comment 5 (if exists) | |
Comment 6 (if exists) | |
ID | Comment 1 (if exists) |
Comment 2 (if exists) | |
... | ... |
I'd just like to know if anyone has any ideas on how to accomplish this lower table (or similar) elegantly?
Thank you!
Christine,
Can you not just make up your lower table using a pivot? No ignore me that is dumb
Possibly, I'll look into it. Just that I'm really rubbish at pivots still.
I've got this far, just need to work out how to suppress missing values for you
Ok check this out
Thank you Adam. I just need to do some work on it presentationally, but that seems to fit the requirement!
Cheers!
No worries at all, you can use shorter fieldnames in the valuelist formula and the expression if you wanted to hide them a bit (e.g. just use 1,2,3,4)
Alternatively if you use a straight table you can just totally hide the calculated dimension but it doesn't look quite as neat
It would be nice if I could figure out how to make the comment column go multi-line if necessary, but can't have everything I guess.
Presentation > wrap cell text 😉
Yes, but they all go to the same height, even if they're empty