Skip to main content

I want to click a button and have 4 rows appear in a pre-filled way

L
Forum|alt.badge.img+3

Hello!

I use a table daily to track my students' test scores for a standardized exam. The exam has three components: math, reading, and verbal.

Each row is used to give details about a student's score in one specific section. For example, if Amanda sends me her test, she will actually get THREE rows in the table, like this:

R1: Jane Smith | Math Section | 75 points | January 8 2024

R2: Jane Smith | Reading Section | 21 points | January 8 2024

R3: Jane Smith | Verbal Section | 36 points | January 8 2024

The math/reading/verbal cell is a "choose one" cell. I cannot pre-fill the cell because it alternates between Math, Reading and Verbal. I wish there were a way to click a button that was like "create 3 new rows", and have them pre-filled with Math, then Reading, then Verbal in the section column. Any suggestions?

    2 replies

    kuovonne
    Forum|alt.badge.img+27
    • kuovonne
    • Brainy
    • 6007 replies
    • January 19, 2024

    If you use an interface, you can create a button that triggers an automation that creates the three records.

    If you are not ready to work in an interface and prefer to work in a grouped grid view, you can create one new row for the group, and then copy/paste the three values from a different group to create the two additional groups for a total of three groups with the three values.

    Mike_AutomaticN
    Forum|alt.badge.img+23

    Hey ​@Lauren_Fagen,

    You might want to have:
    Children Table
    Tests Table
    Test Sections Table

    You can have a checkbox field (“Create Test”) on your Children’s table that when checked will trigger the following automation:
    - Trigger: When a record matches conditions (If Create Test is checked)
    - Create Record (Create Test record linked to Child with corresponding date)
    - Create Record (Create Math Section record on Test Sections table, linked to Test record created above)
    - Create Record (Create Reading record on Test Sections table, linked to Test record created above)
    - Create Record (Create Verbal record on Test Sections table, linked to Test record created above)

    For sure the checkbox could also be find on a Children interface!
    Depending on your specific needs, the automation might needs some tweaks (e.g. trigger on a daily basis automatically).

    Feel free to schedule a call using this link if you’d like us to go through it together (I work with multiple schools).

    Mike, Consultant @ Automatic Nation

    Reply


    Most helpful members this week

    Terms & Conditions