Evergreenh

Works like a dream! Thank you so much for answering this for me. Very appreciated! Kelly XXX

Hi there Having a little problem and wondering if someone can help me. Im on FM10 BTW. I have an event database with fields EventName and DateOfEvent. I've set a Script Trigger so that whenever anyone does a find on an EventName the events found are put in date order. But it would be really useful if it automatically went to the next event after todays date (they happen once a month, so usually within a 31 day period). I have a TodaysDate field as well. Can anyone help me with this? I would really appreciate some assistance. Sorry I just realised I called this topic 'Go to next record...' but it should say 'Go to record...'

Oh you are lovely!!! Thats worked straight away. I wish I had aksed this question 2 years ago!!! Thanks for that Kelly X

I have a little problem with date formatting. I’m in the UK, and all over our database the dates format perfectly in UK format, except for in one area. That is if I use a date field in the middle of text in the body of an email that is created from the Send Email script step. So the date 31st December 2011 which appears everywhere as 31/12/11 looks like this in the email: “whatever text is to the left 12/31/11 whatever text is to the right” So this means that we are sending emails out with the following explanation: “whatever text is to the left 12/31/11 (date may appear in US format) whatever text is to the right”. This wouldn’t be such a big problem if we weren’t an events led company running over 80 events every month. Could anyone help me with this? Thanks in advance Kelly

All of a sudden I’m having a few problems managing scripts in the Scriptmanager I’ve got a bunch of scripts that are not in any folders, and until recently it let me change the order that they were viewed in the Scriptmanager Screen. Now suddenly it won’t let me change the order freely. It’s not displaying them in creation date order. It’s not displaying them in alpha order. I can’t see a logic to how it is displaying them, but there is a logic there. I know this because it will let me move some of the older scripts, but only within a limited area of the list. But the parameters of the area I can move them around in makes no sense to me. What I do know is when this seems to have happened and what I was doing at the time: I had a bunch of scripts with the beginning of each one named 'MEETREP10_'. I duplicated about 20 of them in one go. So it created a duplicate with the word ‘copy’ on the end of each one, each copy underneath the original. What I did then is made changes to the new duplicated scripts and renamed them 'MEETREP11_'. Now this is where it starts to go wrong. Usually I would change the order of them (didn’t know about folders properly at that point), so that they would be like this: MEETREP10_scriptname1 MEETREP10_scriptname2 MEETREP10_scriptname3 MEETREP11_scriptname1 MEETREP11_scriptname2 MEETREP11_scriptname3 But it immediately wouldn’t let me change the order and since then it has been misbehaving. Since then I have created 3 new scripts. These scripts are at the very bottom of the list in creation date order and I cant move them. Now when I make a new script it puts it either at the bottom of the whole list under the 3 new scripts, or 3 scripts up from the bottom immediately under the last ‘MEETREP11_’ script that I created from a MEETREP10_copy and again I cant move it from wherever it puts it. There seems to be no logic as to whether it’s going to put it at the bottom of the whole list, or at the bottom of the last MEETREP10- copy. I can create new folders and again they either go at the very end of under the last MEETREP10- copy. But I also now can’t put any scripts at all into the new. I can however move the older scripts into older folders. I’ve run the database on version 11 and 9 Advanced and its doing it on both, but I know its a bug in the specific DB. I know this because if I make a copy of the DB and delete all of the scripts and then import them all from the original DB everything works fine. Now I dont really want to do this because there are nearly 1000 scripts and all of the buttons would need to be reassigned!!! Any ideas anyone? This is driving me mad as I just cant make sense of it.

Oh thank you very much for your reply. I will give that a go and see how it works out Kelly X

I might be being a bit dumb asking this question but I’m totally stumped and would appreciate some help. I have a table which is made up of event records. Then I have a report layout which shows a lot of numerical information about these events, with a summary for each field. Let me show you a simple example Event 1 (field 1 = 10) Event 2 (field 1 = 9) Event 3 (field 1 = 20,) Trailing summary - (Summary of field 1 = 39) So for example I have 45 events each month. Each event record has a field that gives me ‘Total Attendees’ for that specific event and another for date of the event. So the layout above would list the events in any selected month, and I have a summary field that shows the ‘Total Attendees’ for all events added up within that month within the trailing summary. But what I want to do is to create a report that shows the summary fields so that I can compare the ‘Total Attendees’ each month. So something like this: For all events within Jan (Summary of field 1 = 39) For all events within Feb (Summary of field 1 = 47) Hope Im making sense. It occurred to me that what I want is another field that does something like the following: Show a summary of ‘Summary of field 1’ when the month of event = xxx But of course since the field ‘Summary of field 1’ is dependent on a set of found records that I don’t actually want to find and show.. that is impossible. I want to be able to display the summary fields at the bottom the report for January, and show them on a report next to the same information for February, March etc Can someone help out?