DATA

Scripting Formulas Submission Lookups

Formulas can query for basic information about the forms and reports they belong to.

SUBMISSION.DATA

SUBMISSION.DATA(permalink, field_name)

Returns a submission's field value.

  • permalink: A submission selector. This can either be an explicit 10-character permalink, or a connection field value pointing to one or many submissions.

  • field_name: A field's Variable Name.

    /* Returns the value of the ABCDEFGHIJ submission's "Color" field */ SUBMISSION.DATA("ABCDEFGHIJ", "color")

    /* Returns the value of the "Color" field for the first submission connected to "Connection" */ SUBMISSION.DATA(connection, "color")

    /* Returns the value of the "Color" field for the second submission connected to "Connection". The numbering starts at 0, so 0 is the first submission and 1 is the second. */ SUBMISSION.DATA(ELEMENT(connection, 1), "color")