Forum Discussion

AODevGuy's avatar
AODevGuy
Qrew Trainee
10 months ago

Formula Rich Text: Setting a Default and Still being Editable

Hey Team!

First post in the community, looking forward to seeing responses!

Got a quirky question for your questing minds:

I would like to set a grid table as the default value in a rich text field while still having the field be editable. 

We have internal customers who need a table to put in details regarding materials, like 4Cx6R, with headings on each column.

Heading 1Heading 2Heading 3Heading 4
    

Is it possible to make a table the default value and still make the rich text field editable? Thanks!

formula query

5 Replies

  • JCY's avatar
    JCY
    Qrew Trainee
    10 months ago

    Have you considered using separate fields, they can be arranged to look like a table.

    You could use a formula field to populate from several different fields and display it in the table format.

    Just my opinion, maybe someone else has a better idea.

    • AODevGuy's avatar
      AODevGuy
      Qrew Trainee
      1 month ago

      Separate fields won't work for this as I need to maintain the grid in a single Rich Text field so it is holistically visible at the table level as well as the form level.

      But thank you for the idea!

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        1 month ago

        If you want to present the data in a nicely formatted HTML type Table, there is pretty simple syntax to do that. But the data entry fields will need to be standalone and then the formula for displaying it in a grid would use that as input.

  • Roy-Wanyoike's avatar
    Roy-Wanyoike
    Qrew Captain
    1 month ago

    I think this is something you can approach using the regular rich text field where you can have the html table code there. I've attached a sample

    <table border="1" cellpadding="8" cellspacing="0" style="border-collapse: collapse; width: 100%;">
  <thead>
    <tr style="background-color: #f0f0f0;">
      <th>Heading 1</th>
      <th>Heading 2</th>
      <th>Heading 3</th>
      <th>Heading 4</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    <tr>
      <td></td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
  </tbody>
</table>

    This would allow the use to click and edit the record value unlike in the formula rich text which can't be editted but would work when combined with some automation.