Expand my Community achievements bar.

SOLVED

Java Script not saving two variables (date & Time)

Avatar

Level 2

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.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

3 Replies

Avatar

Community Advisor

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?

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 7

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.