Aware IM User Forums

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

PointsWell

I am trying to build a Validate As regex for telephone numbers (specifically that they only contain numbers and notation elements - i.e. not characters and not tabs etc) - so I tried first with /[\\d ().-]/ and that didn't work even though when I test it at Regex101.com it validates correctly. After...

PointsWell

In the configurator when editing a BO a window to show the BO rules that are associated with the currently selected attribute.

Would make it quicker to delete / modify attributes if you could see the rules (which means this probably sits below the attribute list window in order to be wide enough.

Aware IM User Forums

Search found 1458 matches

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

[SOLVED] REGEX Pain / Problem

Re: [OFFICIAL] the v8.2 "minor" improvement list