Log in to AnswerLog in to Follow
Yuichiro Tada
26Views
9Comments
[Data Grid Web] Initial value of GridColumnDateTime of DataGrid
Question
DataGrid
Forge
Data Grid Web
Forge component by OutSystems R&D

Hi Everyone,


I am editing the date and time using GridColumnDateTime of DataGrid.

The system date is set automatically when I move the cursor to the target column, but I want to prevent it from being set.


Thanks!

0
0
on 2020-10-19

Hello Yuichiro Tada,


Could you please give us an example so that we can examine and try to give you the best option according to your needs?
 

Thank you,

Tiago Pereira

0
0
on 2020-10-19

Hi Yuichiro Tada,

You can set value for datetime on OnInitialize event so its show that datetime which you was set.
By using this approach you can set value or show form entity.


Thanks

Rahul Jain


datetime.PNG

0
0
on 2020-10-19

Thank you for your answer.

But it seems a little different from what I want to do.


When I cursor in, today's date is set by default.

What I want to do is make sure that nothing is set when the cursor is in.


Can you see the attached file?

DataGridDateTimeQA.xlsx

0
0
on 2020-10-20

Hello Yuichiro Tada,

Thank you for the explanation.

We are currently setting the current date for the clicked DateTime cells.
We are going to analyze your request and let you know as soon as we have a solution.


Thank you

0
0
on 2020-10-20

Hello Yuichiro Tada,

Thanks for bringing this subject to the discussion.

DataGrid component is currently using a handler to set the default value on double click equal to the current date for Date columns.

Nevertheless, I created a sample just to illustrate how you can accomplish that specific behavior, could you please check the sample attached to this message?

As a workaround, you can use the sample as an example. You will need to include a Web Block containing the method that you want to set a new handler for the Dates. (This block is included in the sample attached)



Inside the Web Block you can see that we have a Javascript block containing a setTimeout. We need to wait for the grid to load the group panel otherwise, we will get an error. Feel free to create your own method.

Hope this sample is useful if you need to extend DataGrid to remove the default value on double click for Date columns.

Tiago Pereira

DataGridDateTimeEmpty.oml

0
0
on 2020-10-20

Replying to Tiago Miguel Pereira's comment on 20 Oct 2020 08:54:50

Thank you for providing me with a sample.

I confirmed the operation, but it seems that today's date is set as the default date by double-clicking.

-> newCellEditionMethod has not been called.


How can I make the value unset specifically?

0
0
on 2020-11-02

Replying to Yuichiro Tada's comment on 02 Nov 2020 02:16:30

Hello Yuichiro Tada,


Could you please send us the sample you are using, so we can see what's going on?
 

Thank you,

Gabriel Lundgren

0
0
on 2020-11-02

Replying to Gabriel Lundgren's comment on 02 Nov 2020 09:53:37

Hi,


I took some time to reply.


The event handler prepareCellForEdit does not occur.

Therefore, the value value cannot be initialized.


Is it possible to implement in events other than prepareCellForEdit?

0
0
on 18th Jan

Replying to Yuichiro Tada's comment on 18 Jan 2021 04:30:51

Hello @Yuichiro Tada 

Can you please let me know if this forum post is the one where you are trying to use the prepareCellForEdit event?

https://www.outsystems.com/forums/discussion/68237/data-grid-web-datagrid-cannot-pick-up-preparecellforedit-events/

Thanks,

Bruno Martinho

0
0
on 17th Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.