Trying to update data in RMS with a web interface

Jun 24, 2008 2 Replies

Rate this thread:

Jason 18 years ago

My project is much more complicated, but I am hoping someone can give me some generic tips and/or code to assist me.

I want to update a field in RMS with some data the cashier inputs on an HTML form. For example, if a cashier selects a customer using F7, I want them to press a custom button that brings up an HTML window. That html file will have a form where the cashier will enter some text in a textbox. When the cashier presses Submit, the text in the textbox will be written to the Customer.CustomText1 field.

The two major issues are 1) how to pass the Customer.ID to the HTML window and 2) how to execute the SQL to update the Customer.CustomText1 field from the form data.

Vote

JerryData 18 years ago

Wow, that's a big one. Look in the RMS customization guide for the QS rules object description. We usually do that type of thing in VB, you might consider that.

Vote

Ryan 18 years ago

Jason, It may be easier and less error-prone to invoke an actually application from the POS button rather than an HTML window. QS Bridge is kinda flaky at times.

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required