Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

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

Majortom's Achievements


Newbie (1/14)



  1. Hi Guys, So I have a customer registration setup that sends out an activation link to their registered email however I want the link in the email to say "Click Here to Activate Your Account" rather than display a link to the Caspio page. So for example the code I have is as follows: <a href="https://xxx.caspio.com/dp/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx?CID=[@field:CustomerRandomID]">https://xxx.caspio.com/dp/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx?CID=[@field:CustomerRandomID]</a> With the above code it works and I receive the email however the link displays as "https://xxx.caspio.com/dp/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx?CID=[@field:CustomerRandomID]" When I change the code to: <a href="https://xxx.caspio.com/dp/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx?CID=[@field:CustomerRandomID]">Click Here to Activate Your Account</a> In the Edit view for the email message it shows it all as expected and valid code however no emails are being sent out? (If I change it back everything works again). Not sure if something needs to be done differently or its a bug? Thanks
  2. Working fine now, thank you ever so much. Mike
  3. Hi TsiBiRu. I have given the code a test and still allows me to submit a hotmail or gmail address. Below is the code I have put into a footer and a screenshot from the debugger view: <br /> <script> document.querySelector('#caspioform').onsubmit = function(e) { e.preventDefault(); // Get User input var UI= document.getElementById("InsertRecordContactEmail").value; //check if user used gmail var gmail = UI.includes("gmail"); ////check if user used hotmail var hotmail = UI.includes("hotmail"); if ( gmail ==true) { alert(' You are not allowed to use Gmail !'); } else if ( hotmail ==true) { alert(' You are not allowed to use Hotmail ! '); } else { this.submit(); } } </script> Thank you again for all your help. Mike
  4. Wow! Thank you for that, I will give it ago. Thank you so much! Mike
  5. Thanks however this doesn't answer my question, as I said first post I will configure this validation process however it doesn't stop a user signing up with a Hotmail or Gmail email address. Thanks, Mike
  6. Hi Guys, I'm planning on using email verification when a new user registers however in addition to this I want to restrict users signing up with Hotmail or Gmail accounts. My site is for corporate users only so their email address must be from their company domain. What would be the best route to put some sort of field validation on the sign up form so if a user enters dave@hotmail.com the system stops them from clicking the submit button with a message of no public facing (i.e Hotmail or Gmail) email accounts allowed? Many Thanks, Mike.
  7. Thanks for the input guys. I think I have solved the multi item issue (please see screenshot of the tables and relationships). Problem I am having now is how to display it. For example on Order ID 1, my user Dave has ordered 2 servers and one storage array. I have combined the tables via a view then created a new data page (report) based off that view. Problem I am seeing in the report (screenshot at the bottom) and probably a layout issue is its showing the storage array twice on each line as if they've ordered 2 when they have only ordered 1. Ideally what I want the layout to show is something like this: CustomerID : 1 Customer Name: Dave Servers: Qty: 2 Form Factor: Rack CPU Make: AMD No of CPU: 2 Qty: 1 Form Factor: Tower CPU Make: Intel No. of CPU: 1 Storage: Qty: 1 Protocol: Block Type: Hybrid Capacity TB: 100 ---------------------------------------------------------------------------------------------------------------------------------------------- Thanks for all your help. MT
  8. Hi Guys, Newbie to Caspio however I've created many Access Databases in the past (a while ago so slightly rusty!). I'm trying to create an ecommerce database where a user selects items from a catalog (table in this case), goes into a shopping cart and then submits into an order. Problem I've found with the sample databases (Simple order Management template for example) is each item goes in as a separate OrderID. I want a user the select several items from a catalog which goes into a shopping cart and when they checkout all the items go under a single OrderID. So at the end in the Orders table there is a single OrderID with all the items the user has selected under one record. Are there any examples out there which would demonstrate this or anyone know the best way to go about architecting it? Cheers, MT
  • Create New...