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. Hi @D3Melb, After using the formula I get 1_1. and because I want to concatenate NUMBER,STRING,NUMBER, I have to use CAST to convert both numbers to string.
  2. Hi, any news here? thank you
  3. Sure. here is a screenshot: Thanks
  4. Hi Guys, so I guess there is no way to do that, right? thank you anyway.
  5. Hi Kristina, Thank you for answering, but it didn't work. I modified the code that shows the address to: and put the code in the footer as stated in the link you sent: But the datapage still shows the empty field "State": Any other suggestions? thank you.
  6. Hi Gurus, I have this business directory working in Wordpress + Avada Theme. Now we are moving to DIVI theme and some things are not working. I have this tabular report that shows all the offices for the specific company that was select. In the "Search and Report Wizard - Configure Results Page Fields" part I have this javascript to hide the fields that are blank: <script> if("[@field:Address]".length > 0){ document.write('<strong>Address:</strong> [@field:Address]<br />') } if("[@field:City]".length > 0){ document.write('<strong>City:</strong> [@field:City] ') } if("[@field:State]".length > 0){ document.write('<strong>State:</strong> [@field:State] ') } if("[@field:ZIP]".length > 0){ document.write('<strong>ZIP:</strong> [@field:ZIP]<br />') } if("[@field:Country]".length > 0){ document.write('<strong>Country:</strong> [@field:Country]') } </script> it works very nice in AVADA: but it's not working in DIVI: I also tried also this technique: but no success again. Can someone help? thank you very much for any clues.
  7. 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
  8. 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.
  9. 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
  10. 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.
  11. Sure. here it goes. Companies: offices: Thank you.
  12. 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
  13. 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
  14. Great. Thank you for the suggestions. I will try today and let you know what happened. Daniel.
  15. 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
  • Create New...