You are viewing limited content. For full access, please sign in.

Question

Question

Populating table from SQL View

Forms
Updated February 1, 2017
asked on February 1, 2017

You know how we have Lookup Rules to populate drop-down menus right?

 

I was wondering if there was something similar to populate HTML Tables in a similar way.

 

Say for example: I could pick the data source in the lookup rule section and then say Fill this with That, and instead of generating a drop-down menu, it would generate an HTML table and the data in each cell.

 

Maybe if I tested enough with css and javascripts I could simulate a table using a drop-down menu, but I guess the issue would be when the table has more than one column.

 

I wanted to ask if anyone has ventured with something similar, before doing further analysis.

 

Thank you.

1 0

Answer

SELECTED ANSWER
replied on February 1, 2017 • Show version history

Hi Raul,

 

   Yes, you can populate a Forms table from an SQL View or Stored Procedure. We've one that pulls from the SQL View and fills each row with the data from a particular field. You just need to create the table first in Forms, and then add your look up. Here's a screenshot from one of ours.

 

Thanks,

Michael

1 0
replied on February 1, 2017

Thanks Michael, this is exactly what I was looking for. I can now simply style it to remove the input boxes and and just show the text or something, to simulate the actual HTML table.

 

Thanks again.

0 0
replied on February 1, 2017

You're quite welcome. I'm glad I was able to help.

 

Thanks,

Michael

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...