quillpro

Would you be willing to share your FM file? I could take a look at it. I am also trying to do something similar.

I have a number field that I want to display as part of a calculated result in a text field. I want to the number to display as a decimal (ie 50.00). I have tried using SetPrecision( number_field ; 2 ) and Truncate( number_field ; 2 ). I have tried different combinations of GetAsText and GetAsNumber. Here's one way I tried: Let ( amount = SetPrecision ( numberField ; 2 ) ; "Date: " date & "; Amount $ " & amount ) No Luck. It seems like these ideas would work, but NO. Any help? Thank you. Quillpro

Thank you that work perfectly. I think I tried almost that very thing but I used it as an if statement.

For ease of explanation, let say I am creating a checkbook register. I have two fields "Credits" and "Debits". What I want to happen is if I already entered a value in the "Credits" field and I then put a value in the "Debits" field the value in "Credits" would be removed or vise versa. I have tried many attempts using auto enters and calculations but to no luck. Any direction would be most appreciated. Thanks

I have gathered some more info from some other posts. But if anybody has anything else to add I am still appreciative.

How does one become a certified Filemaker Developer. I live in South Central Pennsylvania near Harrisburg, Lancaster, and Baltimore, MD. I have seen courses offered in my area but none seem have any certification program. Any thoughts on the matter are greatly appreciated.

I have a single user version of 6 for the mac. But I see from your profile you are XP. Sorry can't help.

You need a calculation something like this: If ( Month ( date ) = 12 ; Date ( 1 ; Day ( date ) ; Year ( date ) + 1 ) ; Date ( Month ( date ) + 1 ; Day ( date ) ; Year ( date ) ) ) I attached a simple file that has a date field, a calc field that use the above calc, and a field that tells the days detween the two dates. Hopefuly that will help. dates.fp7.zip

Hi, I attached an example of what I believe you want. If you would like further assistance please contact me via the email in my profile. Good Luck rating.zip

Does anyone have or know of any webhost reselling solutions for FM 7 or 8. I need to track customers, assign hosting packages, track expire dates, payment history, etc. I wanted to see if one existed before I try and build one myself. TIA

Thanks for the advice. It work great. The only thing I could not figure out was how to make a field "null" on commit. So insead I use a serial number auto entered on commit. And set the relationship to less than zero.

Thanks for the advice. I will give these a try.

I once saw a post that explained how to create a top row portal entry solutions. I can't find it anymore. Anyone know where or have an example or explanation.

How can I compare a fields content against the values in a value list as a script step. My attempts so far have failed. Thanks

Hi, I am a graphic designer in PA. If your project isn't to complex I can probably help. Send me an email with some of the particulars. I could produce a couple of samples if you need them.