Hi I was able to generate random numbers but I couldn't save it into the db by using server actions

Hello Athulya Panicker, 

So, the Generate password returns a password/integer string of length you have defined. 

• https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/built_in_functions/miscellaneous/#GeneratePassword

After that you don't need something extraordinary and unusual like you already normally do to save data on the database. 

In resume, in order to save information/data on the database:

• Create the entity you need to store the data (or in your case, add the attribute to store the alphanumeric numbers at the Student entity); 
• Define the data type (maybe in your case it is better to store as integer and not text). You need to use some Data conversion function.
• Use the entity action Create or CreateUpdate or Update (the one that fits your case better) 

These are some links that might help you:

• https://www.outsystems.com/training/lesson/1774/database-entities/
• https://www.outsystems.com/training/lesson/1770/modeling-data-relationships/
• https://www.outsystems.com/training/lesson/1772/variables-in-outsystems/
• https://www.outsystems.com/training/lesson/1777/actions-and-exception-handling/
• https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/built_in_functions/data_conversion/

I also recommend you review or do the guide paths: 

• https://www.outsystems.com/training/paths/18/becoming-a-reactive-web-developer/
• https://www.outsystems.com/training/paths/2/becoming-a-traditional-web-developer/

Including the exercises that include detailed instructions on how to do these things and much more, like bookings, employees or orders, for example. 

Best regards, 

Ana

Hi Athulya 

I don't think there will be any problem to save it, Just make sure your entity attribute type is test in which you want to save this random generated string.

Thanks

Deep

Hi @Gitansh Anand 

The solution you've sent have worked perfectly but there is a slight change in my POC now, I want to generate alphanumeric numbers when I update table. What changes should I do in the condition to achieve it?

Do you need to generate new alphanumeric numbers every time the table is updated? Will you not generate alphanumeric numbers the first time you create in the table?

Here are possible solutions to your requirement:

1. Generate only when create (Original answer)
If(Source.Id = NullIdentifier(), GeneratePassword(8, True), Source.Seat)

2. Generate new every time (create and update)
GeneratePassword(8, True)

3. Generate every time when update
If(Source.Id = NullIdentifier(), Source.Seat, GeneratePassword(8, True))

4. Generate only on first update
If(Source.Id <> NullIdentifier() and Source.Seat = NullTextIdentifier(), GeneratePassword(8, True), Source.Seat)

This assign is in the "StudentCreateOrUpdate" server action

Actually in my POC there are 2 buttons 

1. button is to save details to the table

2. update the table while generating alphanumeric value.

Since I need to use the second button for updating the table and generating values I asked the doubt.

Hi @Athulya Panicker 

In your second button click action pass the actual record Id which you stored in database by clicking on first button,

Then use the GeneratePassword(Integer, Boolean)  action to generate alphanumeric value and use the updateEntity action to update record in your table.

Thanks

Deep  

In that case, create a new action, call this action to the 2nd button, add the GeneratePassword function to update the value of Seat in the source, and then call the original action. Also remove the GeneratePassword function used in the original function.
This way, the first button will work as it is (without the alphanumeric value), and the second button will first create a new alphanumeric value and then work as it is.

Thanks
Gitansh Anand

Thank you so much for the solution