DaveC2019

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 how to do. All help is appreciated. DepositTableTEST.zip

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.

I cannot get the script to work. I appreciate the effort. Maybe someone can assist us to complete it. Thanks.

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?

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 this field is $0 or a negative number then the button will not be displayed and there will be a message that reads "you do not have enought to complete this transaction". If the number is above $0 than the button will be displayed and allow the transaction. Here is the datapage: https://c6fot106.caspio.com/dp/acef60003eb60d3f84474c488495 Here are the credentials: "michaelt@tippytv" and pw is "qwe123qwe". Here is a receiver's name that is in that database to be used for testing: "jameskirk@tippytv" The last part of the question is is it possible to keep someone from using the virtual keyboard to submit form even if the button is not visible? Thanks

Solution works perfectly. Thank you.

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?

Thanks. I will take all of this into consideration

Thank you. This worked for me. Greatly appreciated!

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 credentials to login are "michaelt@tippytv" and pw is "qwe123qwe". Here is a receiver's name that is in that database to be used for testing: "jameskirk@tippytv" Any help with this would be greatly appreciated. Thanks!

Sorry. The user ID is "johndoe" and the password is "qwe123qwe". The receivers username is "clarkkent@tippytv". Thanks for looking into this for me.

Here is a link to the datapage: https://c6fot106.caspio.com/dp/acef60003eb60d3f84474c488495

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". What did I do wrong or what am I missing? This is how the script looked when I replaced the values per your instructions: <script> document.addEventListener('DataPageReady', function (event){ document.getElementById('InsertRecordamount_given').onchange = function (){ if (document.getElementsByName('InsertRecordbalance')[0].value < 0) { document.getElementsByName('Submit')[0].style.display = 'none'; } else { document.getElementsByName('Submit')[0].style.display ='inline'; } }; }); </script> I did not receive an error message and the button did not disappear when the balance field was negative. I placed the script in the footer. I really appreciate your help. Thank you!

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