Subform Help

Subform Help

I have looked over the example provided (Meeting Tracker) for how to implement subforms, but it's not working for me in two ways.

First, perhaps this is simple, how do I get the form Add Attendance to open as an overlay div and then disappear when the form is submitted, the way it happens at http://creator.zoho.com/sampleapps/meeting-tracker/#View:Meetings1. ; The code that I have seen on the site for implementing this does not do this. Instead, the form opens as a popup, new window, etc.

When I create the script, it asks me how I want to open the form, with the choices:
  • same window
  • parent window
  • new window
  • popup window

None of these work the same way as it does in Meeting Tracker.

Unfortunately, I can't look at the underlying code of the Meeting Tracker to figure this out.

Second, i cannot get the Add Attendance button to select the corresponding item from the parent table.  In the example, the Add Attendance link includes:  meetingid= ... input.id.  However, there does not appear to be a field called meeting id in my child form that is a drop down/lookup field containing text of the Meeting Name.

For example, in my main Meeting table I have a field called Meeting Name.  Under the hood, there is an ID field for this table too (the input.id field referenced above).  In the child table, Attendance, I have a lookup field that points to Meeting.Meeting_Name.  When you are in Attendance, you can select the corresponding Meeting Name.  But when you click on the Add Attendance button, it can't match the meetingid value to Meeting name, because one is the int value of the parent entry and the other is a string value.  I changed the Attendance form to include a lookup of Meeting.ID (instead of Meeting.Meeting_Name), and I called this lookup field meetingid. In that case, Add Attendance selected the appropriate Meeting ID, but it's very ugly because the Add Attendance form simply shows the 12 digit (or whatever) Meeting ID, not the Meeting Name, which is not very helpful.

I need a way for the meetingid in the url to link to meeting name.  Do I need to change my Add Attendance form to include both the Meeting ID and Meeting Name, but to hide the Meeting ID from users and, using deluge script, show the Meeting Name that corresponds to the selected Meeting ID?  If so, none of that is in the example.