Herege - profile

Herege · Jul 17, 2023

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...

Herege · Jul 13, 2023

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 ...

Herege · Jul 10, 2023

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...

Herege · Jul 19, 2023

Yes, probably you're right.Anyeay, thanks for the reply 

Herege · Jul 16, 2023

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 

Herege · Jul 15, 2023

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...

Herege · Jul 14, 2023

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 ...

Herege · Jul 13, 2023

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...

User Statistics

User Activity

Time difference formula and field update time

Find Duplicate Email

Returning n integer

Re: Time difference formula and field update time

Re: Find Duplicate Email

Re: Find Duplicate Email

Re: Find Duplicate Email

Re: Random number functions