Forum | Appery.io

Not all of my fields are saving in my database when people click the submit button, The text they enter in the text box does not save, nor does the date it just shows up as mm/dd/yyyy

Hello,

What fields are save data?
Please send screenshots with mapping your service and service settings.

All the other ones save except for those 2 fields

Hello!

Could you clarify why do you use string type for date? It's better to use date type. Please also post mapping screemshot.

I changed the Date field and it still didn't change it.

Hello,

Could you please check if you have any errors in developer console?

It tests fine

Hi Nmalaur.

You probably mistaken in your mapping. (Sorry but screen shot you have provided above can not to answer this question).

See detail in screen shot: http://prntscr.com/3le7ok/direct

So you have to use "Date value" component property.

Please note: if you using "string" field type in DB - your direct mapping would be ok.

But if you using "Date" field type in DB - it requires some format to store it correctly.

See solution for this case:

1 Navigate to "Request" tab.

2 Find "Date" parameter in request tab and click "Add JS". http://prntscr.com/3aqhpn/direct

3 JS editor appears. Fill it with following code: http://prntscr.com/3aqic0/direct

precode

return new Date(value).toISOString().replace(/T.*/gi, "");

/code/pre

Regards.