Control rows in spreadsheet

 
1
0
-1

Hi Experts,

Is there any way spreadsheet's row only displayed according to number user selected/fill.

1) User choose:

2) Row displayed based on number chosen:

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi there,

      there's a good example on how to do this in Expense Claims App in the Enterprise Edition. Run the app in runtime, from the Dashboard > create new claims > fill up the title and click next > and take a look at expense item category column. Ensure you fill up some data in the Setup Category.


      Have a look at the Expenses Claim Form and edit the spreadsheet. 
      For more details, check Spreadsheet#MainProperties (look under the Format type and Format row for dropdown), once you've set the format type to dropdown, ensure that the FormDefID is inserted in the Format column.


      1. monday

        Hi Ian, 

        Hmm actually I'm not trying to display value for dropdown in a spreadsheet. What I'm trying to do is for example, user choose Pax = 2, then the spreadsheet will only allowed user to key in 2 rows. 

      CommentAdd your comment...