# djgogi

Members

583

## Community Reputation

0 Neutral

• Rank
member
• Birthday 07/14/1966

• Gender
Male
• Location
Pisa, Italy

## Recent Profile Visitors

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

1. ## Self Join problem

If you want to see all recs with marked_b set to 1 than the relationship should point from constant_n to marked_b and not viceversa (as you have set). Otherwise if you need to see all records with values of marked_b depending on current record value, you should create a relationship on the marked_b field itself Dj
2. ## Dynamic Lookup fields

Actually you should try it Dj
3. ## Match a word to another table's contents?

Simply define an relationship from "Countries" table to "Articles" table country-->address. Then create an calculation field (in Countries table) Count(TheAboveRelName::nameOfSomeNonEmptyFieldInArticlesTable) Dj
4. ## Need help creating a calculation

That one looks rigth to me. Dj
5. ## Need help creating a calculation

I've just checked it. It does not respect the coversion table: In 14:31(=14.50) Out 15:03(=15.10) Diff=0.6 while your formula yields 0.5 Dj
6. ## Need help creating a calculation

Right, I didn't check the formula you gave him! Dj
7. ## Need help creating a calculation

10:45 (=10.80)-9:57(=10.00) gives 0.80 9:57 is 10.00 He, only, didn't make it explicit in his post! DJ
8. ## Need help creating a calculation

Hour ( timeIn )+ Case ( Minute ( timeIn ) > 56 ; 1.00 ; Minute ( timeIn )>50; 0.90 ; Minute ( timeIn )>44; 0.80 ; Minute ( timeIn )>38; 0.70 ; Minute ( timeIn )>32; 0.60 ; Minute ( timeIn )>26; 0.50 ; Minute ( timeIn )>20;0.40 ; Minute ( timeIn )>14; 0.30 ; Minute ( timeIn )>8; 0.20 ; Minute ( timeIn )>2; 0.10 ;0) Dj
9. ## A simple question that's gotten me foxed

Hi Substitute ( (10 ^ num)-1 ; "9"; Substitute ( (10 ^ num)-1 ; "9" ; textToRep ) ) Setting num to 404 and textToRep to "ask" took only 2 seconds in same configuration as your. BTW it's 163216 times repeated word "ask"
10. ## A simple question that's gotten me foxed

oops! I didn't check it It will work. dj
11. ## A simple question that's gotten me foxed

It didn't have time to do the conversion. If you split the calc, ie create test=(10^num)-1 and than substitute(test; "9";"aaa") it won't work Dj
12. ## A simple question that's gotten me foxed

I was only kidding, the true formula is Substitute ( (10 ^ num)-1 ; "9" ; textToRep ) If necessary it could be extended for values for "num" greater than 404 Dj
13. ## A simple question that's gotten me foxed

Substitute (Floor ( Exp ( Ln ( 10 ^ num )) ) ; "9" ; "a" ) Dj
14. ## Exporting layouts

Go to desired Layout Print to PDF, blank record showing fields as formated Dj
15. ## Custom ABC Sort Order

I didn't have time to reply yesterday, so I was saying the above (the ASCII stuff) because, coincidentally, I have just finished the work on commissioned Sanskrit dictionary ( 57 symbols including diphthongs and triphthongs ) where I was affronting the same question. Globals or related field are out of question because of indexing issue as you surely know. In this moment I can not send you the complete solution (think that my client wouldn't be very happy), but I can assure you that it works like a charm. The substitutive calculation must be indexed or as I said the sort and search could become extremely slow. Also be aware on 63 items in chain limit of Substitute function, so it might be necessary to split the calculation in two fields. (I had to do so because my client asked also to make (ab)use of equivalent characters like e, CustomAlphabet.zip
×
×
• Create New...