Jump to content


Caspio Evangelist
  • Posts

  • Joined

  • Last visited

  • Days Won


kpcollier last won the day on June 5

kpcollier had the most liked content!


Recent Profile Visitors

1,129 profile views
  1. You cannot. Virtual fields don't get saved anywhere, so the triggered action wouldn't have any values to run off of. You'll probably need to make it an actual field in your table.
  2. @DarwinCastro, I was trying to do this previously and could not find a workaround. Caspio doesn't have a standard way to do this. You will either need to set up DataHub to do a scheduled import from somewhere like Box.com (users would upload files to a specific folder, this folder gets imported on a specific time/date), or have someone that has access to your Caspio Bridge do a manual import. I don't believe all plans have access to the DataHub.
  3. Another thing to note - In the case of referential integrity enabled in a relationship, if a trigger executes on an insert event to the parent table, and inserts a record to the child table, the Triggered Action will fail. This is due to the action of inserting a record to the child table occurring first, thus failing the integrity check as the parent record does not yet exist. https://howto.caspio.com/tables-and-views/triggered-actions/
  4. Both. It is an issue with Weebly and there is a way you can fix it. It has to do with the CSS styling from the Theme you are using in Weebly. I can't seem to replicate the issue right now, but I remember it has happened to me before. You will need to go to your live webpage and go to your devtools. If you are using Google Chrome (it's probably the same in Firefox but I'm not sure), click Ctrl+Shift+C and that should open up DevTools. Then, click on the cursor icon on the top left on the devtools window. Select the dropdown and see the code that comes up. You'll need to look on the Styles tab to see what CSS rule is styling the dropdown. Then, go back to your Weebly Editor. Click on Theme tab, and at the bottom left you should see 'Edit HTML/CSS'. Click on it, go to your main Styles, and find that CSS rule. You can either delete the CSS rule (this will effect all dropdowns, caspio or not, on your weebly website) or you can edit the rule to make it look the way you want. OR You can use the iframe deployment method. iFrames don't use the weebly styling.
  5. No. You can use caspio links. You just can't test it within Caspio Bridge. You'll need to have both pages set to 'Deployed' and use the URL from the parent page (the one that has the link to the popup) in your web browser. Or, use the embed code and deploy it to your own webpage. What I meant is, if you are building the datapage and click on the 'Preview' button to view the datapage, it will not work. It has to be outside of the Caspio workstation.
  6. @Joemac, it looks like the article in that URL above was deleted and replaced with a new one. https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/automatically-add-options-to-dropdowns-and-listboxes/ There is a good description on how to get this going from that link. Make sure you are deploying your datapage before testing, as it won't work if you are using the 'Preview' option.
  7. I'm not sure if this is a good solution, because by the naming of the class it seems it could affect not intended cells. But, a fairly simply CSS rule was able to get rid of the column. Turns out it was just a couple extra cells in the Totals row itself. The columns were hidden, but those cells weren't. .cbResultSetTotalsDataCell{ display: none !important; }
  8. @CoopperBackpack, thanks for the reply. The hidden fields are 2 calculated fields, and they are the 2 last columns in the report. The Totals field is right before those two calculated fields. So essentially, after the two calc fields are hidden, the Totals field will be the last field in the report.
  9. This is actually kinda tricky. Probably because I suck at javascript. But, if you're any better than I am, I think you'll be able to get it. Check out this SO post, I think you'll want most of the function that the answer provides. This solution adds options to the select statement, but it also shows you how to get the values from the comma separated values in the text field. (advise that this workflow does not take into account spaces in the text field when splitting the comma separated values) Then, maybe something like this SO post to help you select the correct options. I am not fluent enough in JS to be able to put all of this together, but I hope this gets you started on the right path. Maybe someone more proficient will chime in to help you piece this together.
  10. Adding parenthesis to the SELECT statements made this work. CASE WHEN ([@calcfield:5] != ' ') AND ([@calcfield:6] != ' ') THEN (SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = [@field:Job_Number] AND Date BETWEEN '[@DateFrom]' AND '[@DateTo]') ELSE (SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = [@field:Job_Number]) END
  11. I wasn't able to get this to work for me. Unlike @rush360, my Totals column is aligned correctly, but I still have extra space to the right where I hid columns. Using the code above eliminates the extra space, but realigns the Totals number in the wrong column.
  12. What is the virtual field going to be used for? A parameter for something else? The reason for no virtual field in a report page is because it's for reporting information that is already saved in the table. Virtual fields don't get saved to the table, and if you have virtual fields in your Report page, it would show as a column. That column would be blank for every record. If you were somehow able to get a VF into the report, clicking Edit and entering something into it and then clicking update would also result in a blank, because VFs don't save information.
  13. This is definitely possible. You should be able to set up the search field to receive a parameter and still be able to use it if no parameter is present. Go to the Advanced tab on the search field that should receive the parameter. Check the 'On load' box, set Value to 'External Parameters', and type in the parameter name. Now, while coming from another page and passing a parameter, the field should be filled and you just need to click search. Or, if you're not coming from elsewhere, you can still use it as a dropdown or whatever you'd have it set as. If you want it to automatically search when a parameter is received, you can follow the workflow in this forum post:
  14. I was missing the single quotes on the parameters. SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = Job_Number AND Date BETWEEN '[@DateFrom]' AND '[@DateTo]' Now, both SELECT statements work. If there are no parameters, it sums up all hours related to that job. If there are date parameters, it will only sum up the hours between those dates. The problem is now getting the CASE statement to work. I can't seem to get the formula to run when nothing is entered into the date fields. I can't figure out how to check against blank parameters. I have tried adding the parameters to separate calc fields, and then running the CASE statement if those calc fields are blank or not, and I still can't get it to run. CASE WHEN ([@calcfield:5] is not blank) AND ([@calcfield:6] is not blank) SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = Job_Number AND Date BETWEEN '[@DateFrom]' AND '[@DateTo]' ELSE SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = Job_Number END
  15. I'm trying to use a search form solely for setting a condition in a calculated field in a tabular report. I have a Job_Table that houses information about our Jobs (Job_Number is the ID for this table). I have a TimeEntry_Table that houses Job_ID, Date, And Hours for our employee timesheet. The datapage uses Job_Table as the source. I have a calculated field that queries to the TimeEntry_Table and sums up the Hours for each Job. This works. However, now I am trying to add a date range to this. I've been trying to use two virtual fields in the search form to set parameters. If the user leaves these blank, it'll just sum up all of the hours matching the Job_ID. But, if they enter in dates in the two virtual fields, I am trying to use these in my Calculated Field. CASE WHEN [@DateFrom] IS NOT BLANK AND [@DateTo] IS NOT BLANK SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = Job_Number AND Date BETWEEN [@DateFrom] AND [@DateTo] ELSE SELECT Sum(Hours) FROM TimeEntry_Table WHERE Job_ID = Job_Number END To start off the CASE statement, I'm not sure if I should use the parameter name or cbViritualParam. It seemed neither worked. I am not sure if you can check to see if parameters or virtual fields are empty from the search form. Next, you can see the BETWEEN condition. This is where I am trying to enter in the dates from the virtual fields to filter the number of records that are summed up. Nothing is showing up with my workflow. Any help is appreciated.
  • Create New...