Gday all. I am creating a report and need so...

(Tim Watts) #1

Gday all.

I am creating a report and need some help.

I am setting this up to run for several locations. Eg. Location A, B, C etc.

I need a separate report sent for each location.

I know I can do a report for each row but this wont work as I need several rows to go on each report.

It is important that each location has its own report.

How do I do this?

(Aleksi Alkio) #2

Do you mean this… you want to use one workflow rule and if the data belongs to location A, it should send it only to location A?

(Tim Watts) #3

Hi Aleksi. Yeah that would be perfect

(Tim Watts) #4

It does and it is

(Aleksi Alkio) #5

When it’s a ref field and you have added email column to your locations table, you can read the correct email address with the deref expression as well… like [Location].[Email].

(Tim Watts) #6

I think I am still a little confused and I will do my best to explain my confusion.

Table A contains all of the reports from all of the different locations. Table B is a table that contains the locations and will shortly contain the email for each location.

I need to send a report that will go through table A. Filter the reports in Table A so that Club A will get a report with only Club As reports. Club B will get a report with only club Bs information.

The bit I am having trouble understanding is when I create the report how to I have Table A filtered based on who the report is being sent to. E.g if Club B is getting sent a report how does Table A filter and only send Club B’s information.

(Aleksi Alkio) #7

When you say… “create a report”, are you sending only one record or multi records?

(Tim Watts) #8

Multiple records. One for each location. But only want to send each location a report with their information

(Aleksi Alkio) #9

You could use SWITCH expression for this purpose…

SWITCH([Location], “A”,“emailA@mail.coom”, “B”,"", “C”,"", "")

(Tim Watts) #10

Anyway to do it without so it just checks for all if the different emails that are recorded? Just thinking the amount of locations is large and will continue to grow. Would like to not have to change it again in the future

(Aleksi Alkio) #11

IF you have a table where you can read the email, you could do it like LOOKUP([_THISROW].[Location],Locations,Location,Email)

(Tim Watts) #12

Ok I’ll try that and see how I go.

(Tim Watts) #13

Hi Aleksi, how do i ensure that the information that is being sent is relevant to each location

(Aleksi Alkio) #14

Do you have a table for locations? If yes, does it contain email address for every location?

(Tim Watts) #15

I do. It doesn’t store the emails but I can change that pretty easily.

(Aleksi Alkio) #16

And does your record contain a location? Is it a ref field in that table?