NetTalk Central

Author Topic: NetWebYear .. Add to already-populated Cell  (Read 5071 times)

Stu

  • Hero Member
  • *****
  • Posts: 510
    • View Profile
    • Email
NetWebYear .. Add to already-populated Cell
« on: November 23, 2011, 11:28:37 PM »
Hi Folks,

Decided to jump into the NetWebYear functionality this evening.

The first question that hits me, and after searching these forums + the netweb.clw code is:

How do I click on a cell to INSERT when there's already something in that cell?
- ie. Can you add another item to a cell already populated?

Anyone got this working?
Cheers,

Stu Andrews

Stu

  • Hero Member
  • *****
  • Posts: 510
    • View Profile
    • Email
Re: NetWebYear .. Add to already-populated Cell
« Reply #1 on: November 23, 2011, 11:31:30 PM »
Perhaps I've misunderstood a basic building-block of NetWebYear.

It seems you can only have one item per cell, regardless.

I went in and entered an item for today.

Then entered an item by clicking on yesterday but changed the date to today. Saving this overwrote the today's already existing item.

Is this the way it works?
Cheers,

Stu Andrews

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: NetWebYear .. Add to already-populated Cell
« Reply #2 on: November 24, 2011, 12:12:29 AM »
>> How do I click on a cell to INSERT when there's already something in that cell?

here's a better question - how would the system know whether your click was meant as an "insert new record" or "change existing record"?
If you want both, I recommend an Insert button nearby methinks.

Now it is possible to display multiple data sources on the same calendar. So I might have a "leave" calendar but show public holidays as well. In this case if I don't enter a "form" for the holidays there, then a click would fall through to "insert" a leave record.

>> I went in and entered an item for today.
>> Then entered an item by clicking on yesterday but changed the date to today. Saving this overwrote the today's already existing item.

I'd have to try that and see what it does.

Cheers
Bruce



Stu

  • Hero Member
  • *****
  • Posts: 510
    • View Profile
    • Email
Re: NetWebYear .. Add to already-populated Cell
« Reply #3 on: November 24, 2011, 12:38:57 AM »
Bruce,

Thanks for the reply, so quick :)

I can guarantee that the Sales team I work with will not think to look down at an insert button all the way down below the large month calendar.

Like Google Calendar, they leave space on a day/cell that is always able to be clicked on to create a new item. That's the kind of thing I was wondering if NetWebYear did, or could do in the future.
Cheers,

Stu Andrews

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: NetWebYear .. Add to already-populated Cell
« Reply #4 on: November 24, 2011, 01:44:30 AM »
perhaps...

AZIS350

  • Jr. Member
  • **
  • Posts: 62
    • View Profile
    • Email
Re: NetWebYear .. Add to already-populated Cell
« Reply #5 on: March 22, 2012, 11:45:12 AM »
A technique that I've used that has worked well for us is to have the form procedure for NetWebYear (with a parent table that keeps track of # of appointments per day), call a form whose sole purpose is to have an embedded browse related to the child table (which contains the actual appointment detail records). Just pass the date selected on the NetWebYear form as a parameter for the filter of the browse. The browse will have the standard navigation controls and add/edit/delete. So when you tap on the date of the monthly calendar, the form pops-up with a display of all appointments for that specific date. Works as normal insert/change from there just as any browse would. Has worked great for us and was how we got around the one record per day situation.

Pauly

  • Newbie
  • *
  • Posts: 26
    • View Profile
    • Email
Re: NetWebYear .. Add to already-populated Cell
« Reply #6 on: March 24, 2012, 08:05:27 PM »
G'day Stu,

I'm with Aziz350 - Add a child table, related to the record that is created on the netwebyear table, and put a browse and related update buttons on the form that pops up.

Pauly
 

Stu

  • Hero Member
  • *****
  • Posts: 510
    • View Profile
    • Email
Re: NetWebYear .. Add to already-populated Cell
« Reply #7 on: March 25, 2012, 05:50:45 PM »
Ahhhh! Thanks Folks! Great idea.
Cheers,

Stu Andrews