AnsweredAssumed Answered

Calculation Field Issues

Question asked by KatieMatteson on Jun 27, 2014
Latest reply on Jun 30, 2014 by disabled_ntaylor

Summary

Calculation Field Issues

Product

FileMaker Pro

Version

13

Operating system version

MAC OSX

Description of the issue

Need help filling in a field but only if it meets the following criteria:

Blank (about 70% of imported records will not have this field populated, but I don't want to overwrite the 30% that are populated)

Information should come from the matching table, set up like this:

Table 1                                   Table 2
Subdivision (70% blank)           Subdivision (this is the field I would like transferred over)
Zip Code                                 Zip Code
Street name                            Street Name

SO, I would like to fill in the blank subdivisions with the correct subdivision, matching by zip code and street name. I think a calculated field is the best way to go about doing this, but so far my attempts come up short.

Outcomes