Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

VincenzoCocciolo's Achievements

  1. Hi all Is there a way to create a link that directly open the Details page of a Report page item? Something like... https://<myid>.caspio.com/dp/<caspio appkey>/<maybe something here to open the Details page>?<uniquefield>=<uniqueid> or better... https://ca123456.caspio.com/dp/148900002d8e3850ac6a43c49b1/ShowDetails?UniqueField=123 Thanks in advance for any tips Regards
  2. I'm pulling my hairs since yesterday. In a Submission Form I'm tring to poplulate fields or virtual fields with currency or Numbers stored in other table via SQL SELECT. It always return zero! I tried "most" combinations of SELECT CAST or using the Converter Formula but nothing!!! If I change the SQL SELECT inserting fixed values in the WHERE fields works . What did I miss? This Works! This Return Zero
  3. Hi all Is possible to define a Dynamic App Parameter? As an example define a "CurrentYear" App Parameter with a formula And so use "Current Year" as default value in a filed od a Submission form Thanks for any tips
  4. I'm trying to download one of the file stored in my Application and then place inline the content to a IMG elementi in my HTML page. This is the best I did. As a result the "data" contains a binary version of the image but the image in the html page is broken. Any helps is more than welcomed! $.ajax({ url : 'https://c2acw022.caspio.com/rest/v2/files/3512fabc-6f52-464b-ac9f-8bf0c3078773', type : 'GET', beforeSend: function (xhr) { xhr.setRequestHeader("Authorization", "Bearer " + accessToken); }, success: function (data, textStatus, jqXHR) { var base64data=btoa(unescape(encodeURIComponent(data))); $("#Logo").attr('src', 'data:image/png;base64,' + base64data); }, error: function (jqXHR, textStatus, errorThrown) { // do someghing else } });
  5. Thanks for the answer. The issue was that I embedded the caspio page in a iframe of an Html page shown in a iframe. I solved using eliminating one of the frames
  6. I added the followin HTMLBlock in a datapage to open a web page inside a iframe <a href="[@app:AppUrl]CaspioLP.html?page=JobOrderDetail&amp;obj=JobOrder&amp;oid=[@field:JobOrderID#]" target="InnerContent">Details</a> The link works but its not opened inside the frame but is dispayed in fullscreen. This is the HTML of the iframe Any tips? regards
  7. Hi everyone I made some experiment but didn't fine a way to show a Bootstrap modal windows with some parameters from the calling page passed. No problem in showing the modal window (except for the responsivness but I'll address later) But any parameter passed to the URL in the HTML Block of the calling page is not received. Is there a best practice on this? On the other end is there a way to use Session parameter or a more Javascript method ? Regards
  8. I just discovered that use the <iframe> deployment method instead of the <script> greatly helps this aspect
  9. Hi. I'm creating my Web frontend using a common Bootstrap tool (Bootstrap Studio) and I need some tips in order to better embed the Caspio script inside a Bootstrap card. I'm trying to force Caspio so show the DataPage in mobile mode but it keeps to "escape". I managed to add an horizontal scrollbar in order to correct the unesthetic overflow effect but didn't find a way to show the page in mobile mode. Regarding the code. Here a glimps of the Row, containing 3 columns and inside the last column the card where in the card-body is presente the <script>...</script> (not visible) Any hint? Regards
  10. Hi All I created a Report Datapage and added to the Result table three different Aggregate fields. The calculation is correct but unfortunatelly they are positioned in three different rows. See the picture. Is possible to have all of them in a single row without the labels? or, in alternative, if I use a HTML block can you suggest the JS to use? Regards
  11. Hi, I'm trying to add a nice user picture in my app. I added the image file in my Login table and created the Authorization object. Now I need to place the correct image HTML tag into my HTML Block of a certain Datapage. I have the image parameter: [@authfield:Login_Picture] And this is the standard HTML Image tag <img alt="USer Picture" src="???????????" style="width: 50px; height: 50px; margin: 1px;" /> How to compose the correct link? I also found a similar 2008 question but the solution didn't works Thanks in advance for any help
  12. Hi all I created my first "complete" database application with Caspio. I used different Authorization object each one for the different roles and assigned to different Data Pages On the other hand I have a Bootstrap template Web App that provide a Login Page, a Home Page and all the other pages. I managed to create a Simple HTML Datapage connected to the broader Authorization object created for all user. I also added a redirection to my Home page at succesfull login and also a Logout link. Everything work correctly : The user access the login page, enter the credential and so he lands on the Home page. The problem arise when he try to open a datapage that is connected to a different Authorization object. The page propose another login even if the user have both the authorizations Is there a way to solve this issue? Regards
  • Create New...