Skip to main content

Hi all,

 

I’m building an interface to help the tutors at our company guidance students in writing their supplemental essays for college. I have a base with two tables:

  • Table 1: US Colleges (which has a list of US colleges and what they each look for in applicants; the primary field being the college name)
  • Table 2: Supplemental Essays (which has the list of supplemental essays required for each college; the primary field being the essay prompt itself, and there’s a link record field to link each essay prompt to the relevant college in the US Colleges table)

The interface I’m building is a Record Review, and I picked Table 1 (US Colleges) as the linked table so that the data can be organized by college.

Everything works great when I’m editing the interface, but when I open the public view link, the records from Table 2 (Supplemental Essays) aren’t showing. 

 

How do I fix this? I’ve already allowed syncing for Table 2, but that didn’t solve anything. I’ve included screenshots below to better illustrate the issue.

 

Screenshot 1: Interface while designing & editing it, no issues 

Here’s a screenshot of the interface when I’m editing it. As you can see, the records from Table 2 (i.e. the prompts) are linked properly and are visible. This is how I want it to look.

 

Screenshot 2: Public Interface issue

Here’s a screenshot of the issue in the public view of the interface. As you can see, the college name and what they look for in applicants (which are both from Table 1) are visible, but the prompts (which are from Table 2) aren’t visible. View Data doesn’t do anything—it just tells me this action is only available inside the app.

 

 

Help!

Ah, unfortunately public links can’t display fields as ‘Views’ at this point.  As a workaround, perhaps you could use a formatted rollup field to display stuff?  The field below uses 

ARRAYJOIN(values, "\n\n")

Resulting in: