Jump to content
  • 0

Updated Question: Hide Button if Value Not Found in DB and if Value Less than $0


DaveC2019

Question

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

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @DaveC2019,

So that we can assist you better with this, kindly provide as an exported copy of your DataPage so that we can formulate the validation directly to it. Please export it with its dependencies

image.png.9e0e5b78560c553c09add8172f26f48d.png

 If your ables contains sensitive information then you can just export your table without Data, to reach the interface below you will need to click the 'Add' button first.

image.thumb.png.9cd470ee94741341e280fe67f4f319d9.png

 

Kind regards,

TsiBiRu

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...