August 24, 200916 yr My problem is two-fold-I have a parent and child database establish. In the child dbf--there is a narrative text field called contactrecord-it expands with the users input (which can be long). In the parent database, I created a portal to pull in all the related records so the user can view all their contacts in one place. How do I make the "contactrecord" input field expand and shrink as needed in the child database? I also include the fields of date and time in the portal. How do I make the portal field expand and shrink based on the childbase field? I also include the fields of date and time in the portal. I am a beginner in programing the scripts-- portal.PDF
August 25, 200916 yr Portal rows are fixed in size in Browse mode. You can create a report based on the child table, and use Sliding to decrease the row height, based on content.
August 25, 200916 yr You could also place an 'expanded view' next to the portal - see an example here: http://fmforums.com/forum/showpost.php?post/333539/
August 28, 200916 yr Author Thank you for your replies-I am bummed the portals can not be scripted for resizing depending upon the field being pulled in. (But to be honest, I haven't even conquered the whole sliding field thing yet). In the database definitions, I did this (kind of proud of myself;) Case ( ContactType = "Phone call made to"; 1; ContactType = "Phone call rec'd from" ; 2; ContactType = "Emails sent to" ;3; ContactType = "Emails rec'd from"; 4; 0) And then I created If (CaseContactNote ≠ 0 ;VisitNote ;"" ) I already have a button scripted to go into the parent dbf-related record where the portal resides for viewing the records. But how do I script the button to only display the 1-4 notes in the portal and attach to the “go to” button?
Create an account or sign in to comment