Jump to content


  • Content Count

  • Joined

  • Last visited

About dasigrist

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ok, so I was able to create a HTML block on my datapage like this: <script> var myNewURL = "[@field:Company_ID]";//the new URL window.history.pushState({}, document.title, "/" + myNewURL + "/" ); </script> but this is not a valid URL. I cannot copy and paste it on another browser or share this URL. Is there something like Linkedin, where I have: https://example.com/company/3267/ as a working URL and if I copy and paste this URL I will go to the right page? Thank you
  2. Thank you kpcollier, I think that is exactly what I want. But, how do I implement that in caspio? HTML block on my details page? inside <script></script>? Thank you.
  3. Hi Gurus, I have a business directory and I dynamically create a company's page passing the company ID as a parameter like this: https://example.com/company/?Company_ID=3267. I would like my URL to shows like a company's page in LINKEDIN: https://example.com/company/3267/, hiding the "?Company_ID=" from my details page. is that possible? thank you Daniel
  4. Hi kpcollier, sorry, but I have that option only for the first form where you choose the region and country: we don't have for the results: Thank you.
  5. Sure. here it goes. Companies: offices: Thank you.
  6. HI Dear Gurus, I have 2 tables. Companies and Companies_Offices. They are related by company ID. I did a form where I select the region and the country and the result will be all companies in that country (only region is required). I joined the 2 tables in a view with company_name,the Logo, country and region: If I select north america as the region and USA as the country, this is the result: and here is my problem. if the company has more then 1 office in the country, it appears several times. but I just want to list one. is there a way to do that? Thank you Daniel
  7. Hi, I tried the formula field and it worked perfectly. This is my formula: Cast([@field:Company_Rel_ID] as varchar) + '_' + Cast([@field:Category_Rel_ID] as varchar) Thank you so much for your help. Daniel
  8. Great. Thank you for the suggestions. I will try today and let you know what happened. Daniel.
  9. Hi again, I tried your suggestion creating a new datapage with the same type of your example. I didn't work either as you can see by the screenshot. I don't think you can concatenate integer+string+integer. Thank you for any suggestions. Daniel
  10. Sorry guys, but I don't have that option, as you can see by the screenshot attached. also, I remember trying this before with another datapage and I couldn't pass the verify part. Are you sure I can concatenate integer with string. I don't think I can. Thank you.
  11. Hi, I have 1 table with 3 fields: - company_id (integer) - category_id (integer) - Unique_identifier (text): I want to concatenate company_id value with _ (underscore) with category_id value. I followed the instructions here: but with no success. I would like some light on my problem. My code in the datapage is: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var cat = document.getElementById("EditRecordcategory_rel_id").value; var company = document.getElementById("EditRecordcompany_rel_id").value; var unique = company + "_" + cat; document.getElementById("EditRecordUnique_Identifier").value = unique; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> I replaced the insertRecord for EditRecord because the above document says: Search and Report DataPage, replace the prefix "InsertRecord" with "EditRecord" in the code. but the code is not in the details page. I put the script in the footer of my "Search and Report Wizard - Configure Results Page Fields". any help would be great. attache there is a screenshot of the page: thank you.
  12. Sorry, But I don't get it. If I do that, I will not have the progress bar anymore. I want the progress bar to be there while sending the data to the table, but it needs to disappear when I show the message "your submission" was successful. Best, Daniel
  13. HI Gurus, I used the JS auto-submit article: The problem is that the progress bar, doesn't disappear after submission.In my datapage, I'm using "display a message" for "Destination after record submit:". So, when the message is displayed, I would like the progress bar to disappear. Is it possible? thank very much for any help.
  • Create New...