Jump to content


  • Content Count

  • Joined

  • Last visited

About georgep

  • Rank

Recent Profile Visitors

683 profile views
  1. I would love to know how we could do this too. One would have thought that this could be made possible either in S3 or an alternative service...
  2. very sorry for late reply. Have been off ill. But have just tested this and it works great. Thank you very much - much appreciated. George
  3. MayMusic thanks for coming back. We have been asked by a potential client about doing a service app but they wnat 2 factor authentication or at least similar. A simple password wont cut it for them I am afraid. I was wondering if there were any Caspio solutions that used token or secret questions etc that could be made part of the login? George
  4. Wow. Am getting a bit confused. We have a script that where if a field value is NOT blank it displays an icon on the screen. The field contains a URL link to a webpage elsewhere in our app. The icon is just a PNG file (the img scr in script below) which is itself clickable to the web-link URL that is the contents of the field (the field will always contain a URL value - or not). It has functioned fine for a couple of years now Our (old) Script is as follows: <script> if ('[@field:XXXX]' != '') { document.write('<a href="[@field:XXXX]" target="_blank"> <img src="../resources/File_icon_INS.png" alt="Files" height="40" width="40" /></a>'); } </script> We know we need to change it with the new async deploy code and to replace the document.write part with innerHTML. However what we have tried has not worked. Would love it if a kind person could help us out. Thanks :-)
  5. We are looking t develop an app where we would like users to on login be forced to submit to a security question along the lines of: EG: Please submit letter [3] of your secret passcode? Please submit letter [5] of your secret passcode? Idea being that we could use a script to randomize the letter number requested and that the app would do security look up the passcode and only allow login once it had a match. Does anyone have any ideas round this. If anyone has looked at this and has a workable alternative please share. Thanks George
  6. We found a solution of sorts for this so just adding by way of update in case anyone else looks at this. The Calculated field did not work for us we ended up finding that its is not easy concatenating a text area field and w test field. Capsio Support did have some work around but it did feel like we were likely to end up with issues with this method further down the track. What we did do though is look at bulding our Notes on trhe fly and using Bulk edit to provide field values with which we could concatenate on the users screen. In this way what we have been thinking of as 1 large Notes Text Area field became 3 smaller fields appended at the beginning of the main Notes Text area field. Using html we displayed this within a sin gle panel to give the effect one single field re contents though it was actually 4 fields in one. When looked at in a details screen on update we justed some JS to take the 3 smaller field values and then add then to the bigger Text Area field and then black them out. The next effect was that we could provide a Bulk Update that looked as if it could insert text values into another field (the Text Area one) across multiple records when can then be updated with further individual items at a later date. Morale by looking at issue the other way round we were able to come up with a solution. Its not tidy but it does work.
  7. We have not as yet been able to fix. The new facilities just launched with ver 9.6 are almost there for us. Sadly however we need the ability to be able to select from a table/view. That feature is not on this release. We also need to be able to use it in a cascading manner. So whilst the platform is clearly advancing we don't have a solution - yet. Do wish you all the best in your hunt. If you find a solution please do let me know :-) George
  8. Mathilda, thanks for an an interesting answer. Our problem with this app is that we only need to update when a field value changes + we need to keep a running record of changes over time. The problem with using a formula field at table level is that it would allow us to capture a Status change from one bulk update and we could have the formulae field show the date concatenated. However if there is a further update say in a weeks time then this will simply overwrite the values and we would miss the details of the transaction that happened on first bulk update. Sad to say but I am still stuck with this. But thanks for coming back. Any further ideas and I am all ears :-) George
  9. Mathilda I am also keen to use some JS to concatenate two fields within an inline edit. Tried using your script with some changes and not able to get it to work. Could not even get an alert to fire so something is way wrong. Was wondering re the div wrapping. Am I able to put those in the Header and Footer? Any help you can give would be v gratwefully appreciated. George My alert testing script was: <script> $("#cbform-improvement #Mod0InlineEdit").click(function(e){ alert ('hello'); } ) </script> ------------------------------- The actual script I would like to use is: Where "TP_Applications_Outcome" is the result of a cascading dropdown. "TP_Applications_Internal_Notes" is a text Area field holding just text for di0laying in html i.e. with tags on details screens. <script> $("#cbform-improvement #Mod0InlineEdit").click(function(e){ var outcome = $("[name=InlineEditTP_Applications_Outcome]").value; var notes1 = "[@field:TP_Applications_Internal_Notes]"; var auth= "[@authfield:Username]"; var notes2 = "(" + auth + ")" + " Stage Changed to: <b>" + outcome + "</b><br><br>" + notes1; $("[@field:TP_Applications_Internal_Notes]").val(notes2); } ) </script>
  10. We have a requirement for our Users to be able to update v quickly a large number of records within a tabular type report. The Bulk Edit/Update on its own wont work for us as we need to - when updating each of the records - to concatenate two Notes fields together along with a system date within each record and update another field. We can do this quite easily with JS in aa single Details Page (simple JS concatenating the two different notes values and adding today's date). However this approach does not seem to work on the Bulk Edit/Update - as whilst we can change a common field value across multiple records we cant get JS to individually do a concatenation in each of the records involved. Am really interested in any ideas for this. Our latest thinking - please comment - is to use a Tabular report of searched records to display in std tabular form to the User. But to have an HTML block at the end that has a URL link they can click. This would open some kind of hidden web window/tab containing a Details record that we can apply the JS to (as advised above) for concatenating the two Notes field values and the date within each record. We have not quite got this to work and I would be really interested in views from this Forum. A key stumbling block is to arrange for a Parameter value that can be selected once - whilst at the Tabular report - and then reused/retained as the User works his/her way down the list by clinking on the link quickly opening/closing a Details form (using Auto Submit?). This parameter value we use to update a field with the records status. It and the values of the Notes fields that we concatenate and then update another field and really the record changes we are trying to accomplish. We have tried using a second datapage with a dropdown of the values that would hold a parameter value to pass over. However it loses its value after the first click. We were wondering if we could have somekind of dropbox field that we could set once and which would then keep its parameter value held whilst the User was clicking the html link block on the Tabular report and then activating the hidden web window/tab with the Details record. Any ideas from you experts out there :-)
  11. Yes - however I have picked up that issue appears related to Chrome version 54. The popups still work on Safari etc. As I understand it Chrome will simply no longer enable refresh of a parent window from a popup. Its real shame as was quite a nice way of working. What I have done is have parent open a new URL on top i.e replace it with what would have been the popup window and once the "popup" (i.e new URL page) has had its info added it would then return to the original parent URL and thus provide a refresh. It works in all browsers I have tried but not quite as slick as using the popup. If however you have a method that woudl work please do adviser :-)
  12. I have the same problem. Was working and now doesnt. Big issue for us. Love someone to come up with a suggested fix?
  13. Thanks Aurora. Sorry I should have thanked earlier. Do appreciate the help. George
  14. Thanks for replying MayMusic. Yes we can do multiselect of a Listbox. Our issue is with Cascading Listboxes. We need to first use a listbox (or drop-down) to select one variable then based on that present a list of options and have the user multiiselect from that list i.e in a Cascading Listbox and then be able to at a later date amend their selection in an Update form. Be v grateful for any ideas or work around as we are finding its a big limitation with the Caspio Platform. George
  15. I had this problem also and go the following from Support as a fix for the Responsive Code you put in the header. Issue was that Caspio styles were being overwritten in the website css. Hope this helps. George Please replace the code below (from your Header): #datapage-form img[alt~=Calendar] { position: relative !important; left: -19px; top: 4px !important; z-index: 10000; } With this code: #datapage-form img[alt~=Calendar] { position: relative; left: -19px; max-width: 100px; } It seems the code below from your style sheet (consolidated-all-80.css) is the issue: img { border-style: none; max-width: 100%; height: auto; }
  • Create New...