Solving Data Structure Issues on Make.com: A Guide

Have you ever encountered a problem with storing data in a specific structure? This is a common issue that many Make.com users face, especially when dealing with different data types like Date, Time, and IP addresses. In this blog post, we'll walk you through a step-by-step solution to this problem.

The Problem

A user was trying to store data from an Elementor form into a Data store using a specific data structure. The data was needed for two purposes: sending an SMSAPI text message (which was working fine) and resending an email after 6 days (which was causing issues).

The user was having trouble storing Date, Time, and Remote IP. When trying to add or replace a record for the Data store, an error occurred. However, when the Date, Time, and Remote IP were removed from the Record but kept in the Key section, the Data store was created successfully.

The Solution

To resolve this issue, it's important to ensure that all the values (Date, Time, Remote IP) are in the same data format. The Remote IP, in particular, appeared to be a number but included a “.”, which is not accepted as a number. Therefore, it's recommended to use text instead of a number for the Remote IP field.

As for the Date and Time, the formatDate and parseDate functions can be used to convert them into the appropriate Date format.

Troubleshooting Tips

If you're still encountering issues, double-check your data formats. Make sure that all fields are in the correct format and that no incompatible data types are being used. Also, remember to use the appropriate functions for data conversion when necessary.

Conclusion

Dealing with different data types can be tricky, but with the right approach, you can easily store your data in the desired structure. Remember to always check your data formats and use the appropriate functions for data conversion. We hope this guide has been helpful in solving your data structure issues on Make.com.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.