Please see the attached images below.
How do I change the Suppliers ID into String?
and
Is there any way to limit the number of row displayed?
Current settings:
Add_New_Product
- Product
- Suppliers [Lookup - Longlist - One Product to Many Suppliers]
- Quantity
- etc..
Suppliers
- Supplier_Name [String]
I have tried adding
s.Supplier_Name but got "Invalid collection object found" error.
- <tbody>
- <tr>
- <td colspan="5" style="font-size: 14px; font-weight: bold;" class="zc-viewheader-height">สินค้าใกล้หมด</td></tr><tr class="zc-viewrowheader-template" style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;">
- <td>Date</td>
- <td>Product</td>
- <td>UoM</td>
- <td>Available Q</td>
- <td>Supplier</td>
- </tr>
- <%for each i in Add_New_Product [Purchase_Required == "Yes"] sort by Last_Update
- {%>
- <tr class="zc-viewrow zc-row-1">
- <td><%=i.Last_Update%></td>
- <td><%=i.Product%></td>
- <td><%=i.Quantity_On_Hand%></td>
- <td><%=i.Unit_of_Measurement.Unit%></td>
- <td>
- <%for each s in i.Suppliers
- {%>
- <%=s.Supplier_Name%>, <%}%>
- </td></tr><%}%>
- </tbody>