Getting date and time in schema

[Partha18]

Hi,

consider i have created a web application and a schema for it.

Web page have name, age and email and a submit button. when he fills the form and submit it, data is getting added in schema successfully.

But in schema i want an additional column like "registered time".

In that, schema automatically wants to take the date and time of the data entered into data schema.

is that possible? If so what i need to do to achieve it?

consider schema name as "par:registration" and column i want is "registered time".

<attribute name="registered time" label="Registered time" type="datetime"/>

Thanks in advance,

ParthaSarathy 

[Jonathon_wodnicki · Accepted solution]

Hi,

Add default="GetDate()" to your attribute.

Thanks,

-Jon

[vani97]

Hi @Jonathon_wodnicki 

Added default="GetDate()"

But its not populating auto date value in the schema 

couldn you please help on that?

[ParthaSarathy]

Hi @vani97 ,

Change type as datetime.

 <attribute default="GetDate()" label="Order date" name="orderDate" type="datetime"/>

[vani97]

Hi @ParthaSarathy 

Changed data type as date and time but not getting updated in schema 

how i can able to connect attribute in to web app when user submit the form 

I added order date in preloading activity 

I think there should be a logic when sublitting the web app

is there any changes in web app 

[vani97]

Hi @Partha18 
Was that resolved How you updated the date value in schema 

Could you please help on that?