Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by georgep

  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>
  16. 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 :-)
  17. 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 :-)
  18. I have the same problem. Was working and now doesnt. Big issue for us. Love someone to come up with a suggested fix?
  19. Thanks Aurora. Sorry I should have thanked earlier. Do appreciate the help. George
  20. 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
  21. 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; }
  22. Thanks for reply. Unless you know otherwise I need the number of pageviews to be held within Casio. I am not aware you can pass this info across to Capsio but perhaps you can - if you know how please do advise. In basic terms we are looking to increment a counter held in a table each time a particular page is viewed. I know you can get php counters for websites etc but I need the count held in capsio. Sorry if I did not explain this clearly. Thanks for reply and if you know how we could do this please advise. We got a second datapage to do the count but ran into problems with the autosubmit which went into a loop. The main datapage we are trying to count pageviews on is a details page with its update button removed in localization. George
  23. Wonder if anyone has an answer idea for this. We are trying to track page views of a website with an embedded Caspio report. In essence we are trying to track the number of people who visit the page. This report is just read only - we have used localization to remove its update button. Our idea was to have a second datapage on the webpage which would run some basic js that would increment a count every time it was submitted - we had though we would use the autosubmit script to run the function, as so: setTimeout('document.getElementById("caspioform").submit()',1); However issue we have is that if we include the autosubmit script the function simply starts looping. We were wondering if the fact that we have two datapages was confusing things. That said if do have two how could we differentiate and just get the second one to run once when the webpage loads. Anyone done something similar or got any ideas? Thanks george
  24. We have an App that ideally we would like a user to be able to use the Bulk Edit facility to amend a value within a field and have this applied to all applicable records. So far so good. But we also need that value added to another notes type field within each of the affected records. In other datapages we use some javascript to concatenate the "value" to the notes field - you press Update and it all works great. Ideally would love to be able to do this with a Bulk Edit facility. However we have tried it and it did not seem to work. Perhaps the JS just wont work in this setting. Anyone any ideas for how we might achieve same or similar effect? George
  25. I too would be interested if this could be done. Seems like a very useful facility - if anyone has any ideas would love to hear. G
  • Create New...