Forms retrieving data from external table

asked on August 5, 2015

Hi there,

I did build a form that fill some fields as I put a value. But now I want to bring two value of a table to a single field, is it possible?, I tried to do it, but the way that I did is not working, so if someone give me any hint I will be glad.

Like on the screenshot below, as I put a number on CPF, it fills "Nome, rg, email, telefone", and I want to bring also"chassi1 and status1" values. When the search has a single value, it shows ok!, but if the search has more than one result for chassi1 and status1, it does not come nothing, and that is what I am trying to show up.

Thanks a lot for the help.

Vitor

forms.PNG (18.66 KB)

| Download

rule.PNG (79.19 KB)

| Download

0 0

SELECTED ANSWER

replied on August 5, 2015

You cannot currently do this with the built in functions of Forms. There is a feature request for it though here.

What you can do to accomplish this is to make a view in your SQL database with the concatenated field values you want and use that instead of connecting directly to the table.

2 0

replied on August 5, 2015

Hi Blake Smith,

Thank you very much for the tip.

I am going to try it. But I also got what I wanted with the Drop-down type of field, it did bring me the list containing all the results from each field, but now it seems that I am not able to use the selection of the list, I do not know why.

But thanks again!

0 0

Question

Question

Forms retrieving data from external table

Answer

Replies

Sign in to reply to this post.