cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Date Pickup inside Grid table

SOLVED
Level 7

Date Pickup inside Grid table

Hello Everyone,

 

I have Question If Possible have date pickup inside Grid table 

in the below table for daily action i want when the Clint click on Due date open date widget to select instate of write by hand 

Info.PNG

Thanks,

Islam

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Date Pickup inside Grid table

Assuming your actions (rows) already exist, then

1.Double click a row

2. use navigation widget to open a new popup mashup

3. pass parameter of the ROW_ID to the new popup

4. use a date widget so Client can enter or select a date

5. use button to trigger a SQL UPDATE service for the ROW_ID

6. on close of the popup, refresh the grid, so client can see the updated row with date

 

this way you add a date to existing action

6 REPLIES

Re: Date Pickup inside Grid table

Assuming your actions (rows) already exist, then

1.Double click a row

2. use navigation widget to open a new popup mashup

3. pass parameter of the ROW_ID to the new popup

4. use a date widget so Client can enter or select a date

5. use button to trigger a SQL UPDATE service for the ROW_ID

6. on close of the popup, refresh the grid, so client can see the updated row with date

 

this way you add a date to existing action

Re: Date Pickup inside Grid table

Hello @MichalC 

 

Thanks for Support 

 

i I believe that  right way to do it , Could you Please explain with Pic 

 

Regards,

Islam Amer

Re: Date Pickup inside Grid table

Hello @MichalC 

 

Thanks for Support 

 

I believe that  right way to do it , Could you Please explain with Pic 

 

Regards,

Islam Amer

Re: Date Pickup inside Grid table

What part you don't understand?

Re: Date Pickup inside Grid table

How to pass parameter of the ROW_ID to the new popup ?

Re: Date Pickup inside Grid table

In the pop up mashup click on the main mashup and from the upside down triangle in the left upper menu select CONFIGURE or something like that, in the new window add a new property, make up a name for example ROW_ID and type matching your ID column from the table.
Save and go back to the mashup displaying your table with data.
Add a new widget: NAVIGATION.
In properties add your new mashup name then set open as pop up.
Then click the service that gets your table data, expand it, look for SELECTED ROW, expand it and find your table ID column.
Click and drag the ID column onto your NAVIGATION widget then confirm it as input to your new property ROW_ID.
Then click the grid widget, from the left hand side properties, scroll down and find DOUBLE CLICKED.
Click and drag it onto the navigation widget and select NAVIGATE.

This will pass the selected row ID to the new pop up mashup.