I may suggest, please message me the ID at which I can share the sample app created by me based on the table structure shared by you.
the ID is 1423429
Please message me your email ID where I can share the app in message section of this community portal.
I have checked your app. Thank you much for you effort!
Unfortunately, when I have copied the actual values into your service table (with some identical category names), the same failure appears, as described above:
Inside the offer 1 PDF I have marked the services that should not be shown in this offer 1 (because they are related to Offer 2).
So the Offer filter seem not to apply and we still need an update of the expression that makes sure, on the offer only those services are shown which are related to this specific offer. Don’t matter, if there are identical named to services that are related to other offers.
Do you have an Idea?
Here the data for updating you table, so that you don’t have to type in all the values (or I can send you the link to my google sheet table):
|ID_Offer_1||1||Bedroom||1||Wallpapering||1. 1||1. Bedroom||500|
|ID_Offer_1||2||Bathroom 1st Floor||1||Lay the floor||2. 1||2. Bathroom 1st Floor||450|
|ID_Offer_1||3||Living room||1||Plaster||3. 1||3. Living room||750|
|ID_Offer_1||3||Living room||2||Install sanitary facilities||3. 2||3. Living room||400|
|ID_Offer_2||1||Bedroom||1||Brush||1. 1||1. Bedroom||200|
|ID_Offer_2||1||Bedroom||2||Laying tiles||1. 2||1. Bedroom||200|
|ID_Offer_2||2||Bathroom 1st Floor||1||Plaster||2. 1||2. Bathroom 1st Floor||100|
|ID_Offer_2||3||Living room||1||Wallpapering||3. 1||3. Living room||100|
I believe I could also be missing some point because it seems to be working at my end but you are facing issues. So I believe there is some lack of understanding of requirements on my part.
I am sorry. I believe you it may be best approach that you may seek help from someone else.
OK. Thank you very much!
Even if I do not really know who to ask else :-/. Make a new request into the community?
I might not were clear enough while explaining what kind of result I needed.
Sorry for that:
The current solution works great as long as they are no identical named categories within the related data (sevice table). But in my case there might be identical named categories within the related data (related services to an offer).
Unfortunately in your table there were no dublicates. So it could not show if the goal is achieved. I have copied your app and added the “duplicates” (I have colored them into the same color in the upper table trying to point out, that it this case can appear) into your service table to check, if only the services were shown in the offer pdf, which are really related to the particular offer.
I would appreciate if you could copy the “duplicate” values (into your sample service table and run the pdf), then you understand my issue.
Thank you very much for you help!
We were quite close and have found the failure.
It has been quite simple in the end:
Thank you, Suvrutt, thank you Steve!