Load data to form

Confluence User - 10 Sep, 2015

I want to load data from a table and display it in form as read only.
How can I do that? 

forms

6


10 Sep, 2015
confluenceUser
confluenceUser

Hi Hashim,

Try using hash variables (read up here - Hash Variables and Form Hash Variable). Many ways to do this depending on your requirements. One way is to create a form, then set the respective form fields properties to "Readonly" and/or "Display field as Label when readonly". In the "Value" property of the form field, insert the respective "hash variables" to display the data.

Hope that helps.

JAck

11 Sep, 2015
confluenceUser
confluenceUser

Hi Jack,

In my understanding, hash variable only get runtime value from the system. Can I get data from any table?
For example, in case of Leave application, we create a table to store the leave application details. We also should have another table to store the leave entitlement, the number of leave taken and leave balance.

So how to get the info from that  table to display to user their leave balance.
Other than datalist, is there any way to display that data? for example at html page. 

Hashim

11 Sep, 2015
confluenceUser
confluenceUser

In other words, how to create an application that have a combination of data driven and process driven features?...and the process will update the data? :)

14 Sep, 2015
confluenceUser
confluenceUser

With HAsh Variable, depending on your requirements, you can get stored data from multiple tables and display them almost anywhere in your Joget WF app. It all boils down to how you design your app. Cheers!

14 Sep, 2015
confluenceUser
confluenceUser

Hi Jack, The requirement involves displaying a single record data for current user. This should be simple enough yet I still fail to make it works :) . I created a form as you said, with all the textfields to display the data from table named annualLeaveInfo. I set form hash variable at the textfield value ( ie #form.annualLeaveInfo.leaveTaken#) and it doesnt work.

14 Sep, 2015
confluenceUser
confluenceUser

I think the form we create to save the data should be able to display it back.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print