Jump to content


  • Content Count

  • Joined

  • Last visited

About DaveC2019

  • Rank

Recent Profile Visitors

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

  1. I have a table that contains the following fields: grossamount, transactionfeepercentage, transactionflatfee and netamount. The grossamount field amount varies. The transactionfeepercentage field is always 2.9%. The transactionflatfee is always $0.10. The netamount field = grossamount -2.9% - $0.10 The problems I am having are calculating the percentage and then inserting having that correct amount inserted into a non formula field so that I can use the data in other calculations. Any ideas on how to do this? I am assuming that I will need a statement in my datapage which I do not know
  2. I apologize, but there is one bit of information I forgot to include in my question and I have added it here: I have a submission form that has a field called "username". My goal is to display an error message when the following is entered "*@tippytv". How can this be accomplished? Please not the asterisk is a wildcard and can be any word or number.
  3. I cannot get the script to work. I appreciate the effort. Maybe someone can assist us to complete it. Thanks.
  4. I have a submission form that has a field called "username". My goal is to display an error message when the following is entered "@tippytv". How can this be accomplished?
  5. I asked this question once before, but it was based upon a rigged solution that I poorly designed and I was not able to get the solutions that were suggested to work. Now I have corrected the issue and need help coming up with the solution that will work for everyone. The field "receivername" should query the database to see if the name entered in in the database in a field called "combined_user_name". If the name is not there than the button will be hidden. If the name is in the database then the button will be displayed. Next is the "balance after transfer" field. If the number in
  6. TsiBiRu how do I incorporate the solution you suggested. The solution your provided hides the original system button, but I have a custom button as shown in the link I provided. https://c6fot106.caspio.com/dp/acef600012e3392a45cf4611abbd I may have to change my workflow, but I'm not sure. Any ideas?
  7. I have a field called "receiversname" which is the second input field on my form. I am trying to make the form so that when the receiver's name is entered a script or whatever method will query the "UserAuthenticationTable" and check the field "combined_user_name" to see if the receiver's name exist. I the name does not exist the button should not be available and the page should not be able to be submitted even if the user uses a virtual keyboard like what is found on mobile devices. Here is a link to the datapage: https://c6fot106.caspio.com/dp/acef600012e3392a45cf4611abbd The credentia
  8. Sorry. The user ID is "johndoe" and the password is "qwe123qwe". The receivers username is "clarkkent@tippytv". Thanks for looking into this for me.
  9. Here is a link to the datapage: https://c6fot106.caspio.com/dp/acef60003eb60d3f84474c488495
  10. MayMusic. I tried the solution you provided and it did not work. But I think that if I provide you with additional information it might make a difference. After reviewing what you sent as a solution I am curious as to why the script does not focus on the field "balance" which is a calculated field. If the number in this field is less than zero then the button should be disabled. Your solution referenced a field where the value is entered and I'm not sure why, but you are more familiar with Caspio than I. Anyway I did enter the field where the value is entered. This field is named "amount_given
  11. I have a datapage that is a submission form. There is a calculated field called "balance". I am trying to come up with a solution that will hide the "submit" button when the value in the "balance" field is a negative number. My goal is to keep a user from submitting the form if the balance is below zero. Any help would be greatly appreciated. Thanks
  • Create New...