Post

2 followers Follow
0
Avatar

Countering referenced items

BACKGROUND INFORMATION

I have a consultancy business where my hourly rates are calculated on basis of the time I have been given to solve a case. The time given is determined in two ways:

(1) Manually by entering in a locked date interval in a [Date Interval Registration] app

(2) Automatically by calculating the date interval based on the first and last time registry entered into a [Time Registration] app

The two apps both contain a forward reference field referencing a [Case] app. That means that a time registry is only indirectly connected to any date intervals via the shared case item.

MY CHALLENGE

I am building a (advanced?) system to handle number 2 above. You can see a visualization of the entire system in the picture found at the following link: https://virkerumaps.box.com/s/o6u3bgmho24vmt6p6jjsasrjh3v4ussh

Right now I am focusing on solving TEST 1. I want to use javascript to check if the shared case item is referenced by any items in the [Date Interval Registration] app. If the result is zero the test should produce a: No. Otherwise it should produce a: Yes.

Is it possible to do the above?

(PS. You are more than welcome to comment on the other tests if you any good ideas)

David

Please sign in to leave a comment.