Jump to content

jrRaid

Members
  • Content Count

    103
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jrRaid

  • Rank
    member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I have it working now. Using 3 different custom functions and an additional data field with a script trigger. The trigger will take the value from the field and determine which CF to use. It seems to cover all the possible needed outcome. Tx
  2. Ok, thanks. Let me chew on that for a while. I think I have enough info to (maybe/hope so) find a solution by myself now. Like I said, this is completely new for me.
  3. Ok, from the beginning (if you don't mind, I never went that deep in calculation/logic) We need a return form of xx-xxx if we have 5 digits in the field text We filter the content of field text to only have the digits. We test if from the filtering the first character is a digit num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) That will return a 1 for true or a 0 for false We test for the next character num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ) Returns a 1 or 0 Test the next: not IsEmpty ( Filter ( Middle ( text ; 3 ;
  4. I want/try to learn something here: Let ( [ digits = "0123456789" ; len = Length ( text ) ; num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) ; num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ) Here you check for 1 or more than 2 digits... So, if I want to test first to see how many digits I have: num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) ; num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ); num3 = not IsEmpty ( Filter ( Middle ( text ; 3 ; 2 ) ; digits )); num4 = not IsEmpty ( Filter ( Middle (
  5. Comment, I'm sorry.. I presented the solution this morning and the power in charge wants to see a group of 5 digits as xx-xxx. I made already attempts myself, but I'm getting nowhere so far...yet. Are you willing to tell me what and where I have to change the syntax ? Thank you.
  6. odd numbers of digits in group of 2 x: x xxx: xx-x xy: x-y xxxy: xx-x-y yyyxxxxx: yyy-xx-xx-x
  7. As I said, the CF (http://www.briandunning.com/cf/395) will return the letters separated from the digits/numbers. ABCD-1234, where I need ABCD-12-34 or, when no letters as input data: 12-34
  8. It should separate the letters from the digits, regardless how many letters. xxxx should return xx-xx xxxx with any letter at whatever place xx-xx-letter, letter(s)-xx-xx etc.
  9. Hi all, I have a text field that can hold data in the form x and y, where x is digit and y letter. It can have several different combinations: yyyxxxx, xxxxyyy, xxyyyxx etc. I need a return in the form: when there only digits, like xxxx, xx-xx (a dash every 2 digits) when there is a combination, like yyyxxxx, yyy-xx-xx (letters, dash, 2 digits, dash, 2 digits) xxxxyyy, xx-xx-yyy xxyyyxx, xx-yyy-xx Any hint of possible formula ? I use already a cf to separate the letters from the digits, but can't
  10. Duh... I had that step in the first file instead of in the second.... It's working now... Tx
  11. I have two files (not tables) with in the first file a GTRR to the second file. This is working, only, the related records are showing in the second file, where I want them as window on top of the first file. Which script step do I miss or have to use? Now I have to click on the 'Window' in the taskbar.... Tx
  12. Sure. One main table with general contact data. A related table for all the types of addresses, work, home etc A related table for all the telephone numbers, work,home...etc I show the info of those tables on the main layout and there I can sort them. The 'primary' address and telephone etc are the first row in each portaql. So, if the home address is in the first portal row, that will be the primary address and should be used in all other places where the address of that contact is used. When I change the order in the address portal, and another address becomes th
  13. Hi all, I'm looking for a way to dynamically flag which record is the first in a portal. I have a portal showing records from a related table. I can sort the record in the portal. Now I need to know which record is the first one after sorting, because I need that record showing up in an other portal. In that portal I need to show all the records flagged as 'first'. Any hint? TIA
  14. Now I get somewhere. Thanks for the info. Appreciate.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.