On Feb 21, 6:28 pm, Sasha <sashabal...@xxxxxxxxx> wrote:
Is there a way to have a field "self-evaluate", similar to a cell in
excel, so that the user is able to perform simple calculation in a
field?
Not quite like in excel, no, but pretty close.
There is an evaluate function, as others have said. And if you let
people type in one field, and have another set to evaluate(thatfield),
you can use the two fields in tandem to get close to what you want.
So... you could enter... (4+5)*10 and get 90 in the second field for
example, or enter sqrt(table::fieldnameX) to get the square root of
the value in the field "table::fieldnameX" displayed in the second
field.
You could reduce it to one field, where the field is set to auto-enter
the evaluation of itself, which would work, but you'd lose the
expression each time, which would probably be pretty annoying. Because
FM, unlike excel would -replace- the expression with the result.
RE: Cannot get code to work for API Save Dialog Box ... Then you could include it in your query and export it to Excel... to use the default value property of the new text box to do the calculation.... I checked the cells in the spreadsheet created and the cells are blank. ... cells where you expect the formula to calculate the totals.... (microsoft.public.access.forms)
Re: Disabling Autocalculation when opening CSV files ... For Each osht In ActiveWorkbook ... I am not very technical in Excel myself but I would like to add that: ... The calculation mode is always set to Manual (without recalculation ...Switch to Manual calculation and turn off Recalculate before save. ... (microsoft.public.excel.programming)
Re: WORD doc info into FMP? ...Bill, your solution has nothing to do with search and replace, or Excel but neither did option number 4 in my list, which was to import into a single record and then use position to populate other fields, as you suggested. ... I certainly acknowledged that you made his life easier by actually providing the necessary base calculation, but it was still the same method, and the method absolutely requires that all headings in all records have identical spelling. ... None of my suggestions required scripts, and I don't think the original poster actually meant scripts, but rather calculations, though that is simply a guess on my part. ... (comp.databases.filemaker)
Automatic Calculation Behavior Patterns ... we have Excel 2002. ... still allows me to type in a number in the next cell by stop calculation... Same type of setup, but the only difference, ... the Access Jet Engine while in DAO mode, and the alternative mode of ADO, it ... (microsoft.public.excel.setup)
Re: Error writing value to cell - continued ... You can't trick excel by having your function call a sub - that is correct. ... Possibly you could have a static array and store the values there. ... The Excel calculation engine doesn't go in and analyze what your function ... see why -- If the worksheet had 100 cells that called this function, ... (microsoft.public.excel.programming)
