Hello guys,I have a field that use a simple formula to calculate the time passed (in minutes) between the created time of a record and Now that goes like this: DATETIME_DIFF( {Created}, NOW(), 'minutes') * -1 The time displayed in minutes on the f...
Hello guys,I'm trying to create an automation that:When a new record is created -> Compare "E-mail" field with existing records -> If true, do something.The issue I'm facing is that: The automation is comparing the email to the contact being created ...
Hello guys,I'm struggling to achieve the desired results here. First: I have a formula that return a number between 1-156 based on the created time of a record:(VALUE(DATETIME_FORMAT(CREATED_TIME(), '0.smh'))*(156-1))+0000 Although I want this formul...
Oh that makes a lot of sense.Thanks a lot for the explanation I didn't get it before because I thought was something like the "length" in characters of a string or number.Anyway, much thanks again
Thanks a lot for the reply.Actually I found another way to compare because I have another table where I have a column with some of those email. So all good Although I'm curious about the length property.Does this means the number of character a valu...
Thanks or your reply "Hmm, I'm assuming the new record is being created in "Table 1" with that email value, and you want to make sure that's the only record with that email?"Exactly. I want that someone cannot send this request more than once on my ...
Thanks Joachim. That works very nice and without much complications.I need to generate a random number between 1 and 156 and I just replaced the 30 for 156 and Voila :D.I'm not exactly sure how that works but looks good, Although I got a lot of 1's a...
