kallehval

Hi I would like to know if there is a way to calculate if there is overflowing text in a textfield? I would like to alert the user that the field has more content than the eye sees by making a color change or inserting an alert image or something else. Is this possible? Does fielmaker have a function to check this by default? The field can be of different sizes. Thanks in advance... Kasper

Hi Forum I need to change the content of af field after 24 hours. I think i need to make a field that stamps the time and use this in a calculation, but I am not shure how to make the calculation needed for this to happen. Can anyone help please? Thanks in advance... Kasper

Hi Tominator You are absolutely right, humans have been involved ;-) and the data is not very cinsistant. This is whats working for me so far: My left field: LeftWords( Substitute(TheField; ["."; " "] ); 1) Right field (temporarycalculation) Let (n = Position ( TheFIeld ; "." ; 1 ; 1 ) ; Right ( Kap ; Length ( Kap) -n) ) Right field LeftWords( Substitute(calc_temp; ["*"; " "] ); 1) It is dirty, but I actually end up with the correct data. My only problem is, that the right field should come up empty if there is no "." in "TheField". Now it shows up as: TheField: 20 Left: 20 Right: 20

Hi Bcooney This did the trick - perfect! There is just one thing: Some of the entries has no "." - just a number. And others has a "*" instead of "." These should also be listed together with the ones before the period: For example: 23.43 12 45.56 12.76 34*45 First field should look like: 23 12 45 12 34 So the calculation should look for a "." or "*" and list whats in front. And if there are no "." or "'*" the claculation should just list the whole number All this is because of a poor planning of the database in the first place (7 years ago) - and now the database has 83000 entries! Thanks again...

Hi guys I have a field which for example look like this: 1.22 45.1 43.45 I need to extract what's in front of the "." to one calc field and whts behind to another calc field for sorting reasons. Does anybody have an idea for this calculation? Thanks in advance... Kasper

The pupose of the calculation is to sort the text field alphabetically correct with faroese letters. This should be like this for example: a á b c and son on. Here is a small test file. I have made it to test with a, á and ä. It seems that FileMaker don't care if it is upper- or lowercase. Write a letter in the top field, and the calculation will give a result (1, 2 or 3 depending on the letter in the textfield). The last field is writing the unicode value. It seems that to FileMaker A and Á is the same, but Ä is diffrent (even though the unicode values are clearly diffrent)? It's by the way pretty cool, that you can calculate with unicode letters (if it worked like it should) test_alfabet.zip

Hi everybody I am tmaking af database solution for a Faroese customer. The faroese has special characters such as "á". I would like to make a simple calculation, which returns a number based on the first letter of a textfield. This is no problem and is working fine, exept with certain special characters such as the á. I have made a simple "case" calculation and included the "Char" command to specify the unicode number for the letters. It seems like there might be some kind of error in FileMaker, because the ä is working fine, but the á is not??? Any ideas? Heres my calculation: Case ( Left ( tekstfelt ; 1 )=Char(65) ; 1 ; Left ( tekstfelt ; 1 )=Char(193) ; 2 ; Left ( tekstfelt ; 1 )=Char(196) ; 3 ) Thanks in advance, could really use som ideas here! Kasper