Populate the cell value in a spreadsheet to another spreadsheet using Custom HTML?

Confluence User - 05 Oct, 2022

Good day everyone,


I have two spreadsheets, Spreadsheet1 and spreadsheet2 as below, the column "Time" is a drop down field, while the other 2 columns are text.


Fields in spreadsheet1:


Fields in spreadsheet2:


From the above I would like to achieve when I select a time in spreadsheet1, the time column in spreadsheet2 will change into the time selected in spreadsheet1. 

Expected result:


Thank you for any input! 


Regards,

Wesley

forms;spreadsheet

2


06 Oct, 2022
confluenceUser
confluenceUser

Do read Spreadsheet Deep Customizations for some Joget Spreadsheet tips.

06 Oct, 2022
confluenceUser
confluenceUser

Thank you for your reply.

I had read through the Spreadsheet Deep Customizations and tried some functions on Handsontable like 

afterChange

to attempt detect the changes of Spreadsheet1 and populate the value to SpreadSheet2, but have no luck on achieving what I wanted to.

Do you mind giving some example for my case above?

Thank you very much! 


Regards,

Wesley

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print