Java Script not saving two variables (date & Time)

Avatar

Avatar

bryceh57660644

Avatar

bryceh57660644

bryceh57660644

08-06-2020

I have two pages with the same issue.  I am trying to save date and time in two separate spots. When I test if the data is being captured in the form via an Alert() or debug mode, I am seeing that the values pass through, but they are not being saved

 

In the form:

bryceh57660644_1-1591667743368.png

 

Java Script

bryceh57660644_0-1591667691757.png

 

In the script after the web page:

bryceh57660644_2-1591667850486.png

 

Here are the page variables:

bryceh57660644_3-1591667890453.png

 Data Schema:

bryceh57660644_4-1591667941352.png

 

These variables have worked in the past but I am not sure what I have done to stop them from working.

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

Jyoti_Y
MVP

09-06-2020

Hi,

 

There are two points which you can check:

1) Value of variable ID, as you are doing insert or update operation, are you passing id value in your xtk.session.Write. If yes, then please check what is the value generated.

2) Typecast string variables to date and time data type.

 

Thanks.

Answers (2)

Answers (2)

Avatar

Avatar

Anita_p

MVP

Avatar

Anita_p

MVP

Anita_p
MVP

11-06-2020

Hi @bryceh57660644 ,

Check below in your script:

  •  The variable definitions are correct as per what you have declared in the form as storage
  •  try adding  "_key" in your xtk.session.write function as below:

             Screen Shot 2020-06-11 at 8.24.18 pm.png

Here "v_id" would be IDs in your case as you are trying to save the values for a particular record and I believe it is missing currently , hence you are not able to see the value getting inserted/updated.

 

Hope this helps.

Thanks.

 

 

       

Avatar

Avatar

isahore

Avatar

isahore

isahore

08-06-2020

Hi @bryceh57660644 ,

 

Can you check in the javascript using logInfo(typeof <<variableName>>); what is the data type of the variables that are captured from the ctx.vars variables? Most probably the variables contactdate and contacttime in your javascript are of type String. You would need to typecast them before saving into your table.

Let me know if that helped?