Details Column Visibility and Functionality Issue

I am experiencing an issue with the "Open Offerte Details" in my app, specifically within the Klant Offertes form. I have set up two virtual columns:

  1. Related Klant Offerte Details

    • Type: List
    • Formula: REF_ROWS("Klant Offerte Details", "OfferteID")
  2. Open Offerte Details

    • Type: List
    • Formula: REF_ROWS("Open Offerte Details", "OfferteID")
    • Condition: [OfferteStatus] = "Open Offerte"

Current Situation:

  • The Related Klant Offerte Details column displays correctly and allows for adding new items.
  • The Open Offerte Details column only appears when I edit the Open Offerte Details form, but it does not allow for the addition of new entries.
  • In the Open Klant Offerte form, the Open Offerte Details column is not visible at all.

Verification Steps Taken:

  • Confirmed that the OfferteID in the Open Offerte Details table matches with Klant Offertes.
  • Verified that there are records in the Open Offerte Details with the OfferteStatus set to "Open Offerte."
  • Checked that the virtual column is included in the form view.
  • Attempted to refresh the app and re-add records.

Additional Context:

  • My app is based on the Order Capture How-To app, which has similar functionality working correctly.
  • In my initial support chat, I was informed that the issue might be related to the REF column and the IsPartOf setting. However, I havenโ€™t been able to pinpoint any mistakes in my configuration.

I would greatly appreciate any assistance in diagnosing and resolving this issue, as I have been troubleshooting for several hours without success. Thank you!

Screenshot 2024-10-11 183436.pngScreenshot 2024-10-11 203359.pngScreenshot 2024-10-11 204207.pngScreenshot 2024-10-12 141806.pngScreenshot 2024-10-12 141947.pngScreenshot 2024-10-12 142039.png

0 1 51
1 REPLY 1

Steve
Platinum 5
Platinum 5

The Open Offerte Details column only appears when I edit the Open Offerte Details form, but it does not allow for the addition of new entries.

This suggests that the Open Offerte Details slice and/or the table it uses may not allow adds. Make sure both the slice and its table allow adds.

Make sure that the Add action is included in the slice's Slice Actions list or that Slice Actions is set to Auto Assign.

Steve_1-1728922148489.png

Steve_0-1728922093144.png

It's also possible the Add action for the table used by the slice has an Only if this condition is true expression that disables the action.

Steve_2-1728922302805.png

Top Labels in this Space