prefill data in spreadsheet

Confluence User - 24 May, 2024

Hi, How to prefill data in spreadsheet and make it readonly ? in column 1. helpppp

forms;userviews

1


24 May, 2024
confluenceUser
confluenceUser

Hi Dayana, 

1. try using the read only option while configuring the columns.


2. For pre-populating the data: you can achieve this in different ways by using load data (Spreadsheet) option or using jquery.  while using jquery you have to first get spreadsheet handsontable instance by form element ID (Spreadsheet Deep Customizations) and then write jquery to get the instance and prefill data. 

refer the app: APP_spread_sheet_custom-1-20240524044706.jwa


RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print