Welcome!

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

Hide Intro Register

Validating unique combination

Nuno Sousa

on 10/1/19, 11:08 AM • 1,939 views

Hello.

I am building a vet clinic app, in which I need to make sure there are no appointments being made for the same doctor at the same time of an already existing appointment.

Example:

Doctor1 has an appointment for 01/10/2019 at 10am. I need to display an error if I try to insert another appointment for the same doctor at the same date and time. But if 1 of the 3 properties is different, it should be added.

So basically what I need to know is how can I make a combination of 3 variables unique?

Thanks in advance,

Flag

Reply
Comment
Share

Rodrigo Serafim

On 10/1/19, 11:25 AM

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

on 10/2/19, 8:52 AM

Comment

Ask a Question

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: 10/1/19, 11:08 AM
Seen: 1939 times
Last updated: 11/22/19, 11:06 AM