Jump to content

Search the Community

Showing results for tags 'datapage'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 49 results

  1. I want to make a website that people post their writings and publish it. So, I need that each person has a username and password that he/she uses in order to post anything and other people will be able to view them and know who wrote it. Is that possible? How? Please note that putting the correct password is necessary in order to use the username. Thanks a lot in advance
  2. Hello, I often use the following SQL code to create a calculated field which concatenates elements of a list with a character separating them (here is it a vertical bar "|"). For instance, here I am creating a list of all the common names for a given plantID (CPCNumber) in the table tblPlantCommonNames. Is there a way to create this code but remove the character from the end of the list? SELECT CAST( CommonName AS nvarchar) + N' | ' FROM tblPlantCommonName WHERE CPCNum = [@field:CPCNumer] for xml path(N'')
  3. HI All, I'm looking to create something that automatically deletes a record after a certain number of days. Essentially: If ITEM is marked as FOO, delete after XXXX days. Anyone know if it's possible to do this?
  4. Hello, I am creating a calendar data page in the "monthly" view. There are often weeks where there are no events, but aesthetically, I think it looks odd if these weeks are collapsed to be much smaller than the weeks that contain events. I changed padding = 20px in the ResultSetCalendarField element to make the empty rows slightly larger (see below). But this element also affects rows with events, so the discrepancy is still large (see screen shot). Is there any element to change that would make the default size of these empty cells larger? .cbResultSetCalendarField { /*Results Page Calendar Data Attributes*/ text-align: right; padding: 20px; color: #555555; font-size: 11px; font-family: 'Roboto', Arial, sans-serif; font-weight: 400; }
  5. How can I use Multiselect listbox to perform a search with OR logic? I have separate search and report as described in the video: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Does anybody have ideas?
  6. I am creating a new Application and found one issue. I need to check a number of registered and unregistered users visiting my DataPages. Question: How can I track the user logins to the DataPages?
  7. Hi. I have a datapage that I print often. It's a Details Datapage, and I print the Details Page. I've gone through the style assigned to my document, and reduced the side of text from 12 to 10 in settings (in a number of places). The text appears smaller in the window, but when I print it, the text is the same size as it was. The text of the document is too big and I'd like to reduce its size somewhat. How could that be done? Thanks.
  8. I have a gallery report datapage with a Search form and Results displaying on the same page in the results I am using a (specific data field) to link to the details page I want to create a custom link - (click here for Ingredients info) the user clicks on the custom link which takes user to another details page How do I set this up where the link is going to another details page? Any help is appreciated! Thank you --example-- Butter Pecan Ice Cream --> Link to Detail page (Specific data field) - THIS WORKS! 1234 Somewhere Lane City, state, 12345 Website: www.ButterPecan.com --> go to website (opens in another window) THIS WORKS! custom link --> click here for Ingredient info (HELP!)
  9. I am currently developing a database to catalogue bobbleheads given away by various hockey teams. I essentially want to just make one datapage but deploy it on multiple pages on my website and was wondering if there were multiple ways of displaying the datapage when you deploy it. For example if I just to display the table as if it was already searched is that possible? Instead of making the user search first just display the table having already been searched for a specific team.
  10. Hello everyone, Is it possible in Caspio to remove the "No record found" message in results page? Instead, I want to display a button that will re-direct the user to a form where he/she can create a new entry for that specific search criteria. Thank you for the help.
  11. Good day fellow Caspio developers, I have a DataPage where I have set up a link using the Link Menu generator found at https://b4.caspio.com/dp.asp?AppKey=a3012000cb4d6f2877864fd4a875 that delivered the following script (where I have added a little font formatting too): <span style="font-size:12px;"><span style="font-family:tahoma,geneva,sans-serif;"><a class="cbMenuItem" href="#" onclick="window.open(&quot;https://c0esh337.caspio.com/dp/cdemyDataPageAppKey?Dest_Country=[@field:Country_Name]&amp;Company_Name=[@field:Importer_Of_Record]&quot;,&quot;mywindow&quot;, &quot;menubar=1,resizable=1,width=500,height=700&quot;)">View IOR Contact Details</a></span></span> The general idea here is that when the user clicks on the link, it opens up a pop-up page displaying the Importer_Of_Record contact details and it works just fine for that purpose. However, there are instances in my data where there is no record in the Importer_Of_Record field and so when this is the case I would like the script to recognise this fact and hide the link. Is this possible and if so what changes do I need to make to my script? Any help is much appreciated! Thanks, Stephen
  12. Hello everyone, I am trying to create a submission form with four fields, NAME, EMAIL, CONTACT PERSON and RESUME(File Data type). Now I want to have a user interaction that will confirm if the user wants to proceed when he/she submit a record. e.g. "Are you sure you want to apply for this Position?" Any help would be much appreciated. Many Thanks!
  13. How can I write (insert) the rows in a DataPage report result set into a table? Table of details, with multi-level rollup, is updated by many users with login RLS. Results change often and unpredictably. Have a view that presents the correct data from several tables for a rollup report that counts instances of an item by a grouping factor, rolled up through the levels. A snapshot of the rollup report at the end of a week is used to guide deliveries based on the counts as of that time. Need to be able to write that snapshot (the rollup DataPage tabular report result set) into a history table with same columns. Purpose is to have accurate history by week of those counts to derive accurate totals for period(s) and monitor trends over time etc. I know I can export and then import append into a table, but was hoping for an automated method initiated via button or similar. New to Caspio, but not afraid of code, at least to copy and paste Thanks for any help.
  14. Ok, here goes. I'm creating an application to store specific keyword information. I need to be able to associate certain keywords with certain groups. I've come up with a way to do this, using dropdown menus. There are general categories (Shape, Color, Gemstone, etc.) and when one is selected, I need a second dropdown menu populated with things relevant to the option chosen in the first dropdown. For example, if I choose 'Gemstone', the next dropdown would have options for sapphire, ruby, diamond, etc. Any tips on how to do this?
  15. I want to add the Roboto font to my DataPage as a custom font. How do I do that?
  16. Hi, We have a datapage of a list of current records. At present, we click on a link, and the individual record opens up in a new tab / window. What we would like to do, is have the record appear in a lightbox / modal. However because there is no active "link" involved in opening up a modal (done with Bootstrap - it's simply: data-toggle="modal" data-target="#myModal") and then I would put the Caspio deploy code within div class="modal-content" - how would I ensure the correct record opens up? Many thanks Nikki
  17. After a long day of coding/working, I inadvertently and accidentally deleted an important Datapage... Is there any way to restore the datapage? I have the Appkey...
  18. We need to create a manual sort in a pivot table on a data page. We want to have size (XS,S,M,L,XL,2XL) appear in order on the rows rather than alphabetical. How can you do this? Thanks...
  19. I'm using a barcode reader to scan an order in a form, passing parameters to another form that scans the product sku, and the 2nd form opens itself up after each sku for however many skus are related to the order. It works well. The sum of the skus scanned by product are in another report datapage that updates on the same page the 2nd form is on. The report queries both the table used to scan skus for a sum by product, and a table containing data from shipping software that contains what should be shipped within it's table.... The only issue with this setup is that I'd prefer to get rid of the 2nd form, and just scan the order# , then pass parameters to the report page and use inline edit to scan skus.... the barcode reader hits enter itself with each scan and I have the button hidden... I can't get this done BECAUSE I can't get the cursor to focus on the inline edit field for skus when the first page opens the report. I think there should be an option for this like there is for forms....but since there isn't, I've been trying a bunch of scripts....here's my latest.... Footer: <script> { document.getElementsByName('EditRecordInlineAddlineItemsku').focus(); document.getElementsByName('EditRecordInlineAddlineItemsku').select(); } </script> Any ideas how I might fix this???
  20. AdamS

    Pie Chart Labels

    Hi. I am trying add both the cbChartValue AND cbChartCategory to a pie chart label. Currently, I only see cbChartValue... any suggestions? Thx, Adam
  21. In our application the streetname en housenumber are stored in one field called Street. For a download we have to separate streetname en number in two fields (street and number). How can I do that using a datapage?
  22. So I'm trying to get the value that is already in the current points field, do a calculation as depicted in the switch statement and then fill the field in again with the new number before submitting instantly. This is all supposed to be done as a way of replacing an SQL update statement. For some reason my EditRecord or document.getElementById doesn't seem to be working at all. <script LANGUAGE="Javascript"> function calculate(){ var pos = [@pos]; var points = [@field:CurrentPoints#]; switch(pos) { case 1: points += 10; break; case 2: points += 8; break; case 3: points += 6; break; case 4: points += 4; break; case -2: points += -2; break; default: points += 2; } document.getElementById("EditRecordCurrentPoints").innerHTML = points; } document.getElementById("mypage").onsubmit=calculate(); </script> There is already a <div id="mypage"> in the header and a </div> in the footer. Am I just being very stupid?
  23. Is there any way to restrict the possible date range of a calendar popup? I found a post that showed how to validate the element and show an alert, but what I'd like to be able to do is actually restrict the dates the user can select in the popup. Thanks, Andrew
  24. I have a working conditional statement using SQL. However, the output (following the "then" statement outputs plain text. Does anyone know how to force it to be formatted as a clickable link? Here's the full statement: CASE WHEN [@field:connect_PIF_ER_eval_complete]='' then '<a href="participant_evaluation.html?ER_ID=[@field:ER_Events_1_ER_ID]&Ev_Type=[@field:ER_Events_1_Event_Type]">Evaluation</a>' ELSE 'Evaluation Completed' END I'm sure it's obvious, I'm just not sure what needs to surround the href tag. Thanks!
  25. Hello, I'm editing a datapage with multiple custom HTML elements and it would be really nice if I didn't have to "finish" after each changed to test it on my server (bc this then throws me out of the datapage I'm editing and I have to re-select and and navigate back through the wizard to the right page to edit). Is there a way to save a datapage I'm working on without clicking the "finish" button? Thanks, Andrew Hughes
  • Create New...