Solved

Update a field for all records in a table

Posted on 2014-10-08
2
146 Views
Last Modified: 2014-10-09
I have File Maker Pro 8.5.
I have a table called Clients.
There is a field called Warning - this is a radio button and another field called Twomonthsdue.
For all records in the table I want to do the following:
  - Set Warning to 1
  - If Twomonthsdue>0 then set warning to 4

This is a one off requirement. I only need to do this once in order to tidy up some incorrect data in the database.

This would be easy for me if it was dbase but I'm very green when it comes to File Maker so clear instructions would be appreciated.
0
Comment
Question by:akb
[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
2 Comments
 
LVL 4

Accepted Solution

by:
historychef earned 500 total points
ID: 40370192
You can do a "Replace Field Contents" on that field (it's on the Records menu). Start by showing all records in the table. Select in the Warning field, then select "Replace Field Contents", then select "Replace with calculated result" with the following calculation:

If ( Twomonthsdue > 0; 4; 1 )

It will all be done in a few seconds.
0
 
LVL 13

Author Comment

by:akb
ID: 40370279
Thanks historychef. You are a legend!
I had spotted that option in the menus but it was greyed out. Soon worked out that I needed to have the field selected, then it all worked like a dream.
Then I read your reply again and realised that you told me "Select in the Warning field" - DOH!
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

628 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