
1. Re: Can a field be set up to make a simple formula directly inside of it?
kapitaen_1 Feb 14, 2010 10:51 PM (in response to marco96)have a closer look at the evaluate function...
http://www.filemaker.com/help/html/func_ref3.33.4.html#1027719
greetings from germany
chris

2. Re: Can a field be set up to make a simple formula directly inside of it?
marco96 Feb 27, 2010 12:26 AM (in response to marco96)I am trying to place this formula ... "Evaluate(TextField)" into the specify calculation window for a field but it comes up and says "field can not be found".
What exactly do I type into the "specify calculation" window? I am using a text field. Do I need to make it a calculation field?
I simply want to type in simple math in a field and have it calculate it for me.
Thank You
Marco

3. Re: Can a field be set up to make a simple formula directly inside of it?
kapitaen_1 Feb 27, 2010 4:50 AM (in response to marco96)feldwert setzen (meinetabelle::meinergebnisfeld; berechne (meinetabelle::meincalcfeld))
set field (mytable::myresultfield; evaluate (mytable::myfiieldwiththeformula))
done.
greetings from germany

4. Re: Can a field be set up to make a simple formula directly inside of it?
marco96 Feb 27, 2010 8:26 AM (in response to marco96)I am not able to make this work. My table is called "projects" the field is called "amount". It is all on the same table and layout. I have tried typing in the suggested formula and I still can't get it to work.
Maybe my problem is I trying to do this from one field? Can you have one field that you type a formula like... 2+2, or 10x25, and have the result show in the same field?
Sorry I am just a rookie here. I am not sure what to type into the "specify calculations" window.
Thank you for your time
Marco

5. Re: Can a field be set up to make a simple formula directly inside of it?
comment_1 Feb 27, 2010 8:43 AM (in response to marco96)
marco96 wrote:Can you have one field that you type a formula like... 2+2, or 10x25, and have the result show in the same field?
Yes, you can: make the field a text field, and set it to autoenter calculated value =
Evaluate ( Self )
Uncheck the 'Do not replace existing value…' option.
Note that this will overwrite the entered formula with the result.

6. Re: Can a field be set up to make a simple formula directly inside of it?
marco96 Feb 27, 2010 9:05 AM (in response to marco96)That works great!
Now the other thing I was hoping for was, (I know I'm really pushing it here) Is there a way to have the field show the formula that I typed in when I click on it.? In other work, if I typed 30+10 can I see that when I click back into the field and when I click out of the field see 40?
Thank You.
Marco

7. Re: Can a field be set up to make a simple formula directly inside of it?
comment_1 Feb 27, 2010 9:16 AM (in response to marco96)Not if using only one field (as I said, the formula is overwritten with the result and doesn't exist anymore). But you can use two fields, a Text field for the fomula, and a Calculation field =
Evaluate ( YourTextField )
If, on your layout, you place the calculation field on top of the formula field and make it nonenterable, it will work the way you have described.

8. Re: Can a field be set up to make a simple formula directly inside of it?
marco96 Feb 27, 2010 9:26 AM (in response to marco96)Thank you, you have been very helpful.
Marco