Office File Creator Instruction manual
  • Instruction manual
  • FAQ
  • Troubleshooting
  • Error List
  • Instruction manual
  • Troubleshooting
  • Error List

How do I put spaces between records in child records?

Child Object
2024.11.092024.11.10

 

The Blank() function can be used to insert between child records. The feature is available in Office File Creator Pro.

 

Instruction manual

Block Output of Child Records (Excel)

 

Child Object
Child Record Layout
Office File Creator Instruction manual
Office File Creator Instruction manual

Related articles

Child Object

How do I break a page at a specified number of child rows?

It is possible to set the maximum number of lines on the first page and the second and subsequent pages of a child recor...
Child Object

How do I output multiple lines per child record? e.g., Two lines per child record

Multiple lines of layout are available per child record. The feature is available in Office File Creator Pro. Instructio...
Child Object

How do I output child record rows with stripes?

Use the Table Layout of the template. Only for PDF output, it is possible to set two child record rows to output in a st...
Child Object

How do I output a table header on each page with page breaks for child records?

Table headers can be output on the second and subsequent pages. Set the "(Pro) Output Rows (max/min)" section in the OFC...
Child Object

How do I output child records in columns (horizontally)?

Merge fields can be set the index number of the child record. Multiple lines per child record can be output in any layou...
  • 1. Install
    • 1.1. Install
    • 1.2. License Information
  • 2. Grant Permissions
    • 2.1. Settings of permissions
    • 2.2. Note
  • 3. Create Template File
    • Template Common Settings
    • Excel
    • Word
    • PowerPoint
    • PDF
  • 4. Create Template Record
    • 4.1. Create Template Record
    • 4.2. Upload Template File
    • 4.3. Export Test and Verify Merge Fields
    • 4.4. Note
    • 4.5. Reference
  • 5. Output Options
    • 5.1 Common Options
      • Formatting of Date and Date/Time Fields
      • Formatting of Currency and Number Fields
      • Adding Text to Merge Fields
      • Replace True/False in Checkbox Fields with Other Values
      • Outputs Today's Date and Current Time (Today/Now)
      • Output Parent and Reference Object Field
      • Set Merge Fields to the File Name
      • Functions for Merge Fields
      • Attach Files to Records
      • File Save + Download
      • Preview PDF
      • Output Images
      • Output Attachment Files (List/Images)
      • Setting File Output Conditions
      • Save Logs
    • 5.2 Child Record Options
      • Create OFC_Child Object Option Record
      • Filter Output Conditions for Child Records
      • Sort Output Order of Child Records
      • Output by Index Numbers of Child Record
      • Block Output of Child Records (Excel)
      • Group Output of Child Records (Excel)
      • Output 3 or More Levels of Child Records
      • Settings Minimum/Maximum Number of Child Records
      • PDF Page Break Settings
      • Advanced Relationship Settings
  • 6. Create Custom Button
    • 6.1. Create Custom Button
    • 6.2. Put the custom button on the page layout
    • 6.3. Export to File
  • 7. Create Lightning Component Button
    • 7.1. Create Lightning component buttons
    • 7.2. About Icon
    • 7.3. Reference
  • 8. Advanced Features
    • Batch File Output from ListView
      • Create Visualforce page
      • Create Custom Button
      • Note
    • Use with Screen Flow
      • How to use in Flow
      • Flow Example
      • Note・Limitations
      • Reference
    • Use on Experience Cloud
      • Limitations
      • How to Use
      • Test Output
      • Considerations for Guest Users
  • 9. Migrate Resources
    • 9.1. Resources & How to Migrate
    • 9.2. References
  • 10. Operating Environment
  • 11. Limitations
  • 12. FAQ/Troubleshooting
  • 13. Error List

Office File Creator Product Page

Appexchange

Office File Creator Instruction manual
  • Privacy Policy
© 2022-2024 Generipse LLC.
    • Instruction manual
    • FAQ
    • Troubleshooting
    • Error List
  • Home
  • Top