I received a great deal of help with this project and am trying to put an idea into practice. This is a Gig management solution. The portal in this layout contains a song ID (which pulls the song title from a catalog), the set and slot number (for the place in the performance for that song). The to…

For reasons I don't understand, clicking the button in the portal record to invoke the script does not actually pull the portal record in the card layout, but instead pulls the first record in the portal. While I think I should be able to do all of this in one script, I just cannot make it work. Th…

Make sure that the button is completely within the portal row. Click in layout mode the portal and move it with an arrow key. If the button moves also then it is connected with the portal. If the button stays at the same place when you move the portal, then you have to size the button a bit smaller …

I've verified it. the button is completely inside the portal and repeated on each portal row. [image]

Not sure if this is a workaround or an an expected method of handling the multi-line entry issue, but I created another field in my table called RosterDisplay. It's a calculated field based on the Roster field (which has checkboxes entered on separate lines). I used the calculation "Substitute ( Ros…

What is the name of the portal TO? And what exactly is in the ScriptParameter that the button passes to the script?

the portal TO is gigs_PERFORMANCES. I wasn't using a script parameter at all, but then tried gigs_PERFORMANCES::PerformanceNo=$$PerformanceNo which also didn't work.

When I used a script trigger on the card layout and performed a find for the performance number, it worked.

In a curious twist, the card/script won't work on the last-entered portal record. I have three fields to enter on the portal row - songid, set and slot. These, along with the GigID, PerformanceNo and Songname are passed on to global variables. The top fields are globals. The field at the bottom is…

When you didn’t use a ScriptParameter, how tried you the invoked script to let know the context respective the desired target? "gigs_PERFORMANCES::PerformanceNo=$$PerformanceNo" as ScriptParameter means the script gets only the information if this is true or false – no context – only 1 or 0. And…

In the relationship graph you have allowed creation of new records via this relation. Then in a portal always the last row is an empty row where you can create a new record in the related table by entering values in one of the empty fields.

Grabbing and entering checkbox choices in a list

Questions

Malcolm April 15, 2021, 1:49am 40

Start here: Passing Script Parameters

Topic		Replies	Views
Selecting the portal row Questions scripting , portal	8	816	April 18, 2021
Revisiting portals, relationships and more Cases Study music-industry , identifying-entities , anchor-buoy , join	71	1281	March 5, 2021
How to archive checkboxes (& their values) and replace them? Questions community , filemaker	32	348	March 5, 2025
Multiple selection to filter record Questions	34	684	July 5, 2023
People table and role table to be joined: call for suggestions Questions joint-table	22	475	March 2, 2023

Grabbing and entering checkbox choices in a list

Related topics