Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by mdupras

  1. Thanks, DN31337! I did try that early on, but that feature doesn't seem to be available in grid-edit mode, only details page and single record.
  2. Hello — I have a similar need and attempted (and failed) to modify this code for my purposes. Hoping someone here can help! We have a school closings list on our news website, which has 2 different Caspio forms for doing updates. One is for the schools themselves, and the users can only access a single record. The update form is simple — the user can change the "Status" of the school (Open, Closed, Early dismissal, 2-hour delay, etc.), plus there's a text field for additional notes. A school doesn't display on the listing if the status is "Open," so to prevent a school from inputting notes that no one will see, this JavaScript prevents the user from adding notes if the status is "Open." It also empties the "Notes" field is the status changes to "Open": <script type="text/javascript"> document.getElementById("EditRecordschool_close_notes").onclick = function (){ if(document.getElementById("EditRecordschool_close_status").value == "Open") { document.getElementById("EditRecordschool_close_notes").blur(); alert("To input notes, please select a different status."); } else { document.getElementById("EditRecordschool_close_notes").focus(); } }; document.getElementById("EditRecordschool_close_status").onchange = function (){ if(document.getElementById("EditRecordschool_close_status").value == "Open") { document.getElementById("EditRecordschool_close_notes").value = ""; document.getElementById("EditRecordschool_close_notes").blur(); } else { document.getElementById("EditRecordschool_close_status").focus(); } }; </script> The other form is for in-house use, and the user is able to edit all records. The fastest way on deadline is to use "Grid Edit." I want to add this same functionality to that form — to only allow notes when the status is not "Open," and to empty the notes when the status changes to "Open." As I said, I attempted to modify the code George43 provided in a few different ways, but no luck. Any help is greatly appreciated. Thank you! — Mike
  3. It does -- thank you! I'll give that a try. -- Mike
  4. Thank you Barbara! I was able to customize the icon and label, but yes, it's the formatting of the labels (font, etc.) and the header that I'm looking to alter. Thanks for looking into it for me! -- Mike
  5. Hi all -- I'm using the new map mashup for the first time and looking to figure out how to customize the appearance of the clickable category filters for the map -- i.e. the font, size, wording of the label, etc. I've pored over the style and localization files but haven't found anything that seems connected to this. Here's a screenshot of the area I'm referring to: Thanks! -- Mike
  6. Thanks everyone for the help. For a long time, the Map Mashup 7 instructions indicated that Google would only plot 10 or so non-geocoded addresses. Today, I noticed the information changed, to say "no more than 10 per second." Also, I think we had an outdated API key. So solves part of our problem, but yes -- non-geocoded loads painfully slowly ... Mike
  7. Yes, using Google with the Map Mashup v7 is an option, but as I mentioned the problem is requirement that the data be geocoded. Some of these datapages have tens of 1000s of records -- or even hundreds of 1000s -- and are updated reguarly, so I need to find a solution that doesn't require paying for batch geocoding. Has anyone attempted to create a mapping extension similar to the "old" map mashup using MapQuest rather than Google or Yahoo? Mike
  8. We have several DataPages using the "old" map mashup JavaScript extension with Yahoo maps. Just last week, the maps on all the pages stopped functioning (locates just one point, out in the middle of the Atlantic Ocean -- all maps behave the same). After a little bit of hunting, I found news that Yahoo's maps API was shut down about 2 years ago. However, ours all continued to function until just this week. So on one hand I assume this is why our maps no longer work, but on the other don't understand how they could have continued to function fine all this time. Switching to Google maps is problematic. They now require geocodes, and the DataPages in question have 10s of 1000s of records -- geocoding that data through a service would be too costly for our organization. Anyone have any insight on this issue or resolved the Yahoo maps quandry in some other way? Thanks for your time! -- MIchael Dupras Syracuse Media Group Syracuse, NY
  9. Hi Angela -- The problem seems to resolve itself. I've seen it happen again since posting this query, then later the pointers are back again. Some kind of glitch? Not sure, but it doesn't stick around. -- Mike
  10. Hi all -- I recall in the past that Caspio has provided Census data, either pre-built tables or even DataPages that could be edited and customized. Is that the case with this year's data release? I can't find any information on the Caspio site. Thanks! -- Mike
  11. Just saw this post. No, it looks like another user copy and pasted an older comment from me that I had posted while it was still an issue. Strange! -- Mike
  12. Well, that's puzzling, but it's good news! Thanks for helping me troubleshoot! -- Mike
  13. Yes, we saw that error, too. But we were having the problem even when we removed it from the page entirely. You said it's working properly ... you're seeing the red "pushpins" on the map when you do a search? -- Mike
  14. Interestingly, I've noticed the same problem when looking at Caspio's own Yahoo map mashup example on their site. Could someone take a look at this link in Internet Explorer and post whether you get the same results (no pointers)? http://apps.caspio.com/demo/ygolf/ Thanks! -- Mike
  15. Unfortunately, swapping in the latest mashup code had no affect. Still no pointers. We also tested posting the entire Caspio code block on an entirely blank document, with none of the site's coding, furniture, style, ads etc., to make sure nothing was conflicting. Same result. Any other ideas? Thanks! -- Mike
  16. Me, too -- thanks! I noticed that the code was outdated after I posted this topic. I've asked our web developers to replace it. We'll see if it works. Oddly, there were no issues as recently as yesterday, but I'm assuming this newer code has been available for awhile. -- Mike
  17. Hello -- We have several mapping databases on our news site that until a couple days ago, worked flawlessly. We discovered today, however, that in Internet Explorer, the map pointers are not displaying. Here's a link to an example. Do any search in IE to see the problem: http://www.syracuse.com/crime/police-reports/ Nothing has changed in the Caspio code. Not sure if something on the rest of the page could be affecting it. Any ideas? Thanks! -- Mike
  18. mdupras

    Hiding the header

    That's it, or something like it! I just gave the header a and then customized the error message to hide that ID. I think I've actually done this before but just forgot how to do it ... thanks! -- Mike
  19. Is there a way to hide the header, for example, on a search and report error page when no results are found? -- Mike
  20. I have HTML code in the field data in a table that I'm trying to get to render as HTML when displayed in the header or HTML blocks but it will only render as regular type. The information is links, so it's different for different records -- I don't see a way to easily do it dynamically. It needs to display just once in the header, so I don't want to pull it in the results as a normal field, where I can manually select it to render as HTML. Is this possible? Thanks! -- Mike
  21. Hi all -- In a previous post, I asked about a block of code that "went bad" on me and stopped working. The code was part of a larger error-checking process in a real estate transactions database that gives alerts if you've selected an incorrect date range (among other checks). Part of the code runs a check when you use the calendar pop-up to fill in the date vs. typing in the box. Here was the original code: function dateClickStart () { document.getElementById('caspioform').Value5_1.focus(); if (document.getElementById) {if(document.getElementById('Value5_1')!= null){ try {v_cal.select(document.getElementById('Value5_1'),'a1','MM/dd/yyyy');return false;} catch (e) {}}}; } function dateClickEnd () { document.getElementById('caspioform').Value5_2.focus(); if (document.getElementById) {if(document.getElementById('Value5_2')!= null){ try {v_cal.select(document.getElementById('Value5_2'),'a2','MM/dd/yyyy');return false;} catch (e) {}}}; } document.getElementById("a1").onclick = dateClickStart; document.getElementById("a2").onclick = dateClickEnd; "a1" and "a2" are references to the calendar pop-up, but when I run Firebug to see how the pop-ups are referenced, it appears to be dynamic -- i.e., with IDs and names like "a1_963361391." When I remove this code block, the rest of the code works, and the error that shows up on this code says "a1 is null" which tells me I'm not referencing the calendar pop-up correctly. Any ideas? Thanks! -- Mike
  22. Thanks! I do have Firebug but must not be too savvy with it as I haven't been able to figure out how to get it to show me script errors! At any rate, you're right: When I remove this bit of code, the rest of it works: function dateClickStart () { document.getElementById('caspioform').Value5_1.focus(); if (document.getElementById) {if(document.getElementById('Value5_1')!= null){ try {v_cal.select(document.getElementById('Value5_1'),'a1','MM/dd/yyyy');return false;} catch (e) {}}}; } function dateClickEnd () { document.getElementById('caspioform').Value5_2.focus(); if (document.getElementById) {if(document.getElementById('Value5_2')!= null){ try {v_cal.select(document.getElementById('Value5_2'),'a2','MM/dd/yyyy');return false;} catch (e) {}}}; } document.getElementById("a1").onclick = dateClickStart; document.getElementById("a2").onclick = dateClickEnd; Trouble is, I can't remember what this code does exactly or where I got it! I do know that the error messages with the calendar aren't working exactly correctly. Any clues? Thanks! -- Mike
  23. Hi all -- I have a real estate transactions database that allows users to search date ranges and selling price ranges. When I first created the Caspio datapage, I wrote Javascript that prefills the date range and also checks for input errors when the user chooses a new date range or sale price range. If the user chooses a "from" date that comes chronologically after the "to" date, they immediately get an error message when they click off the input box and the dates are re-set to the default settings. Same when they're selecting a price range from the drop-down menus: if they choose a starting value higher than the ending value, they get an error alert and the range is re-set to the default. As an extra check, the script also checks for comparison errors when the form is submitted and doesn't submit if there's an error. At least, that's what's supposed to happen ... All of this was working beautifully at one time, but I just discovered that somewhere along the line, the code stopped working, and I can't figure it out. There's too much code to paste it all here, but here's an example portion -- this checks the selected sale price range for errors: function checkPriceLow() { var startPriceLow = document.getElementById('caspioform').Value6_1.value; var endPriceLow = document.getElementById('caspioform').Value6_2.value; var minPriceLow = parseInt (startPriceLow); var maxPriceLow = parseInt (endPriceLow); if (minPriceLow > maxPriceLow) { alert("Minimum price must be lower than maximum price. Please make another selection."); document.getElementById('caspioform').Value6_1.value=0; } } function checkPriceHigh() { var startPriceHigh = document.getElementById('caspioform').Value6_1.value; var endPriceHigh = document.getElementById('caspioform').Value6_2.value; var minPriceHigh = parseInt (startPriceHigh); var maxPriceHigh = parseInt (endPriceHigh); if (minPriceHigh > maxPriceHigh) { alert("Maximum price must be higher than minimum price. Please make another selection."); document.getElementById('caspioform').Value6_2.value=999999999; } } document.getElementById('caspioform').Value6_1.onchange=checkPriceLow; document.getElementById('caspioform').Value6_2.onchange=checkPriceHigh; Here's the direct link to the Caspio datapage I tried changing references such as "document.getElementById('caspioform').Value6_2.value" to "document.getElementById("Value6_2").value" but that didn't work. Any ideas? I'm stumped. As I said, at one time, this code was working just fine. I can't imagine what would have changed ... Thanks! -- Mike
  24. Hello -- I'm unfamiliar with the automatic email notification feature and have a question. Let's say I had a table of 50 records -- could I set up a different email address with each record so that only that particular email address would be notified when only that particular record is updated? -- Mike
  • Create New...