Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

831 profile views

georgep's Achievements

  1. That was really helpful and an eye opener. We have now got the height sorted. Many thanks Sandy159 Our last issue however is to do with field length. In the screenshot above the Display Only fields match the length of the normal Text Filed (one with white background). Hoever if all fields within a section are Display Only then they dont get forced to match page size. Is there any way round this? G
  2. We are looking to have a responsive datapage form that includes a mix of normal Text, Calendar and Text Area fields etc - alongside an equal number of Display Only fields. Our issue is that whilst you can style fairly readily the other fields it's not so easy with Display Only fields. We would like a box round our Display Only fields to highlight that their contents is data (as a deafult in Capsio it just shows as plain text and is confusing round what is the field name and what is the data). Our plan was to use a boarder box to surround the data. We sort of got this to work - m ostly - with CSS. However we note that when the field is empty the border collapses to a very narrow box. You can see this in our screenshot below. The field "Staff Grade" is just a narrow box as it has no content. Does anyone have any ideas or work arounds for how format this field so it will display like the others when blank or with content? George
  3. Unfortunately we need this to run ad-hoc i.e on indiodual records at any time. We already use a button within the original record to link to a Submit Form where we can poipulate most fields with the values from the original record. Its just the file field that is the problem. Seems to be locked at a Caspsio level. But please other ideas v welcome.
  4. Thanks very much for this idea. I will certainly test. G
  5. We have a requirement to in essence; duplicate some records. We currently use a URL link to feed a new submit form with some of the essential details in the original record. So the new record is created from clicking on the URL link one you are in the original. It works fine as long as there ere not too many fields to copy across. However one field we would dearly like to copy across is the file field. Does anyone have a method for doing this? I was wondering about using a SELECT Statement off the table with matching it to the original record. But it seems you cant do this with a File field. Anyone with any ideas? Thanks. George
  6. This seems to be still an issue. Does anyone know any workarounds. We have had reports of users with iphones turning off cross-site tracking etc but still being presented with a login form at each and every screen...? Tim
  7. 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...
  8. 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
  9. 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
  10. 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 :-)
  11. 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
  12. 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.
  13. 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
  14. 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
  15. 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>
  • Create New...