Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

maverick's Achievements

  1. Thanks for your response Emma! Actually filtering the blank records doesnt work because I want the records with $0 to be displayed - just displayed *AFTER* the ones with valid price info in them. I figured out another way to do this. I manually updated the records with no price information to have a max price e.g. $1000. This way the sort functionality always sorts them correctly. Thanks for your help.
  2. Thanks Jan.. I will try this out later today. Appreciate the quick help!
  3. I have a couple of HTML (non-caspio) forms that I need to maintain as-is but I wanted them to submit data to my Caspio Datapage. So I found this howTo link which makes sense for the most part. http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-convert-existing-html-forms-to-work-with-caspio/ However, it doenst say what the input field names should be in my non-caspio form. Should the field names match the field names in my datapage or should they be "InsertRecord<field_name>". Has anybody used this deployment technique in the past? Just wondering how well it works. Appreciate your time and help in advance.
  4. I have a Submission form where I am collecting comments in a Text Area. However it appears that "RETURN" or "ENTER" on the keyboard is disabled inside this text area. So my users cant create more than 1 paragraph in this text area. Is there a setting to enable this? What am I missing? Thanks for your help in advance. Mav
  5. Thanks Maymusic! Once again you came thru with your guidance and timely help. I really appreciate it! However I did find another way to do this using Rules and Criteria as suggested here http://howto.caspio.com/datapages/forms/conditional-forms/ Essentially, I put "oil_price", "natural_gas price" & "Kerosene_price" in different Sections. Then I setup the following rules if (fuel_type != Oil) { hide Section associated with Oil_price } if (fuel_type != Natural_gas) { hide Section associated with Natural_gas price } if (fuel_type != Kersosene) { hide Section associated with Kerosene price } Since fuel_type can only be set to 1 value at any time, this seems to work really well. I appreciate your input. thanks again MayMusic! Mav
  6. I have a Search and Report Datapage in which I need to selectively display certain fields. More specifically, each record has a fuel_type field. If this fuel_type is set to Oil, I need to display the associated Oil Price in the report. If fuel type is set to Natural Gas I need to display Natural Gas Price and if fuel_type is Kerosene, I need to display Kerosene Price. e.g. if (fuel_type == Oil) { show Oil_price; } else if (fuel_type == Natural Gas) { show Natural_gas_price; } else { show Kerosene_price; } I think there is a way to do this with Rules & Criteria. Can someone please guide me? Thanks in advance.
  7. My datapage sends auto-emails when an order is placed. The emails are sent in HTML format. I have been reading on the web at various blogs that all HTML formatted emails should go out with Plain Text versions as well. This is required because some older clients especially some mobile email clients cant parse HTML correctly. This is highly recommended and is a standard feature of emails sent via MailChimp, Constant Contact etc. Unfortunately Caspio seems to only allow one option or the other. Is there a way to achieve this in Caspio? Thanks in advance for your help.
  8. I have a table which stores price information for each record. When I display results via a search and report datapage, I am currently sorting them based on price - low to high. That part works great and I've no issues with. My problem is as follows - the table has some records that have no price information in it. These records are being treated as price $0 and are therefore ranked higher than other records that have valid price data. What I want is for the records with no price information to be sorted lower - i.e. displayed after all the records that have price information in them. Is there a way to do this? Thanks for your help in advance.
  9. I totally forgot about this suggestion until today morning when I logged back in to the forum. I just tried it out and it works great. Thanks again ShWolf!
  10. Thanks ShWolf! Great suggestion. I will try this out tonight and let you know how it works!
  11. What is the best way to implement Google "sponsored results" type of search. I use that term very loosely just to explain my point. I have a search form which returns search records and sorts them based on price - which is embedded within the record. I would like to sort them in a way where I can give preferential treatment to some records and list them higher than others. In other words, preferred records should be sorted higher than non-preferred even if their price is higher than non-preferred. (Almost like a 2-tier sort). I was thinking that I might have to add a field to the record table like "preferred" and use that somehow. Any ideas/suggestions? Thanks.
  12. Thanks for your response Maymusic. The validation code seems to work but it doesnt seem to run when the date field is changed. However with an old date, if I reload the page, I get the alert - so the code you suggested seems to work. I tried both onChange and onClick and neither one works. Do you know what else might?
  13. Hi, I have a date field in a Submission form datapage and I want to validate that the entered date is greater than today's date. I tried something like this but it didnt work. function validateDate() { var del_date = '[@InsertRecordGuestOrders_Delivery_date]'; var today = new Date(); if (del_date <= today) alert("Delivery date has to be later than today"); } document.getElementById('InsertRecordGuestOrders_Delivery_date').onChange = validateDate(); Would really appreciate any help.
  14. Thanks for your response MayMusic. For some reason I didnt get an email when you posted a response so I never saw it. In any case, I tried including security_questions (display only) and security_answers (text field) in my password reset datapage. Ideally when the user enters his email, I would want his previously stored security question to be displayed so that he can provide his security answer. However, nothing is displayed in the security_questions field - I think its because the datapage hasnt obtained the record associated with the email address yet. I even tried to specify security_questions as a "text field" hoping that I could choose a dropdown and provide question choices to the user. But there is no dropdown option available. Even if I get this to work, this would still require that the user remember the security question they chose (during signup) and provide a corresponding answer - which doesn't seem like standard practice. Not sure if I'm doing anything wrong.
  • Create New...