cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Add new row in Gallery and Date in all the filds

Hi Team,
Source data  SQL Table 

IDClassEquityCommodityCurrency Cash trdCash DelFutureOptionTotal ValueRemaning ValueDate
1ANULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
2BNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
3CNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
4DNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
5ENULLNULLNULLNULLNULLNULLNULLNULLNULLNULL


in the above table rightnow i have manually added 5 classes  i.e. A,B,C,D and E but that should come from the User Input
ID- Identity column

EquityCommodityCurrency Cash trdCash DelFutureOptionDate

- Above column should be static always.

Requirement:- i want to create a add button to add the Classes.
eg:- when user press on Add button then user can add the Class in the Gallery and add the respective input fields i.e Equity,commodity and other column values till option column and Total Value should automatically based on the input fields. and remaining value is calculation 100-total values and after that user will select date from the Date Calendar.

Eg.

      Add Class Button     
            
IDClassEquityCommodityCurrency Cash trdCash DelFutureOptionTotal ValueRemaning ValueDate
1A10-20505000090108/15/2022
            
            
            
            
            
            
      Submit button     


if any class already available in the source database then it should display on the gallery but other input fields always be empty,  its just like trade app.
after hit on submit button then data will be stored into the trigger table.


Thanks


0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,531)