Store Data in List Variable Directly From UI (Without using UDF as Staging Table)

Discussion in 'Tally Developer' started by Himanshu-2002, Jun 15, 2023.

    
  1. Himanshu-2002

    Himanshu-2002 Active Member


    Hi Experts,
    I have been trying to store user inputs in List Variables without using Aggregate UDF or Some Staging Table.

    I tried few ways but No Luck, Pls give some ideas
    Code:
    [#Menu:Gateway of Tally]
    Add:Key Item:"Save List Variable":S:Alter:Save Aggregate Data
    
    
    [Report:Save Aggregate Data]
    Form:Save Aggregate Data
    
    [Form:Save Aggregate Data]
    Parts:Save Aggregate Data
    Width:30% Page
    Height:30% Page
    Horizontal Align:Centre
    Vertical Align:Centre
    on:Form Accept:Yes:Form Accept
    On:Form Accept:Yes:Call:Log Values
    
    [Function:Log Values]
    000:Log:#SADBody[1].SADName
    
    [Part:Save Aggregate Data]
    Line:SAD Title, SAD Body
    Repeat:SAD Body
    Scroll:Vertical
    Break On:$$IsEmpty:#SADName
    
    [Line:SAD Title]
    Use:SAD Body
    Local:Field:Default:Type:String
    Local:Field:Default:Delete:Modifies
    Local:Field:SAD Serial No:Set as:"Serial No"
    Local:Field:SAD Name:Set as:"Name"
    Local:Field:SAD Age:Set as:"Age"
    
    [Line:SAD Body]
    Fields:SAD Serial No, SAD Name, SAD Age
    
    [Field:SAD Serial No]
    Use:Name Field
    Set as:$$Line
    Width:10
    Skip:Yes
    
    [Field:SAD Name]
    Use:Name Field
    Modifies:Aggregate[#SADSerialNo].Name
    Full Width:Yes
    
    [Field:SAD Age]
    Use:Number Field
    Modifies:Aggregate[#SADSerialNo].Age:Yes
    Width:10
    
    [Variable:Aggregate]
    Variable:Name:String
    Variable:Age:Number
    
    [Variable:StudentName]
    Type:String
    
    [System:Variables]
    List Variable:Aggregate
    StudentName:""
    ;select ##Aggregate[1].Name From COmpany
     


Share This Page