Popular Content

Showing most liked content since 04/26/2017 in all areas

  1. 1 like
    Hi nuimage, I do not beliave that this is possible. Perhaps you may take a look at method described on Howto: http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/ Hope this helps.
  2. 1 like
    Hi Julien, Yes, it's possible. You may trigger changing a field and when field is changed, insert email address into virtual field. Then using virtual field in Email field for your acknowledgement email. Since I don't know type of your datapage, I created code for details datapage. Insert script in the footer of your datapage: <SCRIPT LANGUAGE="JavaScript"> function insert() { var x= document.getElementById("EditRecordEmail").value; document.getElementById("cbParamVirtual1").value = x; } document.getElementById("EditRecordField1").onchange=insert; </SCRIPT> Insert your fieldname which you would like to trigger instead of Field1 Also I assume that you have email field on your datapage, so you need to insert your field name instead on Email in my code. This way an email will be sent only if you changed value in specified field Hope that helps
  3. 1 like
    Hello nuimage, Please note that @calcfield2 will have value after page load as per your described workflow, hence. I would suggest having two Datapages (Report&Single record update form) to replicate your workflow. On your Report Datapage you can place a link in HTML block to Single record update form and pass @calcfield2 value as a query string. Parameters-as-query-string-values Hope this helps.
  4. 1 like
    Hi, I would recommend checking length of the value. You may insert the following script in the footer of details datapage: <script> window.onload= function() { if (document.getElementById("EditRecordYour_field").value.length>1) { document.getElementById("EditRecordcheck_box_field_name").checked=true; } } </script> Don't forger to change fields names in my script Cheers!
  5. 1 like
    Would this help you? Go to your style, make a copy, then search your source/all in the style and find elementcbSubmitButton and add the property display: none; Assign the style to your page. Then go to your data page and add an HTML field and view the HTML source to add this code. <div align="right"> <input onclick="myFunction()" type="submit" value="Submit" /> -Mark
  6. 1 like
    Got an answer to my question (Thanks so much Francis!) I got confirmation that the "Social Login Field" is not the same as the account name or the email address. For example, the Google social login field is a text string that resembles the following: "Google:123456789012345678901" Where it's the word "Google:" followed by a 21-digit number that uniquely identifies the Google account. There is a specific set of steps necessary to obtain that information which is not yet documented on the Caspio Support site. As soon as I have a chance I will append the instructions here in case anyone else ever needs to do this as well. However, the unfortunate problem is that this doesn't actually allow the desired results to be accomplished (specifcially: limiting access to a DataPage to specific Google users only by using "ID Service only"). This is because the method that is required to obtain the Google social login field is initiated by the google user, so it can't directly be used to create a list of allowed users because this causes a catch-22 situation where the Caspio admin/developer can't know the ID Service social login field without allowing the new user to login first, and once they do so, they are automatically added to the authentication data source. Therefore you basically need to allow access to all google users in order to get their unique social id which would be used to limit their access. Classic chicken & the egg dilemma. But I have an idea for how to avoid that conundrum and am working on implementing it now. Hopefully it will work...
  7. 1 like
    Hi Vitalikssssssss, It worked, thank you for your help. I have one additional question: From the first form, I pass the lineid to link to the next form. So far, so good. From the first form, I also pass the brandid. In the second form (which is based on the models table), I can then retrieve the brandid as a virtual field. My question is: is there a way to look up the brandname in the brands table? That would be a "nice to have", not strictly necessary to make the submission work. In more general terms, I guess my question is: can I automatically look up a value based on a passed parameter in a table that is not in the table on which the DataPage is based?
  8. 1 like
    Thanks. That did the trick. For anyone else that has the same problem, here's the code I ended up using in the calculated field box. I passed the parameter "wattsaved" in the URL to Caspio which came from a textbox in my form. CASE WHEN [@field:Per]='watt saved' THEN ([@field:Rebate] * '[@wattsaved]') WHEN [@field:Per]='kW saved' THEN ([@field:Rebate] * ('[@wattsaved]' / 1000)) ELSE 0 END
  9. 1 like
    Wow...that worked. I could've sworn that I had tried this already.... but I may have put the [0] in the wrong place. Thank you!!!!!!!!!!!!!!!!!!!!!
  10. 1 like
  11. 1 like
    Hi Esraa, Try using the following syntax: WHEN Charindex('''',[@field:TITLE], 0) <> 0 THEN Replace([@field:TITLE], '''',' ') Hope that helps
  12. 1 like
    Hi Blarney, Try this: If your fieldname is "lineitemsku" and you want to focus on this Inline Insert field, try the code below. <script> { document.getElementsByName('InlineAddlineItemsku')[0].focus(); } </script>
  13. 1 like
  14. 1 like
    You may sort fields on a date field in the descending order and return only 5 records for report. You can find this setting on the Advanced tab of the results page options screen of wizard. Hope that helps
  15. 1 like
    Thanks Mathilda, ".. a separate table for history of logs and then create a submission form and receive user's ID and other datapa from authentication fields, then add auto-submit script. After that, you may specify in authentication to redirect user to that datapage and then after form is submitted, redirect user to the user's dashboard. " it worked
  16. 1 like
    Thanks for your detailed insight. I watched the "How to Set Up User Permissions" tutorial and it was very helpful. I think your Travel Company model might have one more level than I will have in my Financial Advisor model - and so I'm still struggling with whether I have a one-to-many relationship or a many-to-many relationship. It sounds like instead of having the Many Travel Companies > Many Travel Agents > Many Customers you have - I have Many Financial Advisors > Many Clients. I'm not sure I have that 3rd level - although I suppose I could structure the model that way if, for example, a particular financial planning practice or firm had more than one financial advisor. Neil
  17. 1 like
    Hi, yes you are right, there is no option to connect sql server and caspio using data hub. One possible option - synchronize caspio and sql via API, however this is not the best option if you have limited amount of API calls per month. You would need a lot of API calls to keep 2 databases up-to date. I would recommend exporting data from sql server, import to caspio and manage the database in caspio.