Solved

Update a field for all records in a table

Posted on 2014-10-08
2
126 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FM - First click of PDF icon in a portal row centers the screen, then 2nd click works 6 290
audit trail 6 187
Filemaker Output 6 216
Filemaker Server as a Web Portal - Licensing 3 163
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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 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