Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by jeffs88keys

  1. I can see this making sense. I'll definitely give it a shot. Thank you !!!
  2. I have a table (Sales) where my employees enter their sales. Occasionally they need to modify the information in the entry (deliver date, cost, etc). I already have a Triggered Action that saves the original entry to a separate table (Sales_History) to maintain record of the original entry. What I'm trying to achieve is this.....how can I see what the exact change was in the entry.....meaning...which field was changed? Is there a method to compare the record that is in the main table (Sales) to the one that was moved to the Sales History table? Example: Salesperson changes the cost of the item, but all other fields remain the same. How can I auto determine that it was the price field that changed? Thanks !!
  3. Very grateful for your time. I will give this a shot. Thank you !!!
  4. Hello, I understand that this may be an html box on my report. I need to accomplish the following, and I'm not sure if can be done. If [field1] is blank or if [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS OUT OF COMPLIANCE" (and maybe in red???) (otherwise) if [field1] is blank or [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS IN COMPLIANCE" (and maybe in blue???) Thanks !!!
  5. @CoopperBackpack I think we may be off. This is not a details datapage...this is a tabular report. I completely used the wrong terminology and I'm so sorry. Seeing the screenshot below, the elements that you see beginning with Vacation_Entry are the details shown in the example above. The two elements beginning with Trips_V2 are the 2 fields that are being tested to create either of the 2 return phrases that I'm looking for. I hope that clarifies easier. I'm sorry if I wasted your time with the previous snafu in terminology.
  6. Hi @CoopperBackpack, Sorry for the delay..... my notification didn't go off. So I have this on a Details Report, and is based on a 2 table view. Table 1 lists the "trips", and Table 2 lists the components of the trip. The Details report shows the details of the Table 2 trip, but I am looking for the query above to be based on the Table 1 "trips". So if [trips:field 1] (text field) is blank OR if [trips:field 2] (file upload) is empty, then it creates the statement above in Red. Otherwise, a different statement is made (see OP above). I've attached a sample of what the display would look like.
  7. Thanks, but Rules don't apply for what I'm looking for. Thanks.
  8. Hello, I understand that this may be an html box on my report. I need to accomplish the following, and I'm not sure if can be done. If [field1] is blank or if [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS OUT OF COMPLIANCE" (and maybe in red???) (otherwise) if [field1] is blank or [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS IN COMPLIANCE" (and maybe in blue???) Thanks !!!
  9. This worked perfectly. Thank you so much for your time to help me.
  10. Thank you so much for this. I'll give it a shot.
  11. Hey guys....real rookie here, so any help appreciated. I have a details report set up that is derived by using a passthrough external parameter. From the details report, I would like to have a button to "Add a New Record" which will include the same passthrough parameter variable into a form. How do I create the button (separate html code on my web page?) and how do I setup the passthrough parameter on the button? Thanks !
  12. 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.
  13. 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) Thanks !
  14. 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 !!
  15. 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
  16. 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.
  17. 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).
  18. 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 Extended Order Total:
  19. 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
  20. 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.
  21. Hi. I'm trying to deploy 3 different datapages on one website (as a dashboard of info). All 3 datapages have criteria that is preselected, so there is no criteria submitted by the user. However, when I refresh the web page that has the 3 datapages, they seem to be interfering with each other, as if they are looking for exterior data (user?) and it just goes into a loop - as if continually looking for input. Any thoughts on how I can launch these 3 subsequently?
  22. I'm beyond embarrassed at my question now that I see how easy the answer is. I was SOOOO trying to make it more difficult than it actually was. Thank you so much for your help !!! -Jeff
  23. It appears this is happening when I embed more than one app on the same webpage. I'm attepting to have up to 6 Caspio apps running as a performance "dashboard", but they want to interfere with each other. How can I avoid this?
  24. I have an app that is built on a user-defined criteria but pre-filled to use the header/footer option. I actually have it deployed in two completely different websites - both WordPress. One works perfectly, the other continually loops. Is anyone aware of a WP setting that I might be missing that is causing it to loop in one and not the other? Or is there a fix in the footer code that I can add to treat it as being submitted?
  25. I would like to present a report that returns the 5 most recent sales entries for any user. Each sales entry is assigned an autonumber field "booking_number". For an authenticated user, I'd like the report to return the 5 most recent "booking_number" records and some of the associated fields to the report. Not catching on to JS very well, so any help is appreciated.
  • Create New...