NetTalk Central

Author Topic: Browse refresh first record  (Read 4608 times)

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
Browse refresh first record
« on: August 23, 2017, 02:47:13 PM »
Hi Bruce,
I have a dedicated web browser app displaying a browse.

I am filtering records that are to be  displayed  using the template filter and a timer set at 2000,
the idea being that when a record meets the filter requirement, it displays.
I have not set any of the refresh options for the Timer.


My problem is not being able to  display the first record in the browse.

It does not populate automatically, and to get the first record I need to close and reopen.
I am not calling the update to the browse
Once there is a record displaying, then subsquent ones auto  load as expected.
I do have Update on Change ticked on, in the Update Form Change.

Can you help with a solution please ?
Thanks Bruce
Regards,
Richard
« Last Edit: August 24, 2017, 01:04:06 AM by Richard I »

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
Re: Browse refresh first record
« Reply #1 on: August 30, 2017, 09:41:14 PM »
Sorted
Have but a browse on a login form with a filter and timer
The login process populates the browse.
Cheers
Richard


kboller

  • Newbie
  • *
  • Posts: 24
    • View Profile
    • Email
Re: Browse refresh first record
« Reply #2 on: September 13, 2017, 12:10:20 AM »
Hi Richard,

    Do you mind sharing how you did the browse auto-refresh?  I need to have a browse auto-refresh when new records are added in an application I'm working on.

Thanks,

Kurt

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Browse refresh first record
« Reply #3 on: September 13, 2017, 04:23:14 AM »
I feel like this got answered just recently somewhere.

the setting is on the Advanced tab, both the Timer, and also the refresh location.

cheers
Bruce

Richard I

  • Sr. Member
  • ****
  • Posts: 398
    • View Profile
    • Email
Re: Browse refresh first record
« Reply #4 on: September 13, 2017, 07:17:39 PM »
Hi Kurt
Happy to reply...
But probably best to outline what my need is...
I have a NT  login app where Students scan a card for a meal, in a hostel dining room.
The scan records the meal for reporting numbers and returns an alert if the student has reported a food allergy.
a p_web message confirms the approval of the meal if other conditions are met.
( the message is always red.... it would be good if the message background colour could be set say Green for Go and Red for warning.....)

Where it was going wrong was that the alert effectively stopped the flow of students past the scanning point.
hence the need to remove the alert but still provide a way of ensuring that the student was not going to have an anaphylactic shock should they eat peanuts or tomatoes or whatever....

So the idea of a Browse showing name , student  photo, warning icon and a check button.
I needed the browse to refesh on a timer  each time a student scanned.
with the most recent scan on the top of the browse.
The check button wrote code for  audit  date and time of check.and removed the record row from the browse by filter
All good but couldnt quite get it
I tried file loading and page loading
File Loading  was best except I couldnt control the number of rows in the browse  bearing in mind that the system processes  approx 350 meals in 2 hours
page loaded  did give me the last record row first but the refresh was clunky
and the check option didnt remove the row record until the page was refreshed by another scan
So I have settled on File load  with the Timer set at 1000
When the check is selected   the timer removes the record using the browse filter

So Kurt if you want page loading then set the timer and select  "First"  from the option field under the timer field. this will give you the latest at the top.
You will also have to check the option to refresh the whole browse
Thats it ...Ive yet to see how we get on with an expanding browse should the attendant not check...


happy to ScreenConnect in and help if you need it.
Cheers,
Richard