It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

PS I think I might have already gotten one baby step further. You can add formula fields to the print lay-out.

Using 'A) Project Items'.'B) Time Used' does give the record IDs I am after… However, it only displays these IDs and nothing more. Any idea how to display the value of the variables/fields associated with these records? Can you choose the order as well? Also; can you change the “header” names of that table as well?

Also:

I have 1 Master table called Projects.

This tables contains another 3 tables: Subprojects, Labour, Parts.

I would like to “print” a list of the following given the Project an user has selected listing all Subprojects + Labour + Parts for those Subprojects belonging to that Project.

So something like this:

Project: XYZ
Subproject: Task 1
Labour: 5 hours | 50 euro
Parts: 3x Part 1, 2x Part 2, 130x Part 3 | 200 euro

Subproject: Task 2
Labour: 51 hours | 505 euro
Parts: 30x Part 1, 22x Part 3 | 200 euro

Dear Leonid,

This is absolutely excellent... Thank you very much for taking the time to share your knowledge... Very much appreciated...

It's funny too; I had already spent quite some time on this issue and you seem to have it solved in "no time". (And with basically zero turn around time as well; on a Sunday; haha!)

I will see if I can reproduce your work in my current "Master Database" and I am already looking forward to learning more about Ninox and f.i. the JOIN command...

Thanks again,

Bas

Dear All,

Any idea if you can replace the comma between parts with a "space or line break" instead? 

Here's the original code:

join('A) Project Items'.("Subproject: " + 'Project Item Name' + "
" + "Labour: " + sum('B) Time Used'.hours) + " hours" + " | " + sum('B) Time Used'.Total) + "
Parts: " + concat('C) Materials Used'.(Quantity + "x " + 'Part Name')) + " | " + sum('C) Materials Used'.'Total Price')), "

")

This is what it looks like:

This is what I am going for:

Thanks,

Bas

Well spotted Sean!

I have tried the following:

join('Project Items'.'Materials Used'.'Article Name', "");
join('Project Items'.'Materials Used'.text(Quantity), "");
join('Project Items'.'Materials Used'.text(Quantity); text("RANDOM TEXT");'Project Items'.'Materials Used'.text(Quantity), "tada")

The first two lines do give a correct result. The third; unfortunately not. Any idea what I should do different?

Here's the actual code I am trying to get working:

join(‘Materials Used'.(Quantity + "x " + 'Article Name' + " (" + 'Line Total' + ")")), " Random separator")

Thanks as always,

Bas

Sean, thanks for your fast reply.

Are you referring to the "code example" or the "actual code"? I removed ) for both; the formulas compile without error, but they don't show what I thought and want them to show.

Let's try with something simpler first. I thought this would work:

join('Project Items'.'Materials Used'.text('Suggested Sales Price'); 'Project Items'.'Materials Used'.text(Quantity), " tada")

and would give something like:  35,00eur,10,tada,13,00eur,22,tada 

But I get 100 tada5 tada50 tada5 tada50; thus the Suggested Sales Price goes missing. 

I am confused. I think I am using the formula in a incorrect way?

Could you please give me an example where you would achieve this:

Value of Variable 1 + "random text" + Value of Variable 2 of item 1

Value of Variable 1 + "random text" + Value of Variable 2 of item 2

Value of Variable 1 + "random text" + Value of Variable 2 of item 3

Etc.

Is such an outcome possible?

Thanks,
Bas

Thanks for your immediate reply; very much appreciated...

And exact copy paste still gives an error. I don't really understand what it is trying to say. I can't really say what is wrong either (no obvious typos and the filenames seem correct).

What do you think?

I am going to check again; haha.

Would you like me to upload the database example?

join('A) Project Items'.'C) Materials Used'.text(Quantity) + "KEEP GOING" + 'A) Project Items'.'C) Materials Used'.text('Single Price'),"SEPARATOR")

Here's the DB.

https://we.tl/t-RjKiKnnFh6

I called the formula "Keep trying" ;).

Dear Sean,

It works wonderfully. This is so great!

I also had a look at why you used concat and replace / how this does work; and it makes so much sense now... (You use concat to concatenate a string to our (my ;)) liking and you simply remove the comma's within this spring using the replace function. Simply genius!)

Thank you so much! Not only for continueing to follow up; but also taking your time to share your knowledge. Very much appreciated!

-Bas