How to show Graph on a form while editing the record in edit mode
While editing the record on a form, I want to show the Graph also on the same form (like Bar Graph, Scattered plot graph etc.,). That Graph has to be generated based on the data in another table. Th...
It is possible to display a Graph on a form just as you can display a report via a report link. For example if I have a Projects table and I wanted to display a graph showing the status of all the related Tasks by their status on each Project I could do this using a report link field. First I would create the report link field and then within the report link I would match my key field from Projects (By default in Quick Base this is the Record ID#) and the Related Project field in tasks. This will then show a table report of all my related Tasks. Then so long as I have built a graph on my Tasks table that has all the settings I would like for my graph I can view my project form, go down to the report link field and open up the properties of that form element. Within the form element is an option to 'Base the display on the report', this would allow you to select a graph that exists on the Tasks table instead of the default table report. You would just want to make sure to have a graph in the table you are pulling records from that matches your needs and select it from the list.
I hope this information is helpful Murali and certainly let me know if you have any questions.
