Dynamic printing and join tables
Hi,
I have several join tables set up because I need the many to many relationship.
So I have a Programme table that links through a join table to a Staff table for ex.
Prog< Prog_Staff > Staff
I am only just beginning to see about dynamic printing . I made a template in Word but apart from fields which are directly in the Programme table , nothing renders.
I used something like this from the Programme table:
{d.Prog_Staff[i].Staff.Name}
{d.Prog_Staff[i+1].Staff.Name}
What am I doing wrong?
17 replies
-
I haven't tried it out, but maybe try:
{d.Prog_Staff.Staff[i].Name} {d.Prog_Staff.Staff[i+1].Name}I would think it would be at the Staff level since that is where you really want it to iterate.
If that doesn't work then I'll try to figure it out.
-
Thanks, Just tried and get the same empty result .
Here is the report plus the template for comparison.
-
-
Ok, so I've had a chance to try it out and I'm able to get this from a table called Production:
the template looks like:
ProductionItem is a table that links Production (N:1) and Materials (N:1). Meaning you can only select a single record from Production and Materials in each ProductionItem.
So I was wrong to suggest that the [i] goes after the second reference field.
If Pro_Personnel is also setup similarly then can you modify your template so that only the following is in the first column
{d.Prog_Personnel[i].somefieldname} {d.Prog_Personnel[i+1]}in the first column, remove data from all other columns. Replace somefieldname with a data field in Prog_Personnel. Do not use any reference fields.
If that works then you can add the reference field back in.
{d.Prog_Personnel[i].Personnel.PrenomNom} {d.Prog_Personnel[i+1]}Let us know how it goes.
-
all this goes to prove that Ninox needs to have a proper built in report designer!
-
According to Nioxius, Carbone is the print engine. Ninox is not going to build anything else.
-
Yes I think that migth be the safest route. I will let you know...
-
Yeah I know but they seem to more people off by the sheer lack of information surrounding this Format. Even their base support don't know much about how to construct a form with sub tables and to fix things like images that fixed as thumbnails! You just have to jump through too many hoops with it. So the new customer experience is dented from the start !
-
don't disagree there. Their support is woefully inadequate. If Andy from Nioxius is correct, Ninox's support is shamefully understaffed for a company with enterprise aspirations. If they want to be an international company, how can support end at 6pm Central European time? They offer 99.9% uptime. Which means no more than 4 minutes of downtime a week. How can you offer 99.9% if you are closed for 8 hours everyday and all weekend?
-
In the Partner conference, Carbone also said that they will release an update that will allow the Carbone studio to be embedded in another program (read Ninox). Now for the developpers at Ninox to integrate this in a future update.
-
If they can imbed Carbone Studio into Ninox then it will make the whole process easier.
For those who haven't tried it, here is what studio looks like. It is free so give it a try. On your left is your JSON dataset and on your right is the live presentation of your data in your template. No more "printing" to see if the changes you made look good.
If you use Chrome, or a chrome derivative, then you can do live-reload so when you make changes to your template Studio will automagically update as well.
Live reload is not supported in Safari or Firefox, but otherwise the very visual results without having to "print" is very nice. The only issue is having to create a json of your data in Ninox so you can copy it into studio. If they embed it then I hope we can just give it a formula and it will the create it on the fly.
-
-
agreed
-
, if you were able to get your question answered, please mark the post answered when you have a moment.
Content aside
- Status Answered
- 11 hrs agoLast active
- 17Replies
- 95Views
-
4
Following