Hi, I have a really annoying bug I've spent days trying to sort out but after downloading the Nested Forms demo app and making a slight modification, it seems this bug happens in a very simple app.
I would publish the app to help, but I'm on a free account and it won't let me.
Basically, the mod I've made to the Nested Forms app is to create two slices of Child
The ChildRO slice Update Mode is set to Read Only(RO) and the ChildUAD slice Update Mode is set to Updates, Adds & Deletes (UAD). Obvioulsy, I have set the table properties of the Child table to allow Updates, Adds and Deletes.
The relevant Ref_Rows have been used to link the 'Child' tables to the Parent table.
I've also added a property to the Parent table - 'Complete' as a Y/N field.
The idea is that in the Parent view form, if a Parent is set to 'Complete', the RO Child slice is used and if the Parent is set to 'Complete'=False then the UAD Child slice is used. This is to only allow the user to add children to parents who are NOT set to complete. This is achieved by using the show_if function on the 'Complete' property for the related RO or UAD slices
This is very simple stuff and works fine in the Parent 'Details' view where you can add children or not depending on the 'Complete' property. However, I don't like data being added to the Parent in the details view so I only want to allow the user to add children while editing the parent - IE in the Parent View Form.
When I first set this up, I did it before I added the 'Complete' property and so had both RO and UAD child slices in the Parent View Form as inline views. Initially they had the appropriate 'Add New' functionality on the UAD inline view and not on the RO inline view as I expected.
As soon as I add the 'Complete' property, I find the process breaks as the UAD inline view either refuses to show or does show, but doesn't have the 'New' record function on the inline view so no data can be added.
Most annoyingly, when I take the 'Complete' functionality and relevant 'show_if' code out, the UAD inline view does not re appear or if it does, it doesn't show the 'New' record functionality again. It's almost like the show_if functinoality is being kept somewhere within the background code - but it's really not consistent at all so that may be me reading far too much into it!
In frustration I put all the functionality back in and this time added the Childs data table (as well as its ChildRO and ChildUAD slices) back into the Parent View's Form using inline views. This Child table works as expected but not the UAD slice.
This is where I have it now and have taken the following screen shots to see if anyone can help or recognise it as a bug. You can clearly see in the Parent View's Form that the Child's table inline view has the 'New' record functionality, but the ChildUAD slices' inline table does not - even though the Add, Edit and Delete Update Mode is correctly set on the ChildUAD slice. Please excuse the formating of this post - new here!
Any help much appreciated to undestand why this is so random.
If anyone can take the sample app (Nested Forms) and mod and recreate the issue and share it, that would make it far easier to understand than my screen grabs.
User | Count |
---|---|
28 | |
14 | |
4 | |
3 | |
3 |