I have an app where I need to select the dates for events. I have the parent table “Opportunities” and child table “Days.” The references look right, and the child table reference appears in the “Opportunities” form, but I can’t select a date when in that view. I’ve included screenshots but cannot figure out why I can’t select a date.
I’m truly stumped as I’ve created a date child record before and it’s worked, so I’m baffled as to why this one isn’t.
You need to take a look at the “Days_Form” view. That is the view that most likely is controlling the columns shown on the form AFTER tapping the New button. The only way it might be a different form view is if you created a custom form view for the Days table. If so, then look at that form view.
I hope this helps!
Appsheet says that the view is the one I screenshot, but if I look at the Days one, it also isn’t working. I do not have any slices on this particular data.
What exactly do you mean by this? Is some column not displayed? Is it displayed but you can’t change its value? It’s displayed but the dropdown doesn’t offer the expected dates?
What’s the name of the column?
It wasn’t the view we needed. It was the column list assigned to the view. The previous column list shown was for the Opportunities table.
In this Days_Form view, The Start Date, End Date, Start Time and End Time are NOT actual columns in your Days table definition above. Maybe they are Virtual Columns? But users CANNOT make entries into Virtual Columns so they will not show up on a form view unless they have been assigned a non-blank value by some expression.
In your Days table, you only have a Date column. If you need for users to ENTER Start and End Dates then you’ll need to split your Date column into a Start Date and End Date - i.e. add these as separate date columns to that table.
However, if you are using the Date entry to DERIVE the Start and End through calculations, then you need to add the Date column to your Days_Form view so a user can enter it.
I hope this helps!
Wow. I don’t know how I totally missed that the system had pulled fields from my Opportunities table instead of the Days table into that view. I got so frustrated that I just ended up making a copy of the app to see if I could try some things without messing with my original, and in making the copy, the system mapped the fields correctly without my intervention and the problem was solved.
So - solution is that the system-generated form had incorrectly mapped fields and those fields either needed to be removed and the correct ones populated, or it needed to be deleted and re-added so the system mapped correctly.
Thank you!
