Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Becca37 last won the day on April 20 2019

Becca37 had the most liked content!

Recent Profile Visitors

370 profile views

Becca37's Achievements

  1. I have a potential client that wishes for a training management type application, where: an anonymous user can see a public listing of available courses, an anonymous user can put those items into a shopping cart an anonymous user can see their shopping cart that anonymous user is asked to login / create account once they elect to actually purchase the courses in their shopping cart The demo/template examples I can find are forcing login to put an item in a cart (e.g. online store template) or to even access the application at all (e.g. order management and training management templates). Is it possible to do an ecommerce application in Caspio without the user being forced to login prior to checkout?
  2. Hi @SunakoChan ... thanks. But that didn't work either. A lot more poking around and it was NOT being set by a Caspio style at all, {doh!}, it was being set by ... tbody tr:nth-child(even) { background: #F1F1F1; } ... in the CSS of the parent theme to the child theme I'm using in WordPress. I was able to override it using: #myUserInfoSnippet tbody tr:nth-child(even) { background: transparent; } Thanks everyone! :0)
  3. Thanks @kpcollier I tried that, also with no success. #myUserInfoSnippet [class*=cbFormTableEvenRow] { background-color: transparent; } (The reason I don't want to make a new Caspio Style is that then I'd have to maintain any other Caspio Style changes in two places: the main Style and the modified Style for this one DataPage. Much cleaner maintenance-wise to just override this one instance via CSS.)
  4. I have a Details DataPage with two sections. I want both to have the same background as the first section. I've tried the suggested CSS overrides for .cbFormTableEvenRow (and more which shouldn't be needed, to my way of thinking) and am having no success. Anyone have ideas on what I'm doing wrong? <table data-cb-name="cbTable" id="cbTable_69d4f79f110319" class="cbFormTableCellspacing_69d4f79f110319 cbFormTable_69d4f79f110319" role="presentation"> <tbody> <tr class="cbFormTableRow_69d4f79f110319"> <td colspan="2" class="cbFormDataCell_69d4f79f110319"><span class="cbFormData_69d4f79f110319"><div class="caspioClientInfo">CLIENT (1):<b> First Name Unknown Last Name Unknown</b></div> </span></td> <td colspan="2" class="cbHTMLBlockContainer_69d4f79f110319"> <div id="returnToClientDetailsLink"><a href="/clients/client-details/?ClientRID=1" title="Cancels Input or Update">Return to Client Details</a></div> </td> </tr> <tr class="cbFormTableEvenRow_69d4f79f110319"> <td colspan="4" class="cbFormNestedTableContainer_69d4f79f110319"> <table class="cbFormNestedTableCellspacing_69d4f79f110319 cbFormNestedTable_69d4f79f110319" role="presentation"> <tbody> <tr> <td class="cbHTMLBlockContainer_69d4f79f110319"> <div class="caspioClientInfo">File Status: <b>Error</b><span class="caspioSpacer"></span>Gender: <b>Unknown</b><span class="caspioSpacer"></span>Race: <b>Unknown</b><span class="caspioSpacer"></span>Born In Year: <b>Unknown</b></div> </td> </tr> </tbody> </table> </td> </tr> </tbody> </table>
  5. @kpcollier ... thanks for the info. I'll pop on over to the Ideabox. [Edit] Added a suggestion if anyone wants to vote it up. :0)
  6. How do we use application parameters in TASKS? For instance, we will want to generate reports on a pre-set basis (e.g. daily, weekly, etc) to be sent from a particular email that's used application-wide and to another particular email that's used application-wide. From_Email and SendReportsTo_Email would be the application parameters. But when I try to put the application parameters into the task input fields, they won't validate. I can use them in DataPages, e.g. for password recovery and submission acknowledgements. Very frustrating to not be able to use them in tasks as well. So surely I'm missing something and just am not doing it right. So: How do we use application parameters in TASKS? :0)
  7. @SunakoChan ... thanks, that worked beautifully! (Except for having to essentially recreate the entire page / rules / etc. as a "details page" instead of a "single record update form" -- sure wish Caspio had more consistency with how things work across page types, or would (much more simply) allow us to set display type on calcuated and virtual fields anywhere they appear.)
  8. Hi @douvega The number of records to be created wasn't the issue. It was the number of cascading triggers that caused the error. All resolved. Thanks though, APIs are an area I need to explore soon regardless. :0)
  9. Good morning :0) I have an Single Record Update DataPage that pulls in a list of information from another table using a query in a virtual field calculated value formula. This is great as far as it goes, I get the data I'm expecting and with the HTML tags (unordered list) I need. But I WANT (need ; have ; would really be best) to be able to display that resultant listing as HTML and I can't find a way to do that. How do I make Caspio bend to my will? {insertEvilLaughterHere}
  10. @bbeshlian ... awesome sauce!
  11. This is how I created what I call a "User Logged In Info Snippet" which also functions as the site's login/logout function. I used an HTML DataPage that has only the info I want to show and pulls in logged in user's first name, last name, and role, then provides the logout link. I put the deploy script for that DataPage into the header on the website. It would be possible to use a DataPage without authentication (so it does NOT show the login fields when the user is logged out) but I'm not so sure you'd be able to get to any Caspio data external to a DataPage entirely.
  12. The thing I find most limiting on the free account is that DataPage limit. Even running into it being an issue on a paid plan due to the number of pages we need. A DataPage is a way of displaying or manipulating the data within a table or a view. There's no limit to the number of tables or views or tasks that you have behind the scenes. Just the number of DataPages that are used to expose your data for use. Say you have three tables. To create a form to add a record to the first table, well that will take one DataPage. If you want to be able to have your users edit those records they're adding, well, that will take another DataPage. And so on for the other two tables. So there's six pages right there. Other than that lets see ... well, your example of field validation. And this is not free/not-free plan thing, Caspio just has very limited included validations, period. Caspio validates for data type. e.g. if the field in the data table is a number, the DataPage form won't accept alpha characters. It can also check for required input and you can set min characters and max characters. But you'd have to roll (or find) your own javascripts for any other validations or formatting you want done at submit (email addresses, phone number formats, SSN format, etc). Tables and Views are also not what I was personally expecting. Table fields have limited manipulation that can be performed. e.g. you can't pull data in from another table. Even the Views merely join tables in the most basic way and you can't do counts, etc there either. That takes a report DataPage to do the aggregations. Again, I'm just used to much more freedom there. DataPages themselves are frustrating for me personally as I constantly bump up against their constraints of "can't do this, can't do that" and sometimes it takes me an hour to track down how to do something that would have taken 2 lines of SQL or C# code. All that said, I'm coming from a developer background with 2 decades of designing my own databases, writing queries, stored procedures, etc. and writing the code to get stuff in and out. So I see things here more from a limitation standpoint. But Caspio IS pretty darn powerful in what it can do in a low- to no-code manner, and for the users not used to rolling their own my bet is it's a wonderful beast all around.
  13. Hi @Hencoco What @Alison offers works great if you want a static date as your default. Another option, if you want the "current date" value to be populated by default, is to use: On Load receive value or parameter, external parameter, and put [@cbTimeStamp*] into the field.
  14. I can't see all the logic for your criteria, but it looks like the outer container for all of them is an OR based on it's coloration. If taht's correct, if any one of the AND sets is matched the logic will return data based on that match regardless of the MBO value. Are you wanting the MBO value to ALWAYS have impact? If so, you need another level of nested logic --> an AND as the outer countainer with its children being the MBO entry and the OR that contains currently contains all the rest. Also, you have the MBO parameter set to "if empty, ignore criteria". Which begs two questions: (a) ARE you passing the MBO parameter value? (b) Do you mean to ignore it if it's empty?
  • Create New...