Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Virtual Columns in Forms

Hi all, experimenting with a new process in an app I have created, the idea behind it came from the Order Capture sample app.

I would like users to create ‘Take Offs’ in which users select a schedule and they add multiple products with different order quantities for each item. This is exactly the same process in the sample in which I have a virtual column with Related Take Off Details; however the virtual column will not appear in the form I am creating to do this.

I made two separate tables; Take Off and Take Off Details (exactly like having an Orders and Order Details Table).

As I am only testing out the idea I have limited column and no dummy data atm.

This is the data for the Take Off Tbl including the virtual col;

This is the data for the Take Off Details Tbl - as you can see the Ref column to the Take Off Table is there also;

I created a slice from the Take Off Tbl in which I have included the virtual column, but the form does not show that making it impossible to add multiple products to a schedule as desired.

Is there any explanation to this issue, is there issues in the table structure or is the concept not applicable as it is between orders/order details? Thanks for any help, it is always appreciated

0 12 1,517
12 REPLIES 12
Top Labels in this Space