[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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

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
nisupport
Asked:
nisupport
1 Solution
 
jvaldesCommented:
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
 
ThomDrozCommented:
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
 
lesouefCommented:
Are you sure you're not confusing a calc field with a field auto-entered from a calculation?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
nisupportAuthor Commented:
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
 
ThomDrozCommented:
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
 
nisupportAuthor Commented:
The calculated field is only updated when the record is saved.
0
 
ThomDrozCommented:
Nisupport

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

thanks
Tom
0
 
nisupportAuthor Commented:
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
 
ThomDrozCommented:
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
 
nisupportAuthor Commented:
Thank you for your patience. I now see the issue, made the change and now it works
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now