how to make dropdown in spreadsheet?

3 answers

1.  

   1

   0

   -1

   • Justin
   • Oct 16, 2018

   Hey izzat,

   You can refer to the 'handsontable' library on how to do this:

   • https://handsontable.com/docs/6.0.1/demo-read-only.html
   • https://handsontable.com/

   First, for Format Type field, select "custom". Then, you are able to paste in the Javascript code in Format field.

   Hope this helps.

   •  Comment

   CommentAdd your comment...
2.  

   1

   0

   -1

   • izzat
   • Oct 16, 2018

   

    

    

   this is my spreadsheet. how can i customize my field?? currently "Other" field is readonly. i want if i select "Tidak Aktif", the "Other" field will be textfield. how can i do this?

    

   •  Comment

   1. Kurt Cobain

      • May 22, 2019

      How you can do that?

   CommentAdd your comment...
3.  

   1

   0

   -1

   • Justin
   • Oct 16, 2018

   Hey izzat,

   When configuring your spreadsheet column, select "dropdown" for Format Type field, and then key in the form definition ID of the form that contains an option-type form element in the Format field.

   You can refer to Spreadsheet for more information.

   Hope this helps.

   •  Comment

   CommentAdd your comment...