How to validate variables
May 21, 2019 at 10:01 am #4978
I need to validate certain variables depending on the value of other variables, for example, we have 3 variables that are high, wide and diameter, the width and height would be the measurements of a piece of wood that has a hole in the center, when the client insert the width and the height will have to be warned in case of introduce a diameter that is not possible, imagine that we have a width of 10 centimeters and a height of 6 centimeters, the value of the diameter could not be greater than 5 centimeters because if not the piece would be illogical, How can I inform (or prevent) the client that could not enter that value and that this would have to be less than the smaller of the 2, that is, better than the high which is in this case the minor.
Thank youMay 22, 2019 at 8:37 am #4989
You could map the “Error Cell” so that you can show an error using Excel formulas based on other fields values.
Please in the documentation page look for “Error Cell”.
AT1368May 24, 2019 at 8:11 am #4988
Sorry, I don’t understand how it works, there is an example in the documentation.
ThanksMay 24, 2019 at 10:16 am #4987
Dear Tres ISI,
As I understood, your client is asking for the best powerful and effective solution because your client has realized that his business is high sensitive about the quality of the solution.
We do this kind of service and we call it “Turn-key solution” specially dedicated to the web agencies (and end user too) who want to delegate us for any technicality.
If you are interested in it, please ask us for a quotation and you will discover either how competitive are our prices, either how satisfied will be your client!
Let me know your feeling about this proposal
AT1368May 28, 2019 at 6:11 am #4986
We don’t need the turn-key solution, we just need to understand how it works the error cell, to validate certain values of variables as you well said we can use Excel formulas, but we don’t know how to alert the user to change a value in a field that is out of the range of a variable that depends of other previous variable write in other of the input fields.
We have created an outpu field in which the customer is informed of the maximum and minimum limits for the variables, but still the customer could add the product to the cart, which we need to alert the user of the error and can’t add the product until the customer has corrected that error.
If you can we can chat for a moment, I give them the access data to the plugin on the web and can see what I mean in more detail.
Thank you so much, best regards.May 29, 2019 at 9:15 am #4985David BoyleParticipant
Dear Tres Isi Mirobriga S.L.U.
We want to help our customers to center their goals. And according to this mission, we offer software development to customize their pre-production environment, Turn-key solutions, consulting and so on to make each of our customers productive at the real cost effective.
Regarding the free support, we have some limits related to the numbers of in-progress tickets and the number of exchanged messages.
Sorry for this long digression.
It seems to me that you are asking for more details regarding how Excel works and you would like to understand deeply some other points to fulfill your needs.
We consider that as a consulting service. And we offer this service on the base price of 40 euros per hour and you could book modules of 30 minutes each.
I guess that in your case 30 minutes (20 Euros) are sure enough to unleash all of your doubts.
As alternative, we are ready to fully refund your purchase.
Thanks for understanding our point of view
At1368May 29, 2019 at 9:22 am #4983
Hello, I don’t need help on Excel, where I need help is in a question that our customer has requested us, and that we could discuss while maintaining a chat or a remote control session, in case you understand what I say you can tell me what cost would have, then you answer how to do it or do it yourself directly.
ThanksMay 29, 2019 at 2:07 pm #4982
Hello Tres Isi Mirobriga S.L.U.,
I’ve sent an email to you.
- You must be logged in to reply to this topic.