Jump to content

Search the Community

Showing results for tags 'datapage'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

  1. 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?
  2. Hello! I am using the modal script to input modals on my website, (YouTube tutorial) and am having problems with the form not auto sizing to the modal box. I can see how to fit the over flow inside but the content scrolls horizontal and doesn't fit to size. If I make the screen smaller it goes to correct size as its responsive to mobile. I was told in the help chat to input the CSS into the header of the corresponding data page but Ive tried a couple things and it ends up showing up in the preview, so Im not sure where to put it and what. Thank you! I
  3. Hello, Can you help or advice me to reset a parameter. I ask already the Caspio Support but they advice me to place my question to this forum. In the attached file I explain the situation. Thanks in advance for helping me. Best regards, Jeroen Molenaar question about reset parameter.docx
  4. Hello All, Is there anyway in a Calendar Datapage to have the calendar "jump" the week to date of a searched record? I default the calendar to "Today" in a Weekly View. When a user searches for a record, if that record doesn't have a date in the current weekly view, it doesn't appear, although it exists on a future date. If a user searches for a record in the search field, I would like the calendar below to jump to the week of that record. In this example, after clicking search for this Customer's Name, the calendar would jump to the week of January 7, 2024-January 13,2024 because the customer's appointment is on January 9, 2024. Does anyone know if this functionality is possible? Thanks! Chris
  5. I'd like to add some HTML to my Datapage to conditionally change the color of a report's background and text color based on the value of a calculated field. This field finds the number of days left until a project is due. I'd like to change the text color of this field to red and the background to yellow if it is past due (if the days left are negative). I know there are a couple of other pre-existing threads on this topic but for some reason I am having no luck. I pasted these in the source of my header but they had no effect. Let me know if you see anything wrong with my formulas: //for the background <a id="visi[@calcfield:1#]"> <script> var isi = document.getElementById("visi[@calcfield:1#]"); if(isi < 0){ isi.parentNode.parentNode.style.backgroundColor = 'red'; } else{ isi.parentNode.parentNode.style.backgroundColor = '#NoColor'; } </script></a> //for the text <div id="mydiv[@calcfield:1#]"> </div> <SCRIPT LANGUAGE="JavaScript"> if ("[@calcfield:1#]" < "0"){ document.getElementById("mydiv[@calcfield:1#]").innerHTML ="<span style='color:red;'> [@calcfield:1#] </span>"; } </SCRIPT>
  6. In MS Access it is possible to set up an input form so that if a value is missing from a given field's dropdown box the user can then add this on the fly by being taken to the appropriate input form and adding the missing value before returning to their starting input form to complete their initial intended data input. I have attached a pic of where this is done in MS Access properties. Is it possible to do this in Caspio DataPages? If so, how and where is this done? Any help would be much appreciated. Thanks
  7. 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
  8. I have two complex data pages that are both submission data pages. Because they are submission data pages, I do not have the ability to use view data to help create the new records. Because of this, I am being forced to make MANY database calls in order to get the data I need to create the new records. Requirement: Log user Login activity, load external parameters, redirect user to appropriate landing page based on user type Scenario #1: 3 states (User exists and is Member, User exists and is Admin, User doesn't exist and is NEW) Based on User Status: If Exist, Get Profile information and load external parameters (currently 12 params) If Exists, Get Profile Preferences and load external parameters (currently 27 params) Redirect to appropriate location Problem: If I keep with a Submission DP (submitting ProfileLoginLog), then I need 39 individual calls to the database because I don't have a view I can rely on. What I am Thinking: If I change the data page to an Update DP, I can then use a view that will support the Profile and Profile Preferences. But then I end up with two problems: How do I handle the condition (a VALID condition) of when the user is NOT found? How do I insert a record into the ProfileLoginLog table? Any Ideas? If I can solve this for one situation, I can solve this for both situations. Your help would be much appreciated. Lynda
  9. Hi all, I am working on vehicle insurance portal. I have stuck in some building functionality in DataPage. My requirement is: A user wants to fill his information along with his family member's information by clicking on add in 'User information DataPage'. I need to create a "Add Member/Add Driver" button so that it can add its members/Driver's information one by one. Like if it has one then one member will be added or if it has more than one then more members will be added. For every member have same input field but different form. They should be able to submit multiple times based on the number of member/drivers added.These all data need to store in one table, so that we can fetch these data easily. Here is my DataPage URL which am working on it. Please find attached file below. This is the structure I have to developed in this DataPage. If any resources are available please share or give any road map to build this functionality.
  10. I want to add the Roboto font to my DataPage as a custom font. How do I do that?
  11. Hello everyone, Thank you in advance for reading this and potentially responding. Long story short: I have a simple Pivot data page with item names and months as well as submission status. This is used exclusively to spot records per item/month that have not been "submitted". My stakeholders want to see the status in color. Green for "Submitted", yellow for "Partly submitted", and red for "Not submitted". Whether it's text or background color doesn't really matter much but I prefer background. I think I am capable of adjusting the tones on my own, but I struggle with making the script work in the first place. The specific names of my fields are: Item Name, Month, Status. Here is what I already tried, unfortunately, none of it ever displayed. 1. Adding a Header and Footer or an HTML block on the results page and disabling HTML in the tab Advanced. 2. Taking various scripts from Caspio guides and forums and attempting to change them to fit my field names and Status values. For example, starting with this script from the guide: <span id="[@field:ID#]changeColor1" style="color:#008000"></span> <span id="[@field:ID#]changeColor2" style="color:#0000FF"></span> <span id="[@field:ID#]changeColor3" style="color:white; background:red"></span> <script> if([@field:GPA#]>=3.5 && [@field:GPA#]<=4.0 ) { document.getElementById('[@field:ID#]changeColor1').innerHTML='A'; } else if([@field:GPA#]>=3.0 && [@field:GPA#] <3.5) { document.getElementById("[@field:ID#]changeColor2").innerHTML='B'; } else if([@field:GPA#]>=2.5 && [@field:GPA#]<3.0 ) { document.getElementById("[@field:ID#]changeColor3").innerHTML='C'; } </script> Let's leave the colors as they are since I am confident with that part. Here is my attempt at replacing the values with my own (the only relevant field is Status and it has three values: "Submitted", "Partly submitted", "Not submitted"): <span id="[@field:Status]changeColor1" style="color:#008000"></span> <span id="[@field:Status]changeColor2" style="color:#0000FF"></span> <span id="[@field:Status]changeColor3" style="color:white; background:red"></span> <script> if([@field:Status] = 'Submitted') { document.getElementById('[@field:Status]changeColor1').innerHTML='Submitted'; } else if([@field:Status] = 'Partly submitted') { document.getElementById("[@field:Status]changeColor2").innerHTML='Partly submitted'; } else if([@field:Status]= 'Not submitted') { document.getElementById("[@field:Status]changeColor3").innerHTML='Not submitted'; } </script> And here is how I set it up (please mind that while I tested HTML blocks instead in other data pages and it still didn't work, you can't add them in the pivot table, so I'm limited to the Header and Footer): Nothing changes. I even made a draft table and a data page to test some of the scripts with their original field names but somehow it still didn't work for me. I will be grateful for any help! Thank you, Dominika
  12. 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
  13. 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?
  14. 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!
  15. Any ideas on 'how to format' this custom link to be inline with the 'data download' link and include an icon? Please see below code I'm using for the custom link placement and the attached image, thank you: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var child = document.querySelector("li[id^='DataDownloadButton']"); var parent = child.parentElement; var a = document.createElement('a'); var linkText = document.createTextNode("my title text"); a.appendChild(linkText); a.title = "my title text"; a.href = "http://example.com"; parent.parentNode.appendChild(a); }); </script>
  16. 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'')
  17. Hi I used total & aggregation default function to calculation average score for table that has 12 months. The answer calculated has 6 decimal place but I want to have it round up. How do I fix this? There is nothing on the datapage round it up. Example (the actual calculation will give 2 decimal place in the below scenario. just for the purpose of illustrate, i have put in a dummy average value) Name Jan Feb Mar Name1 4.22 4.23 6.3 Name2 4.12 4.11 6.44 Mth Avg 4.31123 4.1732 12.74234 how can i round up to 2 decimal point 4.31123 to 4.31?
  18. In my application I want users to be able to edit fields for events that are associated with the current calendar year, but not past years. I am using a Calendar DataPage that displays the events based on the filtered Year and other variables. Each event has a link that routes to a webpage that displays the event's details. I have two links, one that directs to an editable DataPage and the other to a non-editable DataPage. I only want to show one link per event, which is dependent on the filtered calendar year. I followed the directions in the following forum post, but the link does not hide as expected on the filtered year: Calculated field (CalcField): CASE WHEN [@field:Event_AY] = '2022-2023' THEN 'show' ELSE 'hide' END First HTML Block contains URL: <a href="#" id="link-id-[@field:Event_Table_ID]" target="_blank">Details</a> Second HTML Block contains script: <script> var link = document.getElementById("link-id-[@field:Event_Table_ID]"); var htmlBlock = link.parentElement; var entry = htmlBlock.parentElement; var calcFieldIndex = 4; var calcField = entry.getElementsByClassName("cbResultSetData")[calcFieldIndex - 1]; if (calcField.value !== show) { htmlBlock.style.display = "none"; } </script> I know the calculation is working, the show/hide link just isn't working. Any insights would be appreciated.
  19. Hi All, i am working with a project where in i need to display it in a monthly calendar view but i can edit it each day to update the records is this possible? I know other options like i can include details page but i want it to be editable on the first page without clicking the details page.
  20. Hi, is there any way to download the data from a Tabular Report Datapage via the API? Or even export it?
  21. 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
  22. 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...
  23. I have separate search form and results datapage on one webpage. Is it possible to move the download data button, currently at the top of the report datapage, over to the search datapage? I've tried using CSS, but can't seem to escape the report datapage boundaries. I've also tried to extract the appSession link that's attached to the download button (using inspect element in Firebug), and assign it to a button I created on the search datapage. This worked for a short while until I realised that the appSession link is only temporary, so my download button on the search datapage stopped working the day after! Is there not a more permanent link for the datadownload that I can apply to a button? Thanks for any guidance.
  24. 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???
  25. I'd like to make the format of my list report look nicer, how can I do this? Specifically, I'd like to be able to highlight every other row of data (not data cell) and align the labels and the data so that they are directly underneath each other. Edit: Additionally, it would be nice if I could have conditional formatting on the data so that if it is below the goal, the text turns red and if it's at or above the goal the text turns green. The data cells are using calculated fields. Is there a way I can do this conditional formatting in an HTML block that references the calculated field?
×
×
  • Create New...