djgogi

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

Actually you should try it Dj

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

That one looks rigth to me. Dj

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

Right, I didn't check the formula you gave him! Dj

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

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

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"

oops! I didn't check it It will work. dj

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

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

Substitute (Floor ( Exp ( Ln ( 10 ^ num )) ) ; "9" ; "a" ) Dj

Go to desired Layout Print to PDF, blank record showing fields as formated Dj

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

Well it's little bit more complex than that. Supposing you have defined your alphabet as set of distinct chars, you'll need1: 1) to exclude those chars from ASCII set 2) create an substitutive set from the above ASCII subset 3) Using in chain Substitute function, create your hidden sort field (ASCII for language sort) For ex. Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( yourField, "Q", ":") , "Z", ";") , "E", "<") , "R", "=") , "T", ">") , "Y", "?") Dj

Set Field (yourField, case(yourField="red","yellow", yourField="yellow", "orange" , yourField="orange","green", "red" ) Dj

Use this script step attached to yourField that acts as button (disable entry in it of course) Set Field (yourField, case(yourField=5,10, yourField=10, 15 , 5 ) Dj

Those 170 "fields" should be really 170 records each holding only one answer. Now defining only one supplementary field ("score" with above calculation) and defining one auto relationship on the answer field (selfRel:answer-->answer); you will gain access (without any additional scripting) on score per type of answer thru the calculation Sum(selfRel;:score). In alternative you could define an summary field total as sum of score field and then access individual answer type score by performing find on desired type. In case you have to calculate the answers score on some additional criteria (like for different people that ran the test) you'll need simply to add those criteria in your auto relationship. Dj

here is the method that is suited for your case Dj

Define an other calculated field score=Position("ABCDE", responseField,1,1)-1 Dj

On Mac using Troi URL plugin and some AppleScript: ---AppleScript Insert Pict--- global pictName set pictName to cell "fileName" of record 1 set fpath to ("Macintosh HD:"&pictName) tell app "Finder" try open for access fpath as string with write permission end try end tell set y to get data cell "Received text" of record 1 tell app "Finder" try write y to file fpath close access file fpath end try end tell try set cell "gObj" of record 1 to file fpath on error thErr display dialog thErr end tell where, "Received text" is the result of GET/POST function call to Troi URL plugin, resulting in valid img data Dj PS Until arrive of FM 7 there is 64K limit on size of text that could be inserted in text field.

Define an relationship from your second file to your first file (Supposing the text field in first file is named "intensitiesField" and the valueList field in second file is named "intensitiesList", define an relationship intensitiesRel:intensitiesList--> intensitiesField) Now in your second file define an unstored calc filed of type container as: intensitiyColor=intensitiesRel::colorBarField Put intensitiyColor as background field for your portal. That's it Dj

I've modified the file you sent to achieve the goal: It's done thru additional look-up field (of type text) As alternative approach I've also, set the validation on gnumber to strict numeric type (no script required) Dj Test for numbers only1.fp5.zip

1) You were probably compressing an opened file 2) Don't use recovered files for purposes other than retrieving stored data and then importing them in fresh copy of your DB Dj