If this display screen is connected on a computer running FileMaker, al you have to do is bring the correct layout on screen. The contents will be refreshed automatically when a change is made. This is built-im in FileMaker .
This is working pretty well - just have to remind users to activate the Time Script if they make any changes to the 'main display'. Otherwise it's working well!
Few little things to work on regarding conflicting records (Two users at the same time).
unless your agenda is a global repeating field with 100 reps which are filled via ExecuteSQL from the appointment database, like in our case...
All of FileMaker data is live on a FileMaker Server.
There is no view only screen in FileMaker but you can make yours a view only by selecting all the fields and disabling the data entry. You can also use Privilege Sets to disable editing but since you seem to be new with FileMaker let's just use this for now.
Did you try creating the List or Report and have users enter the data and see what the results are.
Try this script for the computer you want to be a previewer:
Script: Show Preview List
Go to layout xxxx
Show all records
sort by Get(recordid) descending (a calculated field number Get(recordid)) This puts new records at top of list
Assuming users are entering records in this table, you should see the new records after a bit if not immediately.
I have also used portals to show the CEO the new sales in real time of the sales staff. In otherwords you might be able to show several portals of information in real time. You can filter the portals to show new information entered or modified today, in an hour, etc.
Should have mentioned I"m using Network Sharing vs Server . . . . .
I succeeded with the Ontimer script - however I had to run it in a different layout than the primary layout - as other records would also be refreshing while editing them.
Took a few tries, but successfully
Thank you f