Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

About jeffs88keys

  • Rank
    Advanced Member

Recent Profile Visitors

975 profile views
  1. So, I've come up with a wish list for my existing app. Unfortunately, it will require a basic re-write of about 1/2 the datasheets. I'm wondering what would be the best way to do this, while still allowing my existing apps to continue working. What I don't want to do is create new datasheets for testing purposes, and then come back to the original ones and modify them. I'd rather create new ones and then replace the old with the new. But I need to make sure the data is in place. Just looking for any thoughts from someone who has done this before.
  2. 2 tables: Sales_person and Sales_Entry. Sales_Entry is authenticated by the email address of the sales_person. I would like to create a 2nd user (the sales person's assistant) to be able to have their own login, yet have record level authenticated access to the sale's person's data. (The purpose for this is to eventually provide the assistant with filtered data not including all the information that the sales person sees). Is there a way to create an authentication that accesses information that is already authenticated to another user? (If that terminology makes sense)
  3. I"m using Compliance version, and it seems the "Details" feature in DataPage Reports does not work correctly. Once the details are loaded, I attempt to click on any field and I'm taken to the URL shown below. Anyone else experiencing this? Thanks !!
  4. Thank you, however, I'm trying to run a report that basically has 2 forms of criteria. This year to date AND last year to date. I fully understand how to do one of them (your link), but not to produce the report with both sets of criteria. Thanks
  5. I have a table called "Sales" which has fields Salesperson, Date_of_Sale, and Sales_Amount For any given Salesperson, I would like this report to show the sales for the current year-to-date AND the prior year-to-date. I'm completely comfortable with creating it if it were only for this year, but how do I get the field in place to reflect the prior year-to-date as well as make a subtraction between the 2 fields? At a loss, and I appreciate the help.
  6. Hi, @Vitalikssssss Thanks for the reply. I'm not sure this is what I'm looking for. I'm actually looking for the ability to enter multiple items in the original Form (sales order form), not in a Report. (Assume I don't have any records yet, and I want to add more based on someone keying in their sales order).
  7. I would like to create a simple online ordering form where users can order multiple items. Table is Order in relation to Items table. Customer enters order on Order_Form (I know how to set all this up), but if they want to order 5 different items, they can do so on one form, not one at a time with individual submissions. What am I missing that I can easily do this? Looked through video tutorials and help...couldn't find. Customer: Item Quantity Extended Item Quantity Extended Item Quantity Extended Item Quantity Extended Item Quantity
  8. In my datapage, I'd like the user to be able to modify all fields if field "commissions_paid" is not filled by our admin team. However, if the field is not blank, I would like to lock about 5 fields on that record from modification. I know I can use rules, but I need the "commissions_paid" field to be a View Only field (the user can not have access to this field), thus limiting the ability to use the rules feature. Any thoughts on how I can do this? I'd be willing to accept the option of locking the entire record if the above condition exists. TIA
  9. What are the requirements and  your budget?

    1. jeffs88keys


      I have an app where our travel agents report their gross commission paid by the supplier.   A date range table determines the % of commission they earn.  However, we have several other factors that determine their % including whether it's their own purchase, whether the lead was given to them, etc.  Each of these variables is stored in a table.

      So, I need to be able to show the proper % of commission that they've earned as a calculation based on these variables.

      I know that's not detailed, but is a sense of what we are looking for.  

      The foundation is in place, but I just need help putting these calculations in.

      As to budget, I don't really have one.  i guess I'm looking for someone to scope out what we need and let me know what it will take to get done.



  10. So I have a pretty complex app, but I'm really stuck on one element that will require some JS coding. I honestly don't have the time or the inclination to do it myself. Anyone interested in helping me out for $$? HMU.
  11. "Quote_table" holds data submitted by prospective customers. Includes name, address, phone, email, but also other information important to developing a quote. When the prospect becomes a client, I would like to run a routine that automatically copies the name, address, phone, and email fields of the Quote_table to similarly named fields in "client_table" (the table in place for existing clients). This would be done with a click of a button. I searched but couldn't find any other forum topic on this. Can anyone offer some guidance?
  • Create New...