trouble tracking down $$sc_FieldForContactID failure

Notes on our latest calendar for FileMaker 13,: DayBack
Posts: 7
Joined: Wed Aug 18, 2010 8:46 am
Location: Bonny Doon CA
PostPosted: Fri Jan 27, 2017 2:00 pm
$$sc_contact.png
presumably this is the focus of fault
$$sc_contact.png (168.32 KiB) Viewed 5115 times
Dragging & Dropping an event quit working and I'm perplexed.
I've looked at every field setting and name on Source No 1 (only one)
studied the matrix of variables best I could:

LayoutObject/Names=
Let ( [
desiredobject = "SourceContactID" ;
valuenumber = PatternCount ( Left ( $sc_SourceObjectNames ; Position ( $sc_SourceObjectNames ; desiredobject ; 1 ; 1 ) ) ; "¶" ) + 1
] ;

$sc_SourceObjectNames= Substitute (
LayoutObjectNames ( "" ; $sc_LayoutName )
; [ "<¶" ; "" ] ; [ ">¶" ; "" ] ; [ "¶¶" ; "¶" ]
)

sc_FieldForContactID
If ( GetValue ( $sc_SourceObjectNames ; valuenumber ) = desiredobject ; GetValue ( $sc_SourceFields ; valuenumber ) ; "" )
)

amazed it just quit, probably with some colon missing or some such.

any advise on plan of attack ... I'm miffed.
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Jan 27, 2017 2:20 pm
Hi Tom,

Thanks for the screenshot! It looks like the contact id that you've mapped on the Contacts tab of your Source No 1 layout is incorrect. That should be mapped to the contact id field in your EVENTS table: something like SampleEvents::id_contact. (Where "SampleEvents" is the table occurrence upon which your Source No 1 layout is based.)

It should not be pointing to the contact id field in your contacts table, which is what it looks like is going on in that screenshot.

So I'd head over to your Source No 1 layout, go to the Contacts tab, and double click on that contact id field: selecting a field from the local table instead of from Contacts.

Hope that helps!

- John
John Sindelar
SeedCode

Return to DayBack Calendar for FileMaker

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: