Merge fields from another table?

Hi

I need to combine the below two tables

1. order table: has order details and submission id

https://www.jotform.com/tables/250608954811864

1. pick up schedule table: pickup details and submission id https://www.jotform.com/tables/250773323569867 

As far as I know, with submission id we can match pickup data with. order data.

My question is how to view some fields of pickup table in order table?

Hi Gomine,

You can use the Connection Action button in your Jotform tables to display the fields from another form. Let me show you how to do it:

1. In your Form Tables, click on the +Add button on the right-most part of the Table. Or, you can right-click on one of the columns and choose Insert column left/right.
2. Click on the Connections tab, choose Tables, then click on Next.
3. Input the Column's Name, then click on Next.
4. Select the Submissions Table of the form you want to get data from, choose the Field you want to display in that column, then click on Create Column.

Keep in mind that you would have to create multiple columns for each field containing the information from the other form's table. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Give it a try and let us know how it goes.