Aware IM User Forums

I have 3.666 and 4.55, 55.77 etc values and i only want to take 3 or 4 or 55 from this. If I use round it gives me wrong rounding values.
How do I extract just 3 and 4 or 55 in aware process.

There is also a class in the Apache Validations jar that validates email formats, checking for valid TLD that can be used to create a plug in. Cannot attest to the currency of the TLD data, it seems to be hard coded within the class. https://awareim.com/forum/viewtopic.php?f=4&t=11751 I found it wh...

This worked! thank you.

For now I used crude dynamic rule in BO rules
If NOT(ThisUser.EmailAddress CONTAINS('@')) then
REPORT ERROR 'Please enter valid email'

but I need it with email regex and us phone validation as well.

How to do email and US phone validation via BO new user rule.I have html guest registration and somehow even the type is email in BO column property it lets any value gets saved when html(imported form) form is filled by guest user.

Thanks Mark!

By default date and other values are undefined or null, once set if we want to unset to null or undefined how to do that?

BO.StartDate=''
Does this make it null?

I got it to work by putting this in the Initialization script: config.columns[3].filterable= {multi: true}; The column had to have the filter button in the column header. Hi bssxfire8 config.columns[3].filterable= {multi: true}; this works really great with large dataset(500k rows) but one issue I ...

Works great!
Just need to add stored proc with SELECT SLEEP(20); and it adds delay of 20 seconds between 2 processes!!-

Is it possible use delay from stored proc to wait and then start second process https://www.tutorialspoint.com/how-to-set-delay-for-mysql-trigger-procedure-execution#:~:text=To%20set%20delay%2C%20you%20can,in%20the%20procedure%20execution%20delay.&text=Look%20at%20the%20above%20sample,execution%20de...

Thank you both! Instant server backup on upcloud looks great! Regarding syncback is this the software? https://www.2brightsparks.com/freeware/freeware-hub.html SyncBackPro has extended support for Cloud services (Amazon S3™, Google Storage™, Google Drive™, Google Photos™, Microsoft Azure™, Microsoft...

Is there any good third party software that can be used to automatically backup aware im app production db nightly or on schedule? Backup needs to be on external cloud or somewhere else out of the server.

How to refresh dropdown when generate add new button is clicked(I have custom process to do enter new) and user adds new value. Its not refreshing form dropdown with new values just added by user(i have custom filters as well for the dropdown values). It shows up when user actually start typing in d...

thank you Both. Wow. That was it. Great catching this small thing Bruce. I had an order by that was doing this.

Getting Strange row repeat issue in query second page grid. I have a standard simple query and with 5 items per page settings what is happening for few queries is when you have 7 items 1st item gets shown in second page as second row item again. Has anyone seen this type of issue? 1 2 3 4 5 second p...