Jump to content

TWIRED

Caspio Ninja
  • Posts

    81
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by TWIRED

  1. Hi , you could try this.. var x; if (x =='') or (x !=='') The element must not be hidden for it to work. you have to trick it var newone; newone = document.getElementById('InsertRecordCHKBOX'); if (newone == null) { newone=0 } Hope this helps. Thanks
  2. Hi if I have 2 Tables (Parent (PK) & Child (FK) ) in a relationship Is it possible to change / update the primary or foreign key ?? Normally this is how I do it in adatabase where I hvae access to everything disable enforcing PK or FK constraints temporarily update your PK update your FKs enable back enforcing PK / FK constraints
  3. I do not want the checkbox on the form to be displayed. But rather when the form is submitted succesfully, the field "RegistrationPart1_Complete" to be checked.
  4. Hi I have a multi-page forms form1 - after completion I need to send a hidden parameter to a field called "Registration1_Complete". The field is a Yes/No field. In the form i have a hidden field which hen submission completes needs to "Check" the field in the database I have tried various parameters in the On Exit to get teh database filed checked . like [@YES] , [@TRUE] Nothing seemd to work. Whats the parameter to get the field in the database checked. Thanks!
  5. Should I Be using an iframe and then embed my code in it to get the position I want? Wouldnt that be counter intuitive and defeat the purpose of using the embed code without iFRame? Thanks
  6. Ive been trying & experimenting with various hosting methods to settle in on a final one for my long term caspio project. I had wix, weebly, godaddy , which I abandoned due to the passing parameters situation. Now im hosting the site on my own office IIS server, as caspio support suggested would be the best bet for the long run. and I would have more control on the HTML. Im having a strange problem, -When i used wix, weebly etc using the embed code , I had perfect control of where i could drag ,drop or postion and display it on my page; -On my own IIS server, the datapage is displayed ONLY in the default corner on the top left hand corner. -If I use inline frame deploy code - it works perfectly. But obviously im trying to get away from that because of the passing parameters situation. Ive tried all sorts of div tags etc..using the deploy embed code, it just wont position itself where i want to - like in the middle of the page It just shows up in the top left hand corner. http://exitz.com/RegisterTA1.html
  7. HI I have a field in a submission form called "Website URL" It is validated with some javascript in the footer. If it has an error message I need to either a) modify the default "required" error message underneath the field or b ) have the error message show up on the top of the page in a label. ANy help would be pretty , pretty , pretty cool
  8. Hey thanks , i just used your script. I have it submit then innerHTML this tag in HTMLBLOCK 2 <p id="urlerror" > </p> http://www.tripatwork.com/register-a-travel-agency-1 The issue is after the error shows up in the <p> tag it disappears. Any help would be appreciated. Thanks ! [Altered Script slightly] <script> function v_url(){ var myRegExp =/^(?:(?:https?|ftp):\/\/)(?:\S+(?::\S*)?@)?(?:(?!10(?:\.\d{1,3}){3})(?!127(?:\.\d{1,3}){3})(?!169\.254(?:\.\d{1,3}){2})(?!192\.168(?:\.\d{1,3}){2})(?!172\.(?:1[6-9]|2\d|3[0-1])(?:\.\d{1,3}){2})(?:[1-9]\d?|1\d\d|2[01]\d|22[0-3])(?:\.(?:1?\d{1,2}|2[0-4]\d|25[0-5])){2}(?:\.(?:[1-9]\d?|1\d\d|2[0-4]\d|25[0-4]))|(?:(?:[a-z\u00a1-\uffff0-9]+-?)*[a-z\u00a1-\uffff0-9]+)(?:\.(?:[a-z\u00a1-\uffff0-9]+-?)*[a-z\u00a1-\uffff0-9]+)*(?:\.(?:[a-z\u00a1-\uffff]{2,})))(?::\d{2,5})?(?:\/[^\s]*)?$/i; var urlToValidate = document.getElementById('InsertRecordTagWebURL').value; if (!myRegExp.test(urlToValidate)){ //alert("Incorrect Web Site URL entered !"); var oldHTML = document.getElementById("urlerror").innerHTML="Website Address is Invalid ! "; var newHTML = "<span style='color:#ff0000;font-family:Arial; color:Red; font-size: 16px'>" + oldHTML + "</span>"; document.getElementById('urlerror').innerHTML = newHTML; //return false; } } document.getElementById('Submit').onmouseclick = v_url; </script>
  9. is there a way to through a single form enter the captured data in say 2 different tables. Im trying to avoid the multi-page solution. Would the answer be with virtual fields ? Thanks
  10. ok.. It depends on the requirement, ask yourself these questions. Can a client possibly , ever have multiple Financial Advisors ? > then you would have a many to many relationship Does a client ONLY have one , and only one (Always) - Financial Advisor ? > Then it would be a one (Financial Advisor) to many (Clients) relationship.
  11. Hi Neil, Im a Caspio newbie too and am at the same stage : testing out caspios advanced capabilities. My app needs are similar - Many Travel Companies > Many Travel Agents > Many Customers. The tables can be setup to be many-to-many by clicking on relationships, you can also setup referential integrity there. For what you want to do , it should be easily possible - but you have to plan your table design and test and learn all the front end/backend features before hand , to see how sprawled your app gets or how lean and efficient it can be made. Heres a video that might help as it addresses more complicated database setups / requirements. Multi Department with Role Permissions After a few weeks of experimenting and learning caspio, I think (maybe) the archilles heel for advanced app builders is: 1) it doesnt have direct access to T-SQl or stored procedures , it does have formula fields - but they are very limited. 2) Views should be able to somewhat solve the above problem - (like a temp fix) for Updating and working with multiple tables at once, but it then puts the onus on the front end design - which can require many forms and reports. Hence everything has to be built very linear. 3) You most probably will need to get into javascripting to complete a mature solid front end for more advanced stuff.It is reliant on it. 4) There is no single online manual where you can read and get going on the full specs of the formula field (backend) syntax or the calculated fields (front end). You have to watch many videos and glean your information. 5) The community forum and online help videos etc .. has some outdated info and links to older versions of caspio ,which can be misleading and time consuming sometimes, they need to associate the forum posts with the caspio version number so that people dont chase their tails with incorrect / outdated info. 6) Getting a clean detailed precise answer to a question can sometimes be forever or never 7) Lastly the howto videos and information are not updated and maintained properly, so it can become hours of watching loose videos, with no structured learning . It doesnt provide a governed way to plan the apps. This is just my 2 cents :)) I wish the information were more concise,detailed and precise on this forum as well as for the help material. That being said , I think Caspio is a wonderful platform to hammer out very simple to slightly complex web apps , it has the capability but the support is lacking or can get pricey or can take forever after sifting through mindless hours of videos. A step-by-step Online Manual which is :- Versioned, Indexed and Planned (including programming syntax -front end and backend) would help incredibly and also gain caspio a new flock of new customers. Thanks~
  12. STEP BY STEP HOW-TO MULTIPLE SELECT CHOICES IN LISTBOX ON UPDATE , DETAILS OR UPDATE REPORTS PAGES. ------------------------------------------------------------------------------------------------------------------------------------------ Make Changes in the script below --------------------------------------------------------------------------- Change mydbfieldname to whatever your database Field Name is Append “EditRecord” with whatever your database fieldname is Example : Change “EditRecordmydbfieldname” to “EditRecordyourfieldname” in the script. Paste the modified code below in the HTML Footer Section (Click on “Source” ) ------------------------------------------------------------------------------------------------------------------------------ Footer is available in the “Configure Details Page Fields” Section in DataPage using the Caspio Bridge DataPage Wizard. C) Configure your Field / Element ------------------------------------------------ Add your database field to the details page (in my example its “mydbnamefield” ) Change the element (mydbnamefield” Form Element to Listbox (In standard section > General Options) Choose Custom Values in Source Enter your Custom Values . Example : Air, Hotel , Cars In Advanced Section , SELECT “on exit” : Pass field value as parameter Enter [@mydbnamefield] as value or whatever your database field name is. Thats it ! Viola ! . Now you will be able to multiple select the values in the listbox on your page using Control +Click The Values will be stored in your database field name like this…. “Air,Hotel,Cars” as a string. This script below can be used (“As-Is”) SCRIPT FOR MULTIPLE SELECT CHOICES IN LISTBOX ON UPDATE , DETAILS OR UPDATE REPORTS PAGES. ----------------------------------------------------------------------------------------------------------------------------------------------------- <script type="text/javascript"> var v_state = "[@field:mydbfieldname]" ; var o_state = document.getElementById("EditRecordmydbfieldname") ; o_state.multiple = true ; function f_listbox() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state[i].value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options[i].value){ o_state.options[i].selected = true ; break ; } } } } } window.onload = f_listbox ; </script>
  13. read above - not yet solved thanks
  14. Pseudo Code - REQUIREMENT FOR Multi-Select Listbox in a Submission Form ON FIRST TIME LOAD - Read the values from the table field into a variable If field is blank - then dont do anything Just populate the listbox from default element custom values ON SUBMIT (SAME PAGE) -MULTIPLE VALUES SELECTED Store the “selected value”s from listbox in an array in a hidden element or a temp persistent variable or maybe a hidden virtual field ON ERROR - REFRESH If theres an error like other required fields are not filled in on form (The values are not yet committed to the database) Then Load the hidden element “selected values” array Match the variables array values with the drop down list element custom values and highlight or show them as selected
  15. Thsi is driving me crazy - Im not really a javascript programmer (Thats why i chose caspio) Ive been trying to create a simple multi select listbox , all the code links you guys submitted go to unavailable links like below. I have a simple text field in my db "AirHotelCars" , 1)I added 1 script I found to the footer 2) What are the exact step-by-step settings for the db field "AirHotelCars" field in "Configure fields" * some people mentioned make it Hidden ,what are the exact on load and exit settings for the "AirHotelCars" field? 3) I created a virtual field and modified the footer javascript. * some people mentioned make it Hidden ,what are the exact on load and exit settings for the Virtual1 field? Its not working and Ive spennt 2 days trying to figure this out. I cant believe Caspio does not have a simple solution for multiple select listboxes and check boxes. Thats as basic as it gets. Grrr Any help would be appreciated ! " The page you requested does not exist
  16. Pseudo Code - REQUIREMENT FOR Multi-Select Listbox in a Submission Form ON FIRST TIME LOAD - Read the values from the table field into a variable If field is blank - then dont do anything Just populate the listbox from default element custom values ON SUBMIT (SAME PAGE) -MULTIPLE VALUES SELECTED Store the “selected value”s from listbox in an array in a hidden element or a temp persistent variable or maybe a hidden virtual field ON ERROR - REFRESH If theres an error like other required fields are not filled in on form (The values are not yet committed to the database) Then Load the hidden element “selected values” array Match the variables array values with the drop down list element custom values and highlight or show them as selected .
  17. Can someone please give me a link to the code to enable Multi-Select Listboxes? Thanks
  18. Hi, This link goes nowhere http://forums.caspio.com/index.php/topic/5600-capitalizing-all-letters/ Id like to use the same amended script. thanks
  19. Nevermind ! I found it. The trick is to click on the icon of the folder that contains the data pages.:)) Thanks to the universe ~
  20. This has been driving me nuts. Im trying to pass parameters , from page 1 to page 2. I have created and tested and deployed both pages In Page 1 - at the end of the wizard " Web Form Wizard - Destination and Emails " Go to A Data Page, when I click on :Browse" Page 2 does not show up ! It showed up once in another app, so its very intermittent. I cannot figure out whats going on. I ahve made sure both pages , parameters and settinsg are accurate. Anybody ever face this problem ? Thanks !!!
  21. Thanks Mathilda for the response, (Happy thanksgiving btw:) We need a live automated scheduled (every 5 hours) refresh implementation of the database unfortunately. Its paramount to our web app and customers. The options Im looking at are a) dump local inhouse db data to xml file in aftp folder then schedule a refresh import from caspio I have been looking at dream factory and I think since our db is also MSSQL server , Im thinking API is the way to go, Thanks for your help
×
×
  • Create New...