Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. By the way, now I'm able to link the Submission Form to the Data Page, but the fact that I cannot select the "Calculated Field" from the "Filtering Field", how can I pass the Submission Form's parameter to it?
  3. Hi @Vitalikssssss >> You may use Virtual fields for this Submission Form. Virtual fields can pass parameters to the report to filter the data. Ok, I got it. I was able to pass the value from a Submission Form to my existing Data Page now. >>Also, you would need to embed both Submission Form and Report on single web-page. Can you show me how to do this? Tks again. Regards, Ryan
  4. Hi @gregbovenkerk, What Datapage type do you use? It is possible to add Total & Aggregation field on Tabular report in order to get count of records. You can check this article: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ Hope this helps. Regards, Vitalikssssss
  5. Hi @ryancys, You would need to use separate from the the search which will be based on Submission Form. You may use Virtual fields for this Submission Form. Virtual fields can pass parameters to the report to filter the data. Also, you would need to embed both Submission Form and Report on single web-page. The concept described in this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/add-a-search-interface-to-results-sets-page/ Calculated Value datatype is available on Submission Form and Single Record Update Form. Hope this helps. Regards, vitalikssssss
  6. Hi, I'm new to Caspio and would like to know if it's possible to configure a calculated field as a Search field in Data Page? It seems that it's not possible, but what's the workaround? I tried to get the maximum value from another table based on simple field matching with the main table. Tks Regards, Ryan
  7. Hello: I have a <i> button as shown in the image below! It is activated on the parent table 100% which leads user to "details" page (separate datapage) having a unique ID. Now on the child table(same attachment), some of the listings don't have enough info, so I don't want user to be redirected to the "details" page. I have created the criteria by creating a yes/no filed for those records that are just basic (phone number, address) and no more info. Question is: How do I create not linked icon inside the script. Current script is: (attachment 2) And the part relating to the icon is: //More info code starts if (UniquePrefix[@field:AutoID]){ document.getElementById('infoimage[@field:AutoID]').innerHTML = '<a href="http://www.goplaypool.com/places.html?Location=[@field:UniquePrefix]"><img alt="Establishment info" src="http://assets.goplaypool.com/files/theme/appcas/listboxinfo01.png" style="width: 32px; height: 32px;" title="Establishment info" /></a>'; } else { document.getElementById('infoimage[@field:AutoID]').innerHTML = '<img alt="" src="http://assets.goplaypool.com/files/theme/appcas/listboxdir02.png" style="width: 32px; height: 32px;" title=""/>'; } The second condition created for listings with not enough info to go to the details page is called: VenueOnly I am not sure if I explained 100% or it is confusing. Thanks in advance for any help! AlwaysLost
  8. Yesterday
  9. That? I just happened to need the same information a while back so I asked my account manager. They also mentioned that the reason why there is a daily limit for email sending is because it is a fail-safe just incase that a user misconfigured his task or triggered action and make it send automatic emails, infinite times which may cause server issues and exhaustion of the accounts resources.
  10. I have a Report Datapage that displays Tabular results. I have enabled users to download their search results into a .csv file. I would like to limit the number of records (5,500) that each user can download over the course of 365 days. I would like to continue to allow them to download as many records each time they search until they have dowloaded 5,500. At that time I would like the download option to be disabled. Has anyone done this? Thanks
  11. I've created a chart that shows the number of records collected by week, but need to be able to change the week number on the axis to "Week of 2/17/20" instead of 8. Thanks in advance for your help.
  12. I have the up to date version of this code which is friendly with AJAX loading of the datapages: <script type="text/javascript"> function customAlert() { alert ('Form was submitted'); } document.addEventListener('BeforeFormSubmit', customAlert); </script>
  13. I'm looking to display totals or counts as text in HTML. Specifically, I'm running a sweepstakes and want to display the total number of entries. For instance: TOTAL NUMBER OF ENTRIES: 2,387 I know there's got to be an easy solution. Thanks in advance for your help.
  14. Hi @NiceDuck Where did you get those figures from as it doesn't state this in the pricing schedule for basic plans https://www.caspio.com/pricing/basic-plans/ in fact Triggered actions doesn't state a monthly or daily limit at all only Notification Emails, SMS, Import Update, Scheduled Tasks and REST API have a stated monthly limit?
  15. I think the above code might be able to help me. In my report I have fields for 'year', 'region', 'country', 'product' and 'tonnage'. The 'region' field is a calculated field. I wish to show aggregates of my data by region, but also for each year. Caspio prevents me grouping data by 'region' because 'region' is a calculated field. And I can't use 'Totals & Aggregation' either because Caspio only allows me to use 5 of those. My mix of 'region' and 'year' could end up being many aggregate totals. I could be wrong but I think the 5 year-old code from Xiang (above) allows me to add aggregate rows at the bottom of the table... or am I being too optimistic?! Anyhow, I tried to get his code to work but I think it uses old Caspio commands and all I get is error "Cannot read property 'getElementsByTagName' of undefined". Is anyone able to make adjustments to this code to make it more generic? Alternatively does anyone have any other suggestions on what I can do? Many thanks
  16. I am trying to pass fields with special characters such as a Hash(#) over query string? I am new to Javascript, but I copied the Javascript from the answer below, and it works fine on the first link of the grid, but all the rest of the links have the parent URL and none of the data. It is building the parameters properly for the first link. I inspected the broken link and I found: Do I need a loop? or do I need to refer to the links I am trying to encode a different way than document.querySelector(`#${link_id}`).href = `${base_url}?${params.join("&")}` Is there a better way to build the links? I have 17 fields that I am adding to the array to build the links. I would appreciate any help
  17. Last week
  18. Yes it was. You could also try using emails instead. Here are the pros and cons: SMS: PRos: Much faster (I think) Cons: Canada and America numbers only Emails Pros: Global and no need for extra device. cons: Due to the recent issue, your email may ended up bouncing back or filtered out as spam if you have not configure it correctly. Also, slower to receive (personal opinion)
  19. By default, the daily limit for emails on your account (notification, acknowledgement,trigger or task) is 250. However, if you would contact the support, they will increase that for you...
  20. Hi, I have a Calendar/Tasks table that stores a date for either an appointment or a task due date. I need to add a few functions and was hoping someone might have an idea of the best way to do this: 1) I need to add a Time selection for a calendar event. Meaning the user selects a date like normal (using the date picker) to put into a date/time field (the 'Event_Date' field in this case) but ALSO can select a time for the event (like a normal calendar like iCal or Google Cal). I know I can create a text field and use a lookup table for all the times (like 2pm, 2:15pm, 2:30pm, 2:45pm, etc.) and store it that way. My question is, can I use a text field that stores a time like this (i.e. "2:45pm") to perform calculations in a formula to get how many days/hours/minutes the current date/time is from that stored date/time? Or does that time data need to be in a specific format or included in the 'Event_Date' value (which is a date/time field). 2) What I'm trying to do is allow the user to do something like set an appointment for a date/time like 4/15/2020 1:30pm and also select a 'notify me' value like "2 days before" or "3 hours" before and then use the Automated Tasks feature to send an email/sms reminder to the user. 3) The last issue is how to store the date/time of the event because Tasks runs on UTC time and my users are all over the globe. So if a user in California puts in "4/15/2020 1:30pm" it's not the same date/time value as someone in Australia, in terms of the Tasks trigger firing. Maybe convert the users local time to UTC after they input it? Not sure of the best approach but to the user, it needs to be viewed/entered as local time (not UTC values) so it's understandable. I wish Caspio had a full calendar like this, built in, as these features are an integral part of most user needs. But if I can build it myself that'd still be great. The first 2 issues to me are the most important, though, so if anyone has some advice on this, or how to get the result I need (a normal calendar with times and notification choices) I'd really appreciate it.
  21. Hey @shaferam, Have you tried the ready made apps? I believe they have a Document Review Management app that you may be able to customize to your needs. It should at least help get you started.
  22. Hi all, what is the daily email limit on triggered actions? Does the daily email limit also count for tasks? Thanks!
  23. Still a bit confusing to me .. however, how would the product "fail" lining inspection? What process in the flow validates/checks for a "pass" or "fail"?
  24. How would you recommend a multi-part approval process be set up for a document management app? A user will submit a document that would need to be reviewed/approved by several users before a final approval can be issued. The individual approvals can happen simultaneously and aren't interdependent. Department A approves/disapproves (with comment)/returns for revision (with comment), Departments B-D do the same. When all 4 department approvals are obtained the document is fully approved. The document needs to be assigned to multiple people at the same time, with each of them doing their own independent approval. Thanks in advance for any suggestions!
  25. @Altair Nice find. I couldn't get the webkit method to work from directly on the DP. The script updated above works, however. LC also said they are implementing a quick and easy setting for it in Styles, so we should be alright!
  26. I also managed to make it work using a Style so you can easily apply it to multiple DataPages:
  27. Upon using the new Responsive DataPages feature from Caspio Release 21, I noticed all of my forms that had this enabled were aligned to the left. I couldn't get any of the solutions already in this forum to center my datapages. The new Responsive feature completely restructures the HTML of the DataPages. I have tried a lot of things. In DevTools, if you select the .caspioform element, you can add 'text-align: -webkit-center;" and it works. However, try adding this CSS rule to your DataPage, and nothing happens. Edit*: Live Chat has helped me find a fix. [action*="[@cbAppKey]"] > div:nth-child(1) { margin: auto !important; } This should center your DataPages. They are working on adding it to Styles.
  1. Load more activity
  • Create New...