Aware IM User Forums

PointsWell

I have lots of good things to say about AIM. I’ve also tried to create a page on the open encyclopaedia that starts with W but the challenge is the lack of other references to AIM around the world (ie referencable resources)

I would’ve moved to AIM much sooner if there had been a W’pedya page.

PointsWell

The null value of Yes/No can be problematic but for different reasons to your testing. if Yes/No attribute <> ‘No’ This is only testing if the attribute does not equal one state: NOT zero 1 is NOT zero, but NULL is also NOT zero. If you want to search for Yes values and you allow NULL as a response ...

PointsWell

As a consequence of the recent changes to that allow full page queries in forms, I am minded to reduce the not insignificant complexity of my app by reformatting the homes screens. Before I head off down that rabbit hole though, I wanted to ask if anyone had any suggestions on providing a consistent...

PointsWell

Sub domain redirections would achieve this. You need records in you DNS.

PointsWell

Jaymer wrote:a regular expression can also search for 0 or more 0's only at the beginning of a line.

Doh Good ol' uncle Regex to the rescue again.

I used the following:

Code: Select all

REPLACE_PATTERN(PhoneRecords.Number, '\A[0]', '')

PointsWell

I would set it up as BOs: Campaign Prospects (as distinct from Customer) TargetProspect - distinct object would allow a Prospect to be targeted multiple times for different campaigns Customer Campaign may have one or more Prospects - Campaign.om_TargetPropspects.ps_Prospects Campaign.StepNo = 1..n I...

PointsWell

If you take a large number in a text field and then use AS_NUMBER to convert it to a number, the number that is output is floating point not an integer. Is there a way to convert that floating point number to an integer? Or better convert the text to an integer from the outset? What is actually bein...

PointsWell

Do I want to go ahead and create all 500 OutgoingEmail recs NOW, and mark 400 of them with a future DeliveryDate (spread out a week apart)? Because now I have the set of 100 recs available. I can run a scheduled job each morning looking for Unsent Emails with a DeliveryDate = TODAY. From a business...

PointsWell

It seems that you can't nest REPLACE_PATTERN What do you mean by that? I have used something like the following: BO.NewAttr = REPLACE_PATTERN(REPLACE_PATTERN(BO.OldAttr, 'find1', 'replace1'), 'find2', 'replace2') You still need multiple REPLACE_PATTERN statements, but they are inside each other and...

PointsWell

This tip is courtesy of BobK and was a response to a question I had of how to remove multiple non numeric characters from a text field that is acting as a numeric field (in this case a telephone number with various notational characters e.g. 1 (555) 333-1212 to get 155221212) https://www.awareim.com...

PointsWell

More to a solution to your problem: If you need to remove all non-numeric characters, you only need 1 REPLACE_PATTERN like: BO.JustNumbers = REPLACE_PATTERN(BO.AlphaNumeric, '[\D]', '') \D matches any non-digit It's little nuggets like this that make this forum such a powerful resource! And saves t...

PointsWell

In my continuing hell of international telephone numbers and notation habits I am now trying to strip out all the crud that I have to allow people to add here This means I have to remove ' ', '(', ')' and '-'. It seems that you can't nest REPLACE_PATTERN so is there another way, other than multiple ...

PointsWell

BobK wrote:You were SOOOOOO close.

BobK that fixed it. Thanks!

Wonder what’s going wrong with the example that’s copied from the user guide?

PointsWell

Jaymer wrote:.

Would be nice if you could do:
If Lead.Country = 'US' THEN Mask='999-999-9999'
If Lead.Country = 'GB' THEN Mask='99-99-9999-999' (or whatever they use)

REST is your friend https://numverify.com

PointsWell

Thanks, I’d checked out your example when I was trying to figure this out, but my issue is that users are entering spaces between numbers, parentheses round groups of numbers etc etc.

Which is why I was trying to get [\d .()-] to work...

Aware IM User Forums

Search found 1460 matches

Re: Reviews on Capterra and G2Crowd

Re: 3-state option for Yes/No please

Form and Specific Panels

Re: Hosting Aware across Sub Domains

Re: AS_NUMBER to Integer

Re: Any suggestions for designing a "Drip" email campaign?

[SOLVED] AS_NUMBER to Integer

Re: Any suggestions for designing a "Drip" email campaign?

Re: REPLACE_PATTERN & Multiple Patterns

REPLACE_PATTERN & Multiple Patterns

Re: REPLACE_PATTERN & Multiple Patterns

[SOLVED] REPLACE_PATTERN & Multiple Patterns

Re: REGEX Pain / Problem

Re: REGEX Pain / Problem

Re: REGEX Pain / Problem