Menu
Welcome, Guest
Username: Password: Remember me

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

Ho do you represent the table data in the SuiteCRM module? 3 years 7 months ago #27285

  • raghavendra
  • raghavendra's Avatar
  • Offline
  • Senior Member
  • Posts: 41
  • Thank you received: 1
  • Karma: 0
I'm creating a custom suitecrm module. Basically i want to store a table data in the module. I've attached the image of the table.

Any ideas on the best way to format something like this in the CRM? Do you know any Sugar/Suite CRM extensions which can help me?

Thanks,
Attachments:
The administrator has disabled public write access.
The following user(s) said Thank You: hectorhcg

Ho do you represent the table data in the SuiteCRM module? 3 years 7 months ago #27286

  • raghavendra
  • raghavendra's Avatar
  • Offline
  • Senior Member
  • Posts: 41
  • Thank you received: 1
  • Karma: 0
I was asking if Datables or any other table plugins can be integrated into the SuiteCRM?

Thanks for the help.
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 years 3 months ago #32022

  • AsimPervez93
  • AsimPervez93's Avatar
  • Offline
  • Senior Member
  • Posts: 68
  • Thank you received: 2
  • Karma: 0
Did you manage to sort this?

I'm looking to do something similar.
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 years 3 months ago #32086

  • paulca
  • paulca's Avatar
  • Offline
  • Junior Member
  • Posts: 20
  • Karma: 0
Maybe I'm missing your actual question, but Modules ARE tables.

Create a custom package and in it create a custom module. Add a number of fields to it. Save/Deploy it.

Now open up your favourite MySQL admin tool and go and look at the database. You will find a table called something like "packagename_modulename" and it will contain the fields you added to your module.

If your question is how to display it as a table on the screen for editing, I can't help, but would be curious to know.

If your question is how to store a table of information and have each Account (say) have a table, then I'm sure relationships would sort that out. You would normally add rows one at a time and all rows added for one Account would be associated with just that account via the relationship.
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 years 3 months ago #32119

  • AsimPervez93
  • AsimPervez93's Avatar
  • Offline
  • Senior Member
  • Posts: 68
  • Thank you received: 2
  • Karma: 0
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.


The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 months 2 weeks ago #82689

  • hectorhcg
  • hectorhcg's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
I am exactly in your same situation... need to represent a "table" input or a matrix like grid for getting user input and storing on my custom module. Did you finally figure out the way to do that?

Thanks in advance.
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 months 2 weeks ago #82696

  • urdhvatech
  • urdhvatech's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Official code partner
  • Posts: 599
  • Thank you received: 123
  • Karma: 19
Hello,

We did a custom page for one of our customer where they can store information in a matrix format. it was exclusive customization to have specific fields and view to enter like shown in below screenshot attached.
Attachments:
Thanks & Regards,
Team Urdhva Tech
Web : www.urdhva-tech.com
Skype : urdhvatech

- Official code partner
- Official Integration partner
The administrator has disabled public write access.
The following user(s) said Thank You: hectorhcg

Ho do you represent the table data in the SuiteCRM module? 3 months 1 week ago #82967

  • hectorhcg
  • hectorhcg's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
That's exactly what I need !

How can we get it? please
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 months 1 week ago #82981

  • urdhvatech
  • urdhvatech's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Official code partner
  • Posts: 599
  • Thank you received: 123
  • Karma: 19
It was customized for our customer. You may contact us.
Thanks & Regards,
Team Urdhva Tech
Web : www.urdhva-tech.com
Skype : urdhvatech

- Official code partner
- Official Integration partner
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 1 week 3 days ago #88080

  • Jordan1234
  • Jordan1234's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi hectorhcg,

Did you end up finding a solution? I am looking for the same thing now, I need a field that is like a table or spreadsheet where the user can enter inputs into the cells. I could hypothetically create a field for each cell but that would be a ridiculous amount of fields.

Hopefully it is okay to bump this thread since it has not been resolved (I didn't want to start a new thread on the same topic).
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 4 days 21 hours ago #88214

  • hectorhcg
  • hectorhcg's Avatar
  • Offline
  • New Member
  • Posts: 14
  • Karma: 0
Yes and no. I ended using an HTML field (with the HTML table within), a WYSIWYG field specifically...
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 days 22 hours ago #88250

  • Jordan1234
  • Jordan1234's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Could you please help me by elaborating a bit on how exactly you did that?

I followed sugarmaister's instructions in this post:
suitecrm.com/suitecrm/forum/suitecrm-7-0...g-displayed?start=15
and that makes the html table appear within an editor, but it also has a sidebar on the left with a bunch of lorem ipsum templates you can click to insert. Anyways, the sidebar doesn't matter because whenever I edit the table in the editor and save the record, none of my changes to the table get saved. When I go to the detail view for the record I just saved, the html table is exactly as it was originally, before any of my edits.

Any advice would be appreciated, thanks
The administrator has disabled public write access.

Ho do you represent the table data in the SuiteCRM module? 3 days 22 hours ago #88252

  • Jordan1234
  • Jordan1234's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
EDIT: I found the WYSIWYG plugin by urdhvatech, but it seems like it just offers a blank editor, not something I can put a default table into
Last Edit: 3 days 22 hours ago by Jordan1234.
The administrator has disabled public write access.
Time to create page: 0.065 seconds
Powered by Kunena Forum