How to have different format to different fields in the Matrix field?

  • Profile Image
    Asked on February 07, 2017 at 02:15 PM

    Hello, can I have different formats within a table and also, how do I calculate fields within a table to add up to another field?

    For my first question, there are values, yes or no and date columns in on table. Is there a way to format these separately?

    For my second question, I need the values to add up to the  "Suma Total X in MXP" and "USD¨fields to whatever was filled in the table, then the total of all the "Suma Total" in the "Suma Total de Fuentes de Financiamiento en MXP" field. How can I do this?
  • Profile Image
    Answered on February 07, 2017 at 03:42 PM

    I am not sure if I understand your first question correctly since I couldn't find the specified field on the form due to it is in Spanish. Do you mean to say that a matrix field on your form is having 'Yes', 'No' and 'Date' columns and you want to display them as different field type? If so, unfortunately, it is not possible with the Matrix field. However, you may consider using a configurable list widget that enables to use different field types in the same row. Please refer to the guide below that can help you with setting up Configurable list widget.

    Hope this information helps! The other question related to calculations using a Matrix field is moved to a separate thread and it will be answered shortly.

    Thank you!