Announcement

Collapse
No announcement yet.

Dynamic Input Field Generation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dynamic Input Field Generation

    Hi

    I have the following tables with the below sample data

    STUDENT_MASTER

    STUDENT_NO NAME STD
    1 ABC 10
    2 XYZ 8

    EXAM_MASTER
    SUBJECT NO SUBJECT NAME MAX MARKS STD
    1 MATHS 100 10
    2 PHYSICS THEORY 100 10
    3 PHYSICS PRACTICAL 200 10
    4 CHEMISTRY THEORY 100 10
    5 CHEMISTRY PRACTICAL 200 10


    Now here is what I would like to do

    Select Student <Dropdown with Student Name> Exam Date : <Input date control> Std : <Label Display based on student selection>

    Enter the Marks

    Grid
    ================================================== ===================
    Subject Name Max Marks Marks Scored %
    ================================================== ===================
    MATHS 100 <input box> <Calculation label>
    PHYSICS THEORY 100 <input box> <Calculation label>
    PHYSICS PRACTICAL 200 <input box> <Calculation label>
    CHEMISTRY THEORY 100 <input box> <Calculation label>
    CHEMISTRY PRACTICAL 200 <input box> <Calculation label>
    ================================================== ===================

    <Save Marks button>

    Once a Student Name is selected from the Drop down; we need to identify the class that student belongs and then populate a grid based from EXAM_MASTER.

    I should be able to enter the Marks scored for each subject and % has to be calculated

    Then finally I would like to save the following to the below table when a Save button is clicked in the following table

    STUDENT_MARKS_MASTER

    MARKS_ID Primary Key
    STUDENT_NO
    EXAM_DATE

    STUDENT_MARKS_DETAILS
    MARKS_DETAILS_ID - Primary Key
    MARKS_ID - FK to STUDENT_MARKS_MASTER table
    STUDENT_NO - FK TO STUDENT_MASTER table
    SUBJECT_NO - FK to EXAM_MASTER
    MARKS_SCORED

    Hope I am clear on what I want to achieve. Big issues is I am not able to think how to generate the dynamic grid to list down the Subjects along with Inputs

    Thank you for your help

    Regards
    Murali

  • #2
    Is this possible or not I expect SC Support Team to guide me here.

    Comment


    • #3
      Hello,

      Taking a quick glance on your tables, you could do that on the Filter of a Grid application.

      Please contact our support for detailed tips on how you can achieve that. Our chat is active on workdays from 8:00am to 6:00pm, and our ticket system is always available.

      regards,
      Bernhard Bernsmann

      Comment


      • #4
        I have created a support ticket also. I will wait for your response. I am glad that we can do this.

        Comment


        • #5
          I am still waiting from SC experts to answer my above problem. I am sure this will be a good case for you to include this in your video tutorial.

          Comment


          • #6
            Hello,

            I will suggest that to our support team. As to not being answered yet, our support should answer you within 24h (except for holidays and weekends). If you run into a problem that you have to solve quickly, get in touch with us through our chat.

            regards,
            Bernhard Bernsmann

            Comment

            Working...
            X