Pass default value in initial screen

[Former Member]

Hi friends,

I want the data to be displayed without pressing the submit button...this should be initial data depending on the date which is 1 day less than current date....that is the initial screen should have data without user clicking on submit button.(submit event)

I can get the data on pressing the submi button....but hw to get without submit...

Thanks

[Former Member · Accepted solution]

Hi Anuj,

Follow below steps to achieve your requirement.

1) Drag 1 Form View on in the iView on DashBoard.

2) Right Click on FormView and Select "Configure Element".

3) Click on "+" button to add the Fields on the Form View.

4) Select the "Date Picker" Control type from available Control type list.

5) Go to the properties of that Date Field (Double Click on that Filed). Control Properties Pop up window opens.

6) Select "General" Tab from Control Properties Window.

7) Click on the Formula button to set the default value.

😎 Use the Date Functions to set the initial values. For displaying the date which is 1 day less than current date, place following formula. "DADD(NOW(),-1,'D')".

9) Click on Check button to check whether formula is correct or not. If correct Click on OK button.

10) Deploy the VC application and Run the Same.

11) Date field contains The date which is less that Current Date.

Please let me know if you have any further help.

Regards,

Prashant

Points...??

[Former Member]

Thanks

[Former Member]

I had the same problem. And the solution is both the answers given above.

1) Make a start point from the "Compose" section (choose "Start" an arrow)

2) Map the start point to the service you want to use

3) Write a formula with the dates clicking the connection line and use the right-hand column "Assigned".

It works in runtime on start. At least for me

VC 7.0 SP 14

[Former Member]

You need to add a start point before your data service. Add the query or needed values to the input port from this start point.

Hope it helps

Henning

[Former Member]

For yesterday use DADD(NOW(),-1,'D')

Henning

[Former Member]

Hi Anuj,

are you talking about data from a BI query? In that case you can use an exit variable (current date, if available) in the query designer and offset it -1. Then the user doesn't have to provide input and the query will return the correct results immediately.

Regards,

Arno