Thu, 24 Sep 2026
Login

Default Values in Spreadsheets

Confluence User - 05 Apr, 2018

Hi,

Is it possible to use default values when a user creates new rows in the Spreadsheet?

Thanks.

Regards

spreadsheet

3

Confluence User •
06 Apr, 2018 •
confluenceUser •
•
confluenceUser •

Hi, you can try the example in Load & Store Form Grid Data Using Bean Shell Form Binder

Confluence User •
06 Apr, 2018 •
confluenceUser •
•
confluenceUser •

Hi,

Due to technical issue, spreadsheet cannot support default value yet. Spreadsheet is using spare row to add new row. But default value will be causing a row contains values and the library we used "Handsontable" will keep adding spare row indefinitely. Joget team still having issue to implement this feature.

Best regards.



Confluence User •
06 Apr, 2018 •
confluenceUser •
•
confluenceUser •

Hi,

Noted. I'm trying to use JDBC. The insert and update works on the spreadsheet but, it will only work for the 1st record. Am I referencing the cells correctly with the curly brackets?

 

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Access a subform field in a spreadsheet element
How to add rows in a column?
Spreadesheet
How can Hide Selected Value from Cascading Drop-Down List with AJAX Dependency
how implement file upload in Spread sheet plugin
Problem with delete files in Spreed sheet !
jQuery.Deferred exception: $(...).fileUploadField is not a function TypeError: $(...).fileUploadField is not a function
Error in Spreadsheet Calculation
apply a filter in a dropdown list located in a Spreadsheet based in a value in the form
BeanShell Validator for Checkbox
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print