3 Replies Latest reply on Mar 12, 2013 2:50 PM by phanh

    Display data in portal with separation model

    phanh

      We have a volunteer database designed using the separation model and have issue displaying data in a portal. Needless to say, we are new at this separation model.

      The pic below shows that we have two tables: volunteer_data and volunteer_data_inout (pic #1). The layout is set to get data from the volunteer_data table. Data in the portal is set to get from the volunteer_data_inout table (pic #2). The problem that we have is not able to display the data in the portal (pic #3). We spent time researching the issue but other posts seems to solve more difficult issues (such as auto-calculate the total). What are we missing?

       

      Thank you for any advice,

       

      Screen Shot 2013-03-12 at 10.31.41 AM.png

      Screen Shot 2013-03-12 at 10.57.41 AM.png

       

      Screen Shot 2013-03-12 at 10.55.56 AM.png

        • 1. Re: Display data in portal with separation model
          fitch

          I believe you need the table occurence name in the merge field, not just the field, e.g.:

           

          <<table::field>>

           

          Try inserting the merge fields again (or just use fields).

          • 2. Re: Display data in portal with separation model
            pthomas

            As fitch said you need to add the TO name into your merge fields.

             

            One trick that can be very useful when you have limited space as will be the case for you once you have added the TO names is that the formatting for the merge fields is based on the format defined for the first "<".

             

            This means that you can change the font size for the remaining part of the merge field:

             

            <<tablename::fieldname>>

             

            Will show the merge field data at 14 point and bold even though the rest of the merge field is 8 point and not bold.

             

            If needed you can input a custom text size of 1 point for the remaining characters in the merge field to ensure you have enough room to fit the fields inside the portal.

             

            HTH.

             

            Paul.

            • 3. Re: Display data in portal with separation model
              phanh

              Thank you, Fitch! I know it is something very basic :-)

              and thank you, Paul. That is a neat trick to get a better text layout.