How to make a complex table in suitecrm?

[keysu]

I am going to make a table like this in leads, then the lead can be converted to opportunities.
My current idea:
1.change the current theme, because it does not support multiple columns.
2.set the max column of the 2 modules.
3.compile everything.

Some better ideas?

Thanks!

[Urvi]

Hi
I hope all of you are safe and well in this pandemic situation.

Currently SuiteCRM have 2 Column Layout for all the Views of Module.

1. you want to change the 2 Column to 4 or 5 Column Layout? If yes then it’s Fix Column or it’s Dynamically like you can configure the column number and based on it apply on the Views.

2. This applies only on the Leads and Opportunity Module or all the Modules of SuiteCRM?

Thanks
Urvi

[pgr]

On a different approach, have a look at this

Ho do you represent the table data in the SuiteCRM module?

I think you may be misundersanding. If you imagine an Excel spreadsheet…is there any way to have a custom module which displays something similar to an excel spreadsheet? I’ve attached a photoshopped image to help you understand what I mean. [image]

though I don’t think that you’ll find a working solution there…

[p.konetskiy]

@keysu

Look at the solution https://github.com/salesagility/SuiteCRM/pull/8341
It’s repaired filed type collection of SuiteCRM.

Perhaps it’s help you.

[cherub-chum]

I think what you need is a field Type “function” they same way Quote Line Items are rendered. Check below screen what i had created for a custom requirements.

[keysu]

Hi Urvi,
Thanks for your concern.
Currently, I need a “table” input or a matrix like grid for getting user input. 5 rows, 10 columns or more, depends on the impressions.
This applies only on the Leads and Opportunity.
Yeah, the current SuiteCRM theme P only supports 2 columns, so I need to change the theme first, then re-layout other fields.
I am wondering if there’s some better method…

[keysu]

Hi!
That’s really amazing, I never konw there is already a data type.
I will try this asap.