Forum Discussion

ChrisSwirtz3's avatar
Qrew Member
3 years ago

Creating an Excel-like worksheet in a form

Is there a way to recreate something similar the the Excel-like chart shown below with the different boxes and such within a form? Short of it being a child table obviously.

Chris Swirtz

1 Reply

  • If these are all separate fields on a record, then you can arrange the fields on the form in a square but suppress all the labels except for the top row. 

    For the top row override the field  names with the name for the column. Then add text form elements on the right end of each row to label the rows. 

    Basically the concept is the only have headings across the top and down the left-hand side by contriving either field labels or text elements on the form and then all of the middle boxes in the square will have no labels at all. Essentially that is what Excel does. You don't label every cell in excel.

    Mark Shnier (YQC)