How to fill a table automatically with one field?

CRS123456 September 4, 2022

Hello to members of the community,

I use Jira server and recently I installed Table Grid Next Generation add-on. I read the documents and I couldn't find what I wanted.

I'm not a master in MySQL but I do my work with some searches.

I connected Table Grid to MySQL database and I can see my database also I wrote some queries and saw the results.

I want to know if it's possible when I select the ID field, other fields automatically show in their own fields.

If someone has any experience with it I appreciate it help me.

1.jpg

1 answer

1 accepted

0 votes
Answer accepted
CRS123456 September 6, 2022

Finally, I found it by myself.

I thought it has an option or some setting but thought wrong.

It depends on my query. for example in the Fname static option I wrote this query:

 

select users_firstname from usvn_users where usvn_users.users_id = '{column:ID}'

 

Also, I wrote something like that in the LName.

Now, if I choose some ID, for the next field I only can choose one Fname and this formula is working for LName too.

maybe it helpful for someone.

Suggest an answer

Log in or Sign up to answer