Problem with data structure

How To
1

Hi

I need some help.
I building scenario which will get data from Elementor form and store in Data store by Data structure definition.

image
image915×630 45.1 KB

I need this data for :

  1. Send SMSAPI text message (work fine)
  2. Re send email after 6 days (there is starting issue)

To get details for future email sent i have to store data in Data store with following structure:

image
image1713×135 7.11 KB

I have a problem with data structure for DATA, TIME and IP

image
image525×985 29 KB

The issue is related to Add/Replace a record for Data store

image
image871×481 34.1 KB

image
image458×1070 44.4 KB

When I run this scenario I getting following issue:

image
image950×571 36.5 KB

image
image871×600 44.8 KB

image
image771×664 63 KB

When I removed Date, Time and Remote IP from Record, but i will keep this information in Key section and rerun scenario, the Data store will be created successfuly with KEY details.

image
image449×1078 42.7 KB

image
image947×606 36.8 KB

image
image770×610 44.8 KB

image
image1804×214 28.9 KB

Any idea how to store Date, Time and Remote IP ?
Based on this information I would like to check records by date and time , grab email and sent email to customer after 6 days.

Thanks for any advice

2

Hi,
To resolve your problem, ensure that all the values (Date, Time, Remote IP) are in the same data format. I noticed that the Remote IP appears to be a number but it include “.”, which will not be accepted as number. Please use text instead of a number for the Remote IP field.

Regarding the Date and Time, please utilize the formatDate and parseDate functions to convert them into the appropriate Date format.

Thanks & Regards

MSquare Support
Visit us here
Youtube Channel

2 Likes
3

All issue is sorted, Thank you

2 Likes
4

Hi @Robert

I’m happy to hear it’s working.If you require additional assistance, feel free to reach out without any hesitation.

MSquare Support
Visit us here
Youtube Channel

2 Likes