Jump to content

kpcollier

Caspio Rockstar
  • Content Count

    285
  • Joined

  • Last visited

  • Days Won

    13

kpcollier last won the day on July 3

kpcollier had the most liked content!

3 Followers

About kpcollier

  • Rank
    Advanced Member

Recent Profile Visitors

425 profile views
  1. kpcollier

    Mr

    That means there is something not configured or set up that should be. A lot of times, this could be the Details section of the datapage. Towards the end of your datapage wizard, you will see a checkbox asking if you would like to include Details - if this is checked yes and the rest of the wizard isn't filled out, it won't let you finish. Another example is if you set up Authentication for the page but did not select an auth source. It'd be something like that. Double check all of your options/checkboxes in your datapage wizard.
  2. @TaxGuy I've got a page with 30+ calculations and it is also insanely slow. Every time I ask support, they tell me to make it into a multi-step form, which is unacceptable for my workflow. I too am looking for a solution for better speeds. I haven't tried doing calculations into html blocks simply because that is a ton of work with the amount of calcs I have lol. I will eventually try it out when I get time. If you find a solution, please let me know!
  3. I didn't necessarily find a solution to the problem how it was above, but I decided to just do an overhaul of my Client Tables and all relating datapages to make it work a different way. Instead of having fields in the Client_Table for Home_Phone, Cell_Phone, and Work_Phone per client, I changed the fields to Phone_1, Phone_2, and Phone_3. I then added 3 new fields to my Client_Table called Phone_1_Type, etc. The purpose now is to have the first phone number field, Phone_1, to always be populated if there is a phone number. Then with the newly added fields, I express what type of phone that is: cell, home, or work. Now the cascading field on the Work Order Form takes in the first phone field, Phone_1, which should be populated no matter what type it is. Hope this helps someone in the future.
  4. I have a Client Table that stores all of our clients information. This holds information such as Name, Phone Numbers, Address, Email Address, etc. Pretty self explanatory. I also have a table called Work Order Table. We use this table to store information for Work Orders - when our customer needs some service done, we fill out a Work Order Form with their information and details about what work needs to be done. The problem is the phone numbers. For each Client in the Client Table, there is Home Phone, Cell Phone, and Work Phone fields. Some clients may only have one or two of those phone number fields filled out, leaving the other(s) blank. To be able to tell which Work Order belongs to which Customer, we include Customer Name, Address, Phone Number, and Email in the Work Order Form. To make this easier for my employees, the Customer Name field on the Work Order Table is autofill - you start typing in a name, it searches that in the Client Table, and when there is a match it autofills the Customer Name. From here, I can use cascading elements for Address, Email, etc. to automatically fill those fields in the Work Order Form. However, this creates a problem because of the way the phone numbers in the Client Table are set up. I can only have the cascading value be ONE of those Phone Number fields, and that field may or may not be one of the empty ones. I have tried using a formula field for this - but that makes it so the phone number cannot be edited whatsoever if there is ever a need to. A lot to go over - but its the last part of this app before it is finished, and it is killing me. I think I may need to change my workflow, or maybe how the Client Table is set up... Hoping someone has some suggestions.
  5. Odd. My max total size is 3.13mb. Maybe it has to do with Rank (either the Advanced Member or Caspio Rockstar), but I remember having a problem about a week ago preventing me from uploading a file onto these forums. Either way, @caspio should change the way it works. Sorry I don't have any input into your problem. I can not think of another way to get the value from one table saved into another table, other than with Triggers.
  6. Try to spread out the actions. So, instead of having one rule with A in criteria and Section 3, 4 in Action, go with 2 rules. One where the action is Hide Section 3, one where the action is Hide Section 4. Then, for Criteria, list all dropdown values that should have that section hidden. Rule 1: Rule 2: Rule 3: Criteria: B, C Criteria: A, C Criteria: A, B Action: Hide Section 2 Action: Hide Section 3 Action: Hide Section 4 And so on.. if there is another dropdown value needing to hide the 3rd section, add the value to Rule 2's Criteria. When I get a chance Ill write up a dummy page to show you.
  7. What kind of datapage is this for? Is it a Submission Form? I think you might be able to do this without JavaScript. When in the DataPage Wizard, use the Rules section. In the Rules section, create new Criteria. This will contain the dropdown selections. Notice how on my Criteria, I have a 'Job Type' field that could hold multiple values. Next, the Action section. This is where you hide the sections you want hidden. In my current workflow below, you can see that if 'Job Type' equals any of the listed values in Criteria, then Section 2 of my form will be hidden. If Job Type is any value not listed in Criteria, Section 2 will be shown. It is a good idea to split up the form/report with Sections, as you can only use ONE field per Action. So, if you are hiding a field and try to make another rule with that same field, it won't work. If you need more help let me know!
  8. Hello. I am trying to create a somewhat dynamic ID number for my records. Here is how my workflow goes: We are a construction company. When we get a job, we make orders for materials for that job. There may be multiple orders for one job. Each Job on our Job_Table gets a Job Number (ex. 12345). I am trying to use this job number for the basis of my Order ID: I want the Job Number followed by the number of order this is for the job. So, lets say the Job # is 12345. We have to make 3 separate orders for this job. I would want the IDs to be 12345-1, 12345-2, 12345-3. Is this possible? If more information is needed please ask. Thank you.
  9. kpcollier

    PDF Report Page

    It depends on what plan you have with Caspio. The higher up plans, (I can't remember the exact names) include a PDF Generator option. With this option you can opt to download a pdf of the datapage. Here is a link to the pricing. Here is the link about the PDF Generator.
  10. Yeah, its really weird. Definitely happens at random. Unfortunately, even using !important doesn't change anything. If the values don't get loaded into the datapage, the listbox will shrink no matter what. Even if it was at the fixed width, the main problem of having the values missing would still be present. Caspio Support says they found the issue and that it was with Google Chrome, would be fixed in Caspio 20.0... This confirmed my belief that they have no idea what is going on either, as it happens on multiple browsers. I think I'm out of luck.
  11. Here is the link to DropBox: https://www.dropbox.com/s/x19yc9d9mppx3hw/CaspioData_2019-Aug-19_1242.zip?dl=0
  12. @Vitalikssssss, thank you for the reply! I have tried using both fixed and auto widths, though. Even with a fixed width, the listbox will shrink to the size in the screenshot without any values. I don't believe I can share files on these forums anymore.
  13. Did you look at the articles? Caspio does not have a standard feature button for mail or print. There is a PDF option that downloads the page as a pdf with the ability to print, at higher up plans... But for the workflow you want, you'll need some custom script. Which would be from those articles above.
  14. FWIW, I am having trouble with one of my datapages with disappearing stuff also. Its a bit different, but all of my values in Listbox Datatypes that I have on my submission form do not load with the page. This happens intermittently, not all of the time. However I cannot deploy this app until I am sure it won't happen. Its frustrating.
  15. Try using the information here: For Print button: https://stackoverflow.com/questions/20101409/how-can-i-insert-a-print-button-that-prints-a-form-in-a-webpage For Email button: https://stackoverflow.com/questions/19422331/how-to-create-an-email-button-with-javascript I am guessing you can either have one button for each function (one for email, one for print) or create your own function that implements stuff from both articles.
×
×
  • Create New...