Alpha DevCon 2018
Results 1 to 17 of 17

Thread: Alphasports-fire district db

  1. #1
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Alphasports-fire district db

    While looking and trying to adapt Alphasports for a database, I noticed that when you go to the invoice page and press print this invoice, it is stuck on the same invoice. Also, while changing customers, the embedded browse doesn't change. I am trying to create a database for a fire department(and first responders) where they can keep track of fireman calls so that they can pay the small fee they get for calls. (volunteer). I am modeling the db after alphasports which has customer (firemen) invoices with embedded browse (keep current track of their calls), each fire call (events) and all the reports as such. There are three separate fire stations and the district. I need reports separate for each and one for the district. I get very close to completing this and then the db doesn't work when I add new fireman, events,... It has been a few years since I worked with alpha and volunteered to do this for the firemen. I know this is a long explanation but I am asking for both advice and patience. This should not be difficult but I have been working on this for a few months.

    Thanks,

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,012

    Default Re: Alphasports-fire district db

    I noticed that when you go to the invoice page and press print this invoice, it is stuck on the same invoice.
    Are you speaking of your modified database or the original AlphaSports? Easiest way to get help is to attach your database here, if that's the problem child, and include instructions how to replicate the problems.

    Your issue above seems to be that you have changed something that makes the filter for the invoice report not find the proper record(s).
    There can be only one.

  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Check the invoice report to see what filter is saved there.

    Sometimes when you click on an report (invoice in this case) button to print a report and then put the report in design mode, the filter sticks to the report - and you don't want it to.

    Just change the filter to blank and the filter from the button will work again.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  4. #4
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Re: Alphasports-fire district db

    Attached is the db that I have been working on. Some things may be redundant--been trying all kinds of things.
    Thanks for the advice.
    Ted
    Attached Files Attached Files

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,012

    Default Re: Alphasports-fire district db

    Your print/preview button refers to date ranges that don't exist.

    Delete or comment out the whole code and add this.

    Code:
    if option = 1 then 'print today's invoices
    	filter = "inlist2(fireman_id,[var->invoice_numbers])"
    else if option = 2 then 'range of dates
    	filter = "between(fireman_id,[varD->begin_inv],[varD->end_inv])"
    end if
    
    
    'substitute the parameters in the filter expression
    filter = replace_parameters(filter,local_variables())
    
    
    
    if print_option = "preview" then 
    	report.preview("Invoice",filter)
    else
    	report.print("invoice",filter)
    end if
    Fire Department.zip
    Last edited by Stan Mathews; 08-17-2016 at 02:41 PM.
    There can be only one.

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,012

    Default Re: Alphasports-fire district db

    New version.

    Fire Department.zip
    There can be only one.

  7. #7
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Quote Originally Posted by tedsoileau View Post
    Attached is the db that I have been working on. Some things may be redundant--been trying all kinds of things.
    Thanks for the advice.
    Ted
    Ted you changed the radio object for what the choices are, but changed nothing in the button onPush event.

    They need to be coordinated.

    I'd make a change to what Stan submitted...

    Code:
    if option = 1 then 'print today's invoices
    	filter = "inlist2(fireman_id,[var->invoice_numbers])"
    else if option = 2 then 'range of firemen
    	filter = "between(fireman_id,[var->begin_inv],[var->end_inv])"
    end if
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  8. #8
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Ted

    What build of Alpha are you running?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  9. #9
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Ted

    Noting that you sent me a private message that this is now working after downloading from somewhere again.

    Glad to hear it's working.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  10. #10
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Quote Originally Posted by Al Buchholz View Post
    Ted

    Noting that you sent me a private message that this is now working after downloading from somewhere again.

    Glad to hear it's working.
    Now I'm getting a mixed messages that this is not working.

    Please post instructions here..

    Please be more clear about your instructions.

    Give the exact name of the buttons to press to reproduce that issue.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  11. #11
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Re: Alphasports-fire district db

    Choose Mamou Fire Department
    Firemen events
    Go to Firemen 05 Ray Manuel---you will see an event M1
    Press "print this report"
    preview---blank report
    If you choose another firemen and then press New, pick an event, then Print this report--doesn't do it.

    How can I automatically make the invoice_number the firemen_id? I played with the field rules but can't seem to figure it out.

  12. #12
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Quote Originally Posted by tedsoileau View Post

    How can I automatically make the invoice_number the firemen_id? I played with the field rules but can't seem to figure it out.
    Why would you make the invoice number the fireman_id?

    Once the invoice is paid then the fireman should start a new invoice.

    Going down the wrong path is causing too many problems for you.

    Treat the fireman as a customer and use the fireman_id like a customer id. Use the invoice_id to group an invoice together.

    Your invoive_id problem with the line items is because you changed the field rule for invoice_items->invoice_id to default to blank.
    Last edited by Al Buchholz; 08-17-2016 at 06:34 PM.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  13. #13
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Re: Alphasports-fire district db

    Al,
    My purpose is to have a database where the fire department can keep track of each fireman's calls. I want to have a running list of events that can be tied to each fireman that attend the call (event--ie house fire, rescue, etc). By using the concept of an invoice where an item(event or call) could be added to the ongoing invoice, then at any time, the running total of what each fireman has earned could be checked and printed. I may be making this more complicated then I should. In the database I am working on: Events are like products--can be added to an ongoing invoice for each fireman(customers). Sure hope I made this clear.
    Thanks

  14. #14
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Quote Originally Posted by tedsoileau View Post
    Al,
    My purpose is to have a database where the fire department can keep track of each fireman's calls. I want to have a running list of events that can be tied to each fireman that attend the call (event--ie house fire, rescue, etc). By using the concept of an invoice where an item(event or call) could be added to the ongoing invoice, then at any time, the running total of what each fireman has earned could be checked and printed. I may be making this more complicated then I should. In the database I am working on: Events are like products--can be added to an ongoing invoice for each fireman(customers). Sure hope I made this clear.
    Thanks
    For the $220 onetime payment, you should consider QuickBooks Pro.
    https://quickbooks.intuit.com/pro/
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  15. #15
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,894

    Default Re: Alphasports-fire district db

    For free you can get
    Manager https://www.manager.io/ for one user and much stronger than QB. Multiuser is a bit more
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  16. #16
    Member
    Real Name
    Ted Soileau
    Join Date
    Apr 2016
    Posts
    17

    Default Re: Alphasports-fire district db

    Thanks as always for all your help and advice.

  17. #17
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,481

    Default Re: Alphasports-fire district db

    Quote Originally Posted by tedsoileau View Post
    Thanks as always for all your help and advice.
    So how did you resolve the issues?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. else doesn't fire
    By madtowng in forum Application Server Version 11 - Web/Browser Applications
    Replies: 14
    Last Post: 09-25-2012, 10:42 PM
  2. Pre-Fill Order fields with Region, District, etc from Users table
    By Tony Evans in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 09-01-2011, 06:23 PM
  3. When do events really fire????
    By enstorms in forum Alpha Five Version 8
    Replies: 20
    Last Post: 04-16-2008, 04:20 PM
  4. Field events do not fire
    By Mike Reed in forum Alpha Five Version 7
    Replies: 2
    Last Post: 10-19-2005, 03:27 PM
  5. autoexec won't fire
    By WillieLucas in forum Alpha Five Version 4
    Replies: 1
    Last Post: 05-25-2001, 11:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •