I would like to have the pdf look better

[JordanJed]

I am trying to create a recipe pdf that will display with the group either just above the ingredients in that group or only once to the left. I am using a table in the body template.. I have tried many different scenarios, but this is the latest that didn't give me any errors, I have tried to follow the instructions in this group.

<<Start: [Related Ingredients]>> <<ORDERBY(FILTER(“Ingredients”,([_ROWNUMBER] = MIN(SELECT(Ingredients[_ROWNUMBER],([_THISROW-1].[UNIQUEID_RECIPE()] = [Reference to RECIPE]))))),[_ROWNUMBER])>> <<[Group]>>

• <<[Ingredient]>>

<<[Recipe Quantity X]>>

<<[Note]>><<End>>

This is what I get.

Any idea how I can do this? Thank you in advance.

[WillowMobileSys]

It is a bit of an art form with a learning curve.  There isn't anything with the template code you can do to make it "look" better.  You'll need to play around with the different formatting allowed in the template.  Many trials and errors!

Document tables are your best tool within these templates to get alignment perfect.  So you'll want to get very familiar with how to set column widths. heights, justification, shading and control of table borders. 

For example, for the details just below the title, I would suggest inserting a separate table with at least 4 columns and then insert each label and data item in its own cell.  Then play with the columns widths and justification settings to get things to line up.

In your main table with the list of ingredients, adjust the columns widths and heights to get things to fall into a single line without wrapping.

I hope this helps!

[TeeSee1]

If this is what you are trying to do

you need expressions with embedded STARTs like this. Your expressions certainly will depend on your data structure but the idea is

• TOP LEVEL ITEM
  • SELECT GROUPS that the Top item's ingredients belong to (I included the categories of the ingredients in the recipes table as a VC to make my expression more readable but it certainly is optional)
    • SELECT INGREDIENTS belonging to the GROUP above

[Suvrutt_Gurjar]

You may also want to take a look at the two beautiful tips by Aleksi and Marc Dillon

Grouped list from one table - Google Cloud Community

Single category headers in workflow templates for ... - Google Cloud Community

Hi @TeeSee1 ,

Your solution also seems interesting. I will also try it.  You may want to add it to the tips section as yet another option for grouping.

[TeeSee1]

Thank you @Suvrutt_Gurjar for pointing these out to me. I completely missed them.

Boy, even now searching for solutions thru the forum can be tough....

[Suvrutt_Gurjar]

Hi @TeeSee1 ,

No problem at all about inadvertently missing those tips. My main request was for you to add to the tips section. The more the options an app creator has, the better. 

[JordanJed]

Hi. Thank you for your replies. However I am still struggling with the logic, probably since I am not sure what tables and columns you created. Is there a way to see the spreadsheets you are referring to in your sample? This way I can set up my spreadsheets to be similar and go from there.

Thank you