millmaine

Got it. Thanks...as always.

That gives me the same result: if placed in a Sub Summary it shows only first value; If placed in Grand Summary it shows only last value. They appear on appropriate dates (as they did before) but I'm not getting all values.

My problem is defining "a repeating calculation field that puts the amount of tickets sold in the repetition corresponding to a certain date." As I said in first post: if placed in a sub Summary it shows only first value; If placed in Grand Summary it shows only last value.

Fair enough. Let's say we have an artist performing shows in 3 cities. On any given day there may be advertising activity for one or more of these shows.This activity may utilise a number of different media channels. We can display a summary of when this activity occurs by date and channel using repeating fields. Each day there are certain number ticket sales for each of the three events We can display a summary of when sales have occurred by date using repeating fields. What I'd like to do is show the total ticket sales each day. At the moment the closest I can get is show a list of each city's sales on a particular date. What I want is the total sales each day.

I have a layout summarising advertising activity and ticket sales for multiple events. I have tried a number of things. First, in order to show dates (over a defined date range) that activity and sales occur I use a calculation field called "zs_GanttChart_rt": Let ([Current_Date = Extend ( zv_StartDate_gd ) + Get (CalculationRepetitionNumber)]; Case ( IsEmpty ( Refiner_1A ) and Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_Start) +2; Extend (Z_colour); Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_End) +2; Extend (Z_colour) )) That works fine. Then I try to put sales figures in. First I simply used a repeating Summary Field with: List of zs_GanttChart_rt That works to a point. I get all the sales figures listed in the appropriate repeating field. However I don't actually want a list of each sale that occurs on a particular day. I want the total sales on that day. So I created a calculation field on the sales items: GetSummary (Sum_Quantity; Date_Start) Then tried this: Let ([Current_Date = Extend ( zv_StartDate_gd ) + Get (CalculationRepetitionNumber)]; Case ( Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_Start) +2; Extend (Summary_Sales); Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_End) +2; Extend (Summary_Sales) )) Now here's where it gets interesting. If placed within sub summary part, it returns the correct value for the first relevant repetition only (and no other values). If placed in a grand summary part, it returns the correct value for the last relevant repetition only (and no other values). I'm puzzled.

I have a similar problem. I have a layout summarising advertising activity and ticket sales for multiple events. I have tried a number of things. First in order to show dates (over a defined date range) that activity and sales occur I use a calculation file called "zs_GanttChart_rt": Let ([Current_Date = Extend ( zv_StartDate_gd ) + Get (CalculationRepetitionNumber)]; Case ( IsEmpty ( Refiner_1A ) and Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_Start) +2; Extend (Z_colour); Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_End) +2; Extend (Z_colour) )) That works fine. Then I try to put sales figures in. First I simply used a repeating Summary Field with: List of zs_GanttChart_rt That works to a point. I get all the sales figures listed in the appropriate repeating field. However I don't actually want a list of each sale that occurs on a particular day. I want the total sales on that day. So I created a calculation field on the sales items: GetSummary (Sum_Quantity;Date_Start) Then tried this: Let ([Current_Date = Extend ( zv_StartDate_gd ) + Get (CalculationRepetitionNumber)]; Case ( Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_Start) +2; Extend (Summary_Sales); Current_Date > Extend (Date_Start) and Current_Date < Extend (Date_End) +2; Extend (Summary_Sales) )) Now here's where it gets interesting. If placed within sub summary part, it returns the correct value for the first relevant repetition only (and no other values). If placed in a grand summary part, it returns the correct value for the last relevant repetition only (and no other values). I'm puzzled.

I have the same issue. Was this ever resolved?

Thanks, I was SURE I had tried that but I must have been mistaken because it works perfectly.

I have a table called MEDIA_SCHEDULE which displays related records from LINE_ITEMS via a portal. I have a script to create a new LINE_ITEM from the MEDIA_SCHEDULE. It takes the CATEGORY (Digital, Television, Press etc.) as a script parameter to set the category of the LINE_ITEM created. The LINE_ITEM is displayed in a new window. I would like the script to choose the layout of this window via calculation so that if the new LINE_ITEM::Category is digital it is displayed using the "LINE_ITEMS_Digital" layout. I know I could have a script trigger to change layout as soon as the category is set but I thought it would be more elegant to have it done within the New Window script step. I just can't figure out how to form the calculation.

We appear to have resolved the issue. I thought that perhaps records were not being committed properly and went through all scripts to ensure that where a "Commit Records/Requests" script step occurs that the options to "Skip data entry validation", "Perform without dialog" and "Override ESS locking conflicts" were all checked. Since then we have not lost any records. It probably comes down to less-than-perfect database construction and scripting in the first place but this at least seems to have worked for now.

Perfect. Thanks.

We have a table of Suppliers. We also have a table of Tasks. When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory. i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable. However there are some Suppliers that work across ALL territories. I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories. Ideas?

You're correct. The link to the OnTimer trigger seems to deal with exactly my issue. I'll download the sample file and explore that.

I have a script which opens a new (dialog) window for user to enter information. The script pauses while information is entered. I want to allow the user to cancel the script (i.e. leave User Abort on) but if they do, I want the record to revert and the window to close automatically. I tried: If [ Get (Script Result) = "Cancel"] Revert Record/Request [ ] Close Window [Current Window] Exit Script [ ] but that doesn't seem to work. Any thoughts?

Thanks for these thoughts. Privileges was one of the first things we looked at but will review again. Yes we do have UUIDs, so we're confident that data is not being overwritten — the records are actually no longer there. However we don't have ALL of the other fields suggested. We'll implement those. The daily check method sounds like a great way to try to identify the circumstances.