Booked Gigs Report
active
Total logged
8h 30m
Uninvoiced
0h 0m
Entries
5
Invoices
0
Time by team member
| Team member | Entries | Hours |
|---|---|---|
| Caleb Harvey | 5 | 8h 30m |
Recent time entries
Last 5
| Date | Description | Who | Duration | Status |
|---|---|---|---|---|
| 19 Oct 2023 | Extra Development on Teams - Replacing the times column with a fee column - Adding the fee totals under each group and a grand total at the bottom - adding the time column back in - adding a new field to the search table called showFee - Adding a new checkbox into the top filters to show/hide the fee from the report | Caleb Harvey | 0h 30m | invoiced |
| 18 Oct 2023 | Adding socials to the current 'All Gigs' List - Go to the layout for all gigs - move all columns over to the left and increase the height of the body to make room for a new column - look at the act table to find the names of each of these fields - add 3 lines into the one column with the Act::Facebook, Act::MySpace and Contact:WWW fields preceded by the abbreviations for facebook (FB), instagram (IG) and website (Web) - Change the name of the myspace title in the act screen to Instagram - Run the report and adjust sizing to fit correctly | Caleb Harvey | 0h 45m | invoiced |
| 18 Oct 2023 | Main Searching Functionality - Create a script trigger on the search date global field and link it to a new script - In the script set the field to display "..." after the first date has been input - Set the selection back into the field after these 3 dots to add the "to" date - Input the second date and commit the field - Add a new parameter to the gigs report script to handle the FileMaker find - If all of the search fields are blank show all records - Enter find mode - Create an embedded looping system that contains 4 loops to represent the 4 search fields that can contain multiple values - At the start of each loop set a variable to itself plus 1 and set the variable for its net loop to 0 - In the inside loop, Set the date using the search date field and this same search applies to all find records - Set the event type, status, date and act category with a value from the multi listed search fields using their respective loop variables - exit each loop after the loop variable is higher than its value count of the search lists - If there are more values in the list still, add a new find request and loop through again - after the embedded loop has finished adding records, perform the find - if there is an error message or the find results find 0 records, show a custom dialogue stating there are no matches with the search - After the find has run, run the sort step that changes the sort based on whether act or venue is selected - Test all types of searches to ensure successful results Adding Button to get to Report - As the method is different in this report, add new menu item to the menu list named "Booked Gigs" - Set the button to perform a new script that runs the report gigs script with a new parameter - Add that new parameter to the report gigs script and in it go to the new layout, run the hide tools script and omit all records in the found list to start a fresh search | Caleb Harvey | 3h 45m | invoiced |
| 17 Oct 2023 | Script Steps - Create a new script in the event database - Add a parameter to the script to clear the field set by name sent through the script param and commit records - Add a calculation on the Multi Select fields in the new table to equal itself and a new line of the data enter in the search field - Create a script trigger on the search fields that clears the field as soon as the data is modified - This field will store in the multi field and leave itself blank - Add a button with an "X" on each search field to clear their respective multi fields - Add a value list into the system to sort either by venue or act and apply this to the sort global field - create another script parameter that updates the sort to either venue or act depending on which of these two is selected - Show/Hide the applicable act/venue fields depending on this sort | Caleb Harvey | 1h 15m | invoiced |
| 17 Oct 2023 | Make the Report Layout - Duplicate the 'All Gigs' Layout to have a starting point - Change the view to list so it lists all the records down the page - Add a sub-summary before and after the body for sorting on the Venue Name - In this summary display the venue name and follow the listed body with a total number of gigs for that venue - Add a sub-summary before and after the body for sorting on the Act Name - Display the act name above and after have the total number of gigs for the act - Within all of this keep the sub-summary for the sorting on the month - Add the headings Date, Venue, Act, Agent and Time - Show the day and date for the gig in the body, the venue name and act name overlapped, the agent name and the performance start and finish times with a "-" between them -Add an Export and a find button in the top navigation Add Search Table - Add a new table called EventSearch and fill it with all global search fields - The fields are, Date, Sort, Type, Status, Agent, Category and Status - Add fields attached to these fields to view the listed items of the search if searching for multiple - Pull these global fields into a top navigation in the layout | Caleb Harvey | 2h 15m | invoiced |
Stages
- General Support
Edit