Solved: Re: PDF with related two database

arnaudv · 09-17-2023 01:13 AM

Hello to the community,

I have started to develop an application to edit a delivery note. My data is based on a google spreadsheet with 2 sheets:

the first one: "data": with information about the supplier: address, city, email, phone.

The second: "sender": the fields are filled in by the person who wants to send the material.

My application is based on the second sheet. I've added a bot to automatically create a pdf delivery note.

My problem: is it possible to have fields from 2 different tables on the same model?

Because my template only contains fields linked to a second "sender" sheet, but I'd like my template to also contain the suppliers' address, e-mail and telephone fields.

I've been trying for 2 days but I'm stuck.

Thank you and have a nice day

DVDLessa

As Julio35 explained, since you have a ref column, you can just dereference it.

[ref-column].[value-column]

More detailed info in the link below
Dereference expressions - AppSheet Help

View solution in original post

Julio35

Hello @arnaudv ,

I would say that yes, it is possible. However, it is important to know how the tables are somehow structured.

Are they related with some "ref" columns?
If not, how do you find the name of the supplier from the sender table?

arnaudv

@Julio35,

Yes, in the sheet "sender" I have a related column society, the same filed in a sheet "data". But it was possible to adding a lot of column related. I select the society1 in my app and that completed the other field with address in automatic?

Julio35

If you have two tables related, then it should be easy to access the "data" table from the "sender" table. Assuming you are working with data from the "sender" table, you can access the "data" table in the following way:

[society].[address] or [society].[telephone] etc..

where address, telephone etc.. are columns in the "data" table.

I hope this helps. If this doesn't answer your question, please share some images of the tables or try to explain everything with an example.

Thank you

arnaudv

@Julio35

This means that I need to add virtual columns to the "sender" table and do [society][address] so that it retrieves the information from the "data" table.

Julio35

I would avoid using virtual columns for this purpose.

Since you need to add this info in a PDF (as i guess from the post title), you can just use [society].[address] in your PDF template and this should work.