Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by sdi126

  1. If I understand correctly this should be the javascript you need: <script> window.onload = function(){ currentTime = new Date(); currentHour = currentTime.getHours(); document.forms[0].Value3_1.value = currentHour; document.forms[0].Value4_1.value = currentHour; } </script>
  2. Well I can say it is definetly possible as I just did it (http://bridge.caspio.net/dp.asp?AppKey=faae0000f3a4h3e4j7e4c3f4e2j4)...it is rather hard to explain but I will try I used three tables Table 1: Holds the days of the Week (Sunday - Saturday) They are uniquely identified by a number (0-6) 0 is Sunday Table 2: Holds the restaurant information and a number field that uniquely identifies the restaurant. Table 3: Holds the days and times a restaurant is open. There is a field for the start time There is a field for the end time There is a field for the day of the week (from table 1) There is a field to tell you what restaurant this is (id from table 2) A view is created to link all of this information together as if it is all in one table. The caspio datapage is a search and report (with advanced options and parameters turned on) Your datasource will be the view you created based on all three tables. You will be configuring a search form with three hidden fields one for the start time,one for the end time, and one for the day You will need to use javascript to dynmically determine the current date and time when the user visits the page and use this information to update the hidden fields and submit the form. So basically when you have the javascript telling you the current hours you can make your query say greater than or equal to the start time and less than or equal to the end time and the day = day to return the proper restaurants that are currently open...wow I'm sure this makes no sense. Maybe it will spark further discussions!
  3. I am not sure exactly how you have a link to a new page. Is it configure on the web page itself or inside a caspio datapage? The basics of the link code would be: <a href=\"url\">Text to be displayed</a> To make your link open in a new page you would add: <a href=\"url\" target=\"_blank\">Text to be displayed</a>
  4. Do you have a link that currently opens this webform? If so the property you are looking for is called target. By changing the target you can specify where the page opens.
  5. I don't think your dreaming I think you just need to look into this plugin: http://howto.caspio.com/extensions/casp ... ms-office/
  6. The size property will most likely require modification as well....in your drop down can you see more than one option or do you just see one and get the down arrow to select others? Please provide a url to the page your developing...this makes it much easier to supply you with the correct code needed
  7. On the page where you are defining the fields that you will be editing you need to add a header and footer element to the page. In the footer put the following code. <script type=\"text/javascript\"> document.getElementById('Mod0EditRecord').value =\"YOUR CUSTOM TEXT HERE\"; </script>
  8. very cool (I see that the purchase link is pulling a custom url now)!
  9. Looking at that....the tags that say doesn't belong. I will ask you to please provide a link to the page your working on (that doesn't work) so I can tell you exactly what the issue is.
  10. Why do you have to make it harder That can be done also but requires more custom javascript coding. I can assist with this and your other posting about calculating values. Please message through my website for more information.
  11. I could have sworn I replied to this already :?: ....oh well You need to enabled advanced options and parameter(at the beginning of the caspio wizard)...these are checkboxes. When you are configuring the fields you want listed in your results you are going to add a new \"html block\" this is an option at the lower left below all the fields you want on the page....in the newly created html block you will add the custom code that you have that builds the button link. Then all you need to do is replace the values you need from the table. You access the variables like so: [@field:nameOfFieldAsItIsInNamedInTable] replacing nameOfFieldAsItIsInNamedInTable with the appropriate value.
  12. If you don't want that column simply remove that html block from the results page. It isn't needed unless you want the map on the results page as well.
  13. First I will start by saying.....anything is possible But to make sure I understand what you are asking. You have a Caspio Search and Report datapage (and its working to your liking) but you want some custom coded buttons to take you to the details page (this is not a Caspio datapage) for a particular product?
  14. You need to view source on that datapage from within Caspio Bridge to find the unique ID for that field. It will most likely be called InsertRecord_listDomain but you need to verify this. In the view source the html code will be something similar to Whenever you can determine what the value is for the ID property of the hidden element than adding on to your javascript is easy. The code to add will be var litesDomain = document.domain; litesDomain = litesDomain.replace(/^www\\.|^test\\.|^dev\\./, \"\"); litesDomain = litesDomain.replace(/\\.com$/, \"\"); document.getElementById(\"UNIQUEVALYOUFOUNDINSTEPONE\").value = litesDomain; so replace UNIQUEVALYOUFOUNDINSTEPONE with most likely InsertRecord_litesDomain but again verify this
  15. Well for one I don't think such a license exists for a google maps API key and two even If I were to know what the key was it wouldn't help me in any way as it relates specifically for your domain only So without seeing the code (assuming all instructions were followed) and the code is correct you are absolutely right (you should see a map (at least a blank one without any plots on it)). Sometimes it might happen that there are other issues with html currently on the page you are trying to embed the map. Since I can't see the code to tell you the exact issue the only suggestion I can make is to put the map on its own blank html page and see what happens....if its still blank then we have some coding issues.
  16. You use javascript to \"put\" the variable into a caspio hidden field....which will submit with the form. Say your table has a field to hold the domain (it better) so include this as part of your form (make it hidden)....your javascript code you have sounds like it works to get a domain name...use javascript to set the hidden form field for domain to that value
  17. It doesn't need to be part of the field selection screen but needs to be referenced correctly in the javascript code. Please provide a link to your map that is blank for troubleshooting help.
  18. Making the listbox select multiple is a pretty simple thing to do....but when it comes to breaking down everything they have selected and configuring the search to return the right results...well that becomes VERY complicated unfortunately.
  19. It is not neccessary to create all these datapages. It can be done in one. My second paragraph on my previous posting is a high-level (here's how to do it) answer
  20. I wouldn't suggest passing it (depending on how accurate you want your results) in because it can be easily changed that way. The javascript code that gets the root domain should be included in the footer of your datapge. Configure this same datapage to include a hidden field and use some more javascript to update that hidden fields value with the root domain. Again although I don't recommend it and I don't think Caspio was intended to even pass parameters through their embed code (it can be done)
  21. sorry for the delayed response....in the last part of the instructions where I had you put InsertRecordOffice change that to be Value2_1 so it would now look like this: Enter selection
  22. Don't see the link on your example page...unless its a different link...can you put it back up and I will look at it
  23. Okay here we go! You will be editing the section where you have configured this form. If you do not have a header/footer section you will need. This code goes in the footer function changeInputType(oldObject, oType) { var newObject = document.createElement('input'); newObject.type = oType; if(oldObject.size) newObject.size = oldObject.size; if(oldObject.value) newObject.value = oldObject.value; if(oldObject.name) newObject.name = oldObject.name; if(oldObject.id) newObject.id = oldObject.id; if(oldObject.className) newObject.className = oldObject.className; oldObject.parentNode.replaceChild(newObject,oldObject); return newObject; } You will need advanced options turned on. Below your drop down you have configured do the following: Add a new virtual field Remove the label Set the form element to display only Render value as HTML Check the box enable all html tags Click the advanced tab Enable assign static text radio button and put this code in it Enter selection test it out
  24. As im sure you have found out it is different to hide something on results because there is no reference (\"ID\") to hide the element with. Since the results page comes out in a table what we have to do is find the row then cell and hide that....a little more difficult but not too much. So are you wanting to hide one value in the results page? How many rows do the results come out in? Is what you want to hide repeated multiple times?
  25. Get your page all configured to where you have your prefab list working and searching how you want it and then let me know when that is done and we can walk through adding the additional code to make a cool custom search
  • Create New...