# Using a Rept field to sum a portal list of items!

## Recommended Posts

Guys, another one for you - I hope you're in the mood?

RE: The same O' same O' - Appointment scheduler

Let's say I have four operating theatres.

I have easily set up Four portals that do a relationship based upon a combined field of - Appt Date & " Room " & Room Number. Perfect

Now, it give's me a list of all the appointments - which is what I want

BUT...

I would like it to be listed down the page on the corresponding line of what time the appointment is!

So, I was thinking, because each of the items in the list of appointments is a seperate record - I want to be able to combine each of the appointment times into a SUM of portal records and display it in a Repetition field that has 24 intervals (each 30 min slot)

I have a global TIMES field which is 24 repetitions which I have given data to (ie: 8:00, 8:30, 9:00, 9:30, 10:00, 10:30, 11:00, etc.)

Is there a calculation that will look at each Appointment time in the portal and plot it into the corresponding repetion field?

I've tried....

if(TIMES - Extend(:Room1 = 0, Extend(:Room1:Doctor Name), "")

This works for only ONE entry of the portal (The first Portal Record)

How do I get it look at all Portal Records and use it in the same calculation?

There's got to be a way right?

I've successfully done this in ONE record to plot the appointment time and duration into a graphical repeating field that looks like this...

If(TIMES - Extend(Appointment Time) = 0 or TIMES - Extend(one hour from app) = 0 or TIMES - Extend(one half hour from app) = 0 or TIMES - Extend(two hour from app) = 0,Extend(SCHEDULER), "")

SCHEDULER is a container field that looks up what colour to use depending on whether it's a BOOKING, WAITING, WITH DOCTOR or DOCTOR DAY OFF.

It's SUMMING a list of times in a portal and getting it to display it in the relevant box so that it no longer looks like a list but looks like it can be displayed in blocks of time.

Please help - I know I'm a pain but, I'm sure it's such a simple thing and if not, should be..

Cheers once again

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Who Viewed the Topic

×
×
• Create New...