Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

3

3
Rodrigo Serafim
Ligar 01/10/19, 11:25

You just concatenate the 3 properties together with an Arithmetic formula, then you can setup your unique constraint on that calculated field.

When using different data types your best bet is usually to convert everything to string. Be careful with padding things correctly so that things are really unique.

  • Flag

That sounds like a good solution. However, I've been trying to convert both the time and date fields to string, but can't seem to find the formulas to do so. I even tried to convert to a numeric first and then to a string, but ran into the same problem. I've made a post about this here: https://forum.quidgest.net/forum/q-a-2/question/converting-dates-and-times-357

Thank you for your time.

Nuno Sousa
ativo 02/10/19, 08:52

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

10 follower(s)

Stats

Asked: 01/10/19, 11:08
Seen: 1877 times
Last updated: 22/11/19, 11:06