Trying to use only areas for the Job I'm on

numberz

Hi,
I know this may seem entry level but...

IF JobSystem WAS CHANGED OR JobSystem IS NEW
THEN FIND JobArea WHERE JobArea.ob_Jobs = JobSystem.ob_Job

This rule does nothing to prevent all of the Job Areas that I have in all of my jobs, to be displayed. Of course, I only want the Job Areas from the Job that I'm working on, to be displayed.

I tried Chatgpt and it gave me:

IF JobSystem IS NEW OR JobSystem WAS CHANGED
THEN FIND JobArea WHERE JobArea.ob_Jobs = JobSystem.ob_Job AND JobArea.Status = 'Active'

But that did nothing either.

kklosson

We could use a bit more detail as to how these objects are related. Also, you are using the FIND action, and you say the items are being displayed somewhere. It would be key to know where/how. You must be sure the JobSystem object is in context. Perhaps describe the function more completely.

numberz

Hi kklosson,

I just realized that besides the Update Rule doing nothing, that I had entered some criteria in the ps_JobAreas dropdown for my Entry form but not in the Edit form. I added it and it seems fine. Now I only see each Job's Areas. Tell me if you think otherwise please.

kklosson

I concur with my limited understanding. Also, you probably don't need the This prefix so long as JobSystem.ob_Job is always in context and not overwritten by any other instance of the object.