Skip to main content
Question

Report Question: Pass a Start and End Date in a form to filter the associated embedded reports

  • April 16, 2018
  • 0 replies
  • 21 views
So lets say i developed a form for invoicing clients and i have already developed a report that shows all of their orders. 

Lets say in that form, I can enter in a start date and end date for the invoice which upon saving, would refresh a report below the provided field values. Is that possible?
GMacri

    If your ultimate goal is to define a set of dates and then attach the orders to a Parent invoice, I can help you make a button to do that - ie to mass update those orders to populate the field [Related Invoice].   Then you can roll up your total invoice using summary fields.

    Contact me via the information on my website.  I do this all the time for clients, but the process is a bit too complicated to explain on this forum.

     QuickBaseCoach.com
    • GiuseppeMacri
    • Author
    • Registered
    • April 17, 2018
    does it involve the use of a code page, which then uses repeatOn and some api calls?
    GMacri
    No my method involved making a formula URL button which either edits or adds a userid to a table of users where the Key field is the userid field, and recording the Record ID# of the invoice and the  Record ID# of the Customer. 

    Then formula URL button runs a saved table to table import and mass updates the orders for the customer to fill on the field for [Related Invoice] on any orders which have not yet been assigned to an invoice.
    • GiuseppeMacri
    • Author
    • Registered
    • April 17, 2018
    Hmm i can see why you said this would be pretty complex. Wish me luck haha
    GMacri
    It would take an hour of consulting time to get this working with you on a GoToMeeting and then you could possibly use the same technique in other apps or other places in this app.
    Terms & ConditionsAccessibility statement