Embed Unrelated Report
Hi All, I've got a table that's used as a scheduler so I know who is available and when. The assignments table is related to that table, but the parent table is the schedule table because one perso...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendActually I have seen flaky behaviour on report link fields. It seems like sometimes they take a minute or two to settle in. Can't explain it.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hey Mark,
I've got the schedule working with the date field, but now I'm trying to get another report to show based on a status field. The user inputted status field is just a multiple choice text, but there are two different statuses whose records I need to show. I can get one to show with a dummy formula text field with just the text in quotes of that one status. Is there a way to get both to show? What would that syntax look like? I tried "Status 1 ; Status 2" but that didn't work, it didn't show anything. I've also got the "Only include values if they match exactly in both fields" box unchecked.
What do you think?
------------------------------
Daniel Johnson
------------------------------
I've got the schedule working with the date field, but now I'm trying to get another report to show based on a status field. The user inputted status field is just a multiple choice text, but there are two different statuses whose records I need to show. I can get one to show with a dummy formula text field with just the text in quotes of that one status. Is there a way to get both to show? What would that syntax look like? I tried "Status 1 ; Status 2" but that didn't work, it didn't show anything. I've also got the "Only include values if they match exactly in both fields" box unchecked.
What do you think?
------------------------------
Daniel Johnson
------------------------------
- MarkShnier__YouWhen you use the non exact match it means that the value in the field on the left side must be contained within the string on the right side.
If that is backwards from what you need, then you will need to have two embedded report link field.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - Thank you for that explanation Mark. It would be nice to be able to have some more flexibility there, but such is QB.
------------------------------
Daniel Johnson
------------------------------