Forum Discussion
AODevGuy
1 month agoQrew Trainee
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
Qrew Legend
1 month agoIf 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.
- Denin1 month agoQrew Captain
Like Mark said, you would need each data point as a separate field. Then you would have a formula rich text that would be a wrapper, containing all of those field values in a HTML table shell. Example:
"<table style='border-collapse:collapse;width:100%;font-family:Arial,sans-serif;'> <tr style='background-color:#2c3e50;color:white;'> <th style='padding:8px;border:1px solid #ddd;'>Field</th> <th style='padding:8px;border:1px solid #ddd;'>Value</th> </tr> <tr> <td style='padding:8px;border:1px solid #ddd;font-weight:bold;'>Customer</td> <td style='padding:8px;border:1px solid #ddd;'>" & [Customer Name] & "</td> </tr> <tr style='background-color:#f8f9fa;'> <td style='padding:8px;border:1px solid #ddd;font-weight:bold;'>Project</td> <td style='padding:8px;border:1px solid #ddd;'>" & [Project Name] & "</td> </tr> <tr> <td style='padding:8px;border:1px solid #ddd;font-weight:bold;'>Status</td> <td style='padding:8px;border:1px solid #ddd;'>" & [Status] & "</td> </tr> <tr style='background-color:#f8f9fa;'> <td style='padding:8px;border:1px solid #ddd;font-weight:bold;'>Due Date</td> <td style='padding:8px;border:1px solid #ddd;'>" & ToText([Due Date]) & "</td> </tr> </table>"