previous event, next event
Hi!
I've a lot of events in the table EVENTS, and I'd like to show in another table, called BAND, the last and the next event for each music band.
I write in two fields of BAND table:
first(EVENTS['Start date' > today()])
last(EVENTS['End date' < today()]
... but it doesn't work :-(
....can someone help me?
Thanks
14 replies
-
@Birillo.. SOO CLOSE...
If you have a band view of
Next Event would be..
Previous event would be....
(I will let you do that one. You want the LAST EVENT where the end date is less than today.. or potentially equal to today.. depending on your use case).
-
thank you!
I've written the code suggested but appear "TABLE NOT FOUND: EVENT" .... how is it possible??!?!?! What do I mistake? Sob....
-
I thought your table name was "EVENTS" .. with an "S" on the end?
-
no no, "S" forgotten here, but written correct in the database....
:-(
-
Please post screen shot of data model and code.... The error message is saying it cannot find the table named EVENTS.
-
Here is mine.. Events have a composit relationship with Band..
-
My table are connected in a different way... is this the problem? -
Hmm.. Doubtful.. Mine was a composit .. but it works the same.. What does the code look like on the Band form for Last and Next event?
-
there's always "something" not found ... :-/
-
But Events appears in the left column (even if not visibile in the screenshoot) and Band is the table in which I'm writing the formula
-
Try this .. do NOT prefix 'Date termine' with the table name... It is implied that you are refering to the database column. So rather than
Events.'Date termine' ... just use 'Date termine'
As for the Band error... Same as above.. strike the Events. prefix... Second.. please show me where "Band" exists on the left column.. Notice the it looks like it is interpreting the line a "B" and .. based on color coding. I looked in mine.. it does the same....
-
@Mconneen
"Try this .. do NOT prefix 'Date termine' with the table name... It is implied that you are refering to the database column. So rather than
Events.'Date termine' ... just use 'Date termine' "
Try it, simply empty answer :-(
"please show me where "Band" exists on the left column."
"Band" doens't appear in the left column becouse is the table into which I'm writing the code
-
@Birillio... I have got you close.. but am flying a bit blind here.. Might be time to scheudle a support call.. They are FREE.. and worth while..
Scroll down.. and click Schedule a Meeting.
-
ok, and thank you a lot for your suggests :-)
My table are connected in a different way... is this the problem?
Content aside
- 4 yrs agoLast active
- 14Replies
- 2877Views