Grid Fields required and syntax formatting

[Randy21]

Went through the Flying Start Genie using the Northwind data tables. Would like to know how to I change a field in one of the grids to be required when entering a new record.

Also, I would like to add the function when adding items that the text can be formatted into upper case. Example, when entering a state if the user enters the state ca it would be saved as CA.

[madtowng]

look at the javascript actions on the right for each field if you want the rules enforced at time of entry/change.
If you're just learning grids now, I would suggest starting with viewboxes to avoid a 2nd learning curve.

[Randy21]

I was able to find where to find field settings to change a field to be required to submit a record.

image_2023-05-11_105200445.png

[madtowng]

just looking, do you really allow whitespace in the customerID field ?

[Randy21]

just looking, do you really allow whitespace in the customerID field ?

Thanks for the input. This is just a test project as I learn how to use the application so not necessarily creating a product to go into production. Would you be able to assist me with how to change the data in the field to uppercase when sending it to the database?

[madtowng]

Hi Randy,
Put the code shown below in the onChange event. Choose text (the middle top radio button).
Change <fieldName> to the name of the field you want to convert to caps.

var rowNum = {grid.Object}.getSelectedRow();
var colData = {grid.Object}.getValue('G','<fieldName>',rowNum);
{grid.Object}.setValue('G','<fieldName>',rowNum,colData.toUpperCase());​

[Randy21]

Hi Randy,
Put the code shown below in the onChange event. Choose text (the middle top radio button).
Change <fieldName> to the name of the field you want to convert to caps.

var rowNum = {grid.Object}.getSelectedRow();
var colData = {grid.Object}.getValue('G','<fieldName>',rowNum);
{grid.Object}.setValue('G','<fieldName>',rowNum,colData.toUpperCase());​

I am getting this error:
image.png

[madtowng]

get rid of the question mark on line 3

[Randy21]

get rid of the question mark on line 3

When trying to enter a new record this error occurs.
image.png

[madtowng]

gotta follow the rules
Capture.png

[Randy21]

gotta follow the rules
Capture.png

Given that I am using the Northwind database from the tutorial I did not realize the rule that existed, however, when I entered a new record the company name remained in lowercase.

image.png

[madtowng]

I didn't know about that restraint until you showed the error message.
I just took the time to read the message (this one made sense to me).

I can't explain your most recent issue without seeing everything your grid is doing.

[Randy21]

I went through a tutorial " Getting Started With Alpha Anywhere - Build Your First Web App "

It basically goes through how to use the "Flying Start Genie" process and uses the Northwind database.

Link to the tutorial: https://documentation.alphasoftware....0App/index.xml

What I want to do is for specific fields I would like to edit the data that would be sent to the table. Example if the user enters the customer name, Ben, it would be saved as, BEN, into the table.

Here is an image of how the web app looks:
image.png

[Randy21]

I didn't know about that restraint until you showed the error message.
I just took the time to read the message (this one made sense to me).

I can't explain your most recent issue without seeing everything your grid is doing.

was able to figure out how to change the values in the grid database. Thank you for trying to help.

Add this list to both the CanUpdateRecord and CanInsertRecord events: DataSubmitted.COMPANYNAME = upper(DataSubmitted.COMPANYNAME)

[madtowng]

I'm sure you can tell by now there are several ways to skin a cat.
I gave you the javascript (clientside) method, you obviously found xbasic(serverside), and there's still letting sql (I'm guessing you're using sql) handle.
I still think you'd be better off learning viewboxes or even list controls at the very start (makes the learning curve easier to deal with).