
1. Re: AutoEnter Multiplication Product Question
MorkAfur May 31, 2015 4:07 PM (in response to montshoman)As a starting point, check out the Evaluate function. It will take text and evaluate the result, which seems like what you want.
Evaluate ( "3*5" ) = 15.
 m

2. Re: AutoEnter Multiplication Product Question
philmodjunk May 31, 2015 6:38 PM (in response to montshoman)Note that you use * instead of X as the multiplication operator.
You can also set up two fields instead of 1 and a calculation field with this expression:
Field1 * Field2
to compute the product of fields 1 and 2.

3. Re: AutoEnter Multiplication Product Question
montshoman May 31, 2015 7:19 PM (in response to montshoman)I appreciate your responses, please have patience with me,
Mork Afur  how do you set up your response with varying number combinations, I didn't explain myself very well, 3x5 was an example, it may be 8x4, 2x2, or any variance of combinations not exceeding 8x20, and not smaller than 1x1.5, but these numbers are always in the "size" field, and I was hoping to autoenter the total in the next field "total size"?
PhilModJunk  I may have to result to dividing this information into 2 fields, I was trying to keep it in one field as occasionally this field is text instead of always being a widthxlength?

4. Re: AutoEnter Multiplication Product Question
philmodjunk May 31, 2015 7:39 PM (in response to montshoman)Mixing text and numbers in a field when the numbers have to be treated as numbers is generally not a good idea. You may even want three fields, the third for cases where you enter just text.
But to use evaluate, you might use this expression:
Evaluate ( Substitute ( YourTable::YourTextField ; "x" ; "*" ) )
You enter this expression into YourTextField and a different field with the above expression will compute and display the area.
If you set this up as an autoenter calculation, be sure to clear the "do not replace existing value" check box.

5. Re: AutoEnter Multiplication Product Question
MorkAfur Jun 1, 2015 4:00 AM (in response to montshoman)Like Phil suggested I would use two fields.
I created a sample database called "deleteme" (so I remember to ... delete it).
I created two fields, field1 and field2.
Now, it doesn't matter what numbers are in them.
You can use Evaluate (Field1 * Field2) in a calculated field, or whatever. Evaluate figures out what's in the text and still is able to ... evaluate it. You may not need Evaluate all that often, but it's an incredibly powerful function. Other languages have similar capabilities.
See screenshot below showing the data viewer.
 m

6. Re: AutoEnter Multiplication Product Question
philmodjunk Jun 1, 2015 5:35 AM (in response to montshoman) 
7. Re: AutoEnter Multiplication Product Question
MorkAfur Jun 1, 2015 6:00 AM (in response to montshoman)Well, OK, I was generalizing from a single field's "3*5" expression itself which does require an Evaluate for FMP to figure out.
It's neat that FMP does a behindthescenes data conversion on two text fields.
 m

8. Re: AutoEnter Multiplication Product Question
montshoman Jun 1, 2015 4:51 PM (in response to montshoman)Thank you Thank you! Working without conflicts, that's so AWESOME!!