Lookup Values in Basic Table

[JAIN_PROPERTY_BANGAL]

I have created an app where it can record payment received against a product in instalments.
So I have 2 sheets:

1. One with product information
2. To record the payments with amount & date

Then I’m using a relation between 2 sheets and using a lookup to get the payments received & date of payment against each product, so it gives me an array column for multiple results.

I want to display this in a table when I open any product’s detail page in the app.
Can someone guide me with this?

P.S. Screenshot attached

Thanks in advance…

[Lucas_Pires]

Hey @JAIN_PROPERTY_BANGAL

You cannot display Lookup values once you’re picking those values from a multiple relation

It worked only it is single - with Multiple option not checked in the relation

[JAIN_PROPERTY_BANGAL]

Hey Lucas!
Thanks for the reply…

Would you suggest any other workaround?

[ThinhDinh]

If you want to actually display the values rather than the relation, the only way is to pull them back using a joined text column.

[Fred_Marker]

Hey @JAIN_PROPERTY_BANGAL

If you simply want to display the payments made with date, take a look at this

Data editor not supporting markdown tables

Not sure if this is what you are talking about, but this is what I have in my app. [image] It’s an html table, because I needed the ability to span the width 100%, change the font size, and get the layout I want. I’ve been unable to get close to this with markdown, although the process I explain below would work for markdown as well. If you are familiar with html tables, then you will see that what I am doing, is I have a lessons sheet where I dynamically build each <tr> table row for each …

[JAIN_PROPERTY_BANGAL]

I want to display the multiple values against a particular transaction.

[JAIN_PROPERTY_BANGAL]

Woah!
This looks great.I’ll try this out

[JAIN_PROPERTY_BANGAL]

I tried a workaround and it works smoothly.
So, I have a sheet where the entries of payments (“Payments Sheet”) are stored and one sheet where the products (“Products Sheet”) are stored.

Step 1: Use Template column (naming it as “Combined”) to format into the following type
“Amt - Date”
replace “amt” with the amount
replace “date” with the payment date

Step 2: Create a relation in products sheets which relates the “product name” from products sheet to “product name” in payments sheet.

Step 3: Use lookup column (naming it as “Get Payments”) in products sheet to lookup “Combined” from payments sheet

Step 4: Set up a new column with joined list component (naming it as “display payments”) and refer it to the “Get Payments” column

replace “,” as a separator with “new line” (by pressing enter)

Voila!
It’s done, you’re all set to go.
Now you can make any entry to the payments sheet and it will immediately be added to the display.