?
Solved

How do a update the results of a calculated field all records in a table?

Posted on 2010-08-15
10
Medium Priority
?
408 Views
Last Modified: 2012-05-10
I have a calculated field that has been revised and I would like each record re-evaluated to update the calculated field. How can this be done without opening and saving each record?

Resources said to check "Do not store the calculated results", but I that option is not available on the storage tab. Any other suggestions would be greatly appreciated.
0
Comment
Question by:nisupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 9

Expert Comment

by:jvaldes
ID: 33443479
If you put the field on the layout it will refresh and calculate. If you dont want to see it, make the text the same color as the background.
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33444477
nisupport

If you have a calculation that does NOT have "Do Not Store" checked
When you change he calculation formula in the field definition, you will note there when you close that when you close the database manger you might have a delay.

This delay is Filemaker doing the recalculation on ALL the records.

Hope that helps!

Tom


0
 
LVL 28

Expert Comment

by:lesouef
ID: 33458497
Are you sure you're not confusing a calc field with a field auto-entered from a calculation?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:nisupport
ID: 33495879
I guess I am confused regarding direction. If I add the calculated field (it is full name pulling from first and last name) to the layout, will it update all records?

Also, I do not see an option to check "Do not store".

Any guidance is appreciated.
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33495904
Nisupport

If you create a field called
FullName
With calculation
First Name  &  " "  &  Last Name

That calculation will automatically be done to all records
No extra steps are needed

Hope That helps!
Tom Droz
Droz-Consulting.com
0
 

Author Comment

by:nisupport
ID: 33496009
The calculated field is only updated when the record is saved.
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 33496302
Nisupport

1) Click on "storage Options" what is checked there?
2) Is the field type "calculation" if not, what is it?

thanks
Tom
0
 

Author Comment

by:nisupport
ID: 33496754
ThomDroz,

The storage options tab has fields to enter number of repetitions, indexing and to use global storage.

On the Auto-Enter tab, calculated value is selected.
0
 
LVL 6

Accepted Solution

by:
ThomDroz earned 2000 total points
ID: 33496786
There is the issue, yu are doing this as an auto entry, rather than as its own field

I would suggest that you create a new field called combo name using the formula I previously provided
type of field is a calculatuon

let me know if there is a reason that will not work for you

thanks


0
 

Author Comment

by:nisupport
ID: 33496844
Thank you for your patience. I now see the issue, made the change and now it works
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question