Due to attachments restrictions is here the file with the changes made.

--sd

TimShtsReDoAgainMod.zip

Søren,

Thanks again. Excellent help. I'll get to work on it now.

I had already done everything you mention, with exception of the placeholder records. I figured it had something to do with records, as the RecordID in your original file was at #34. But I couldn't find any specific records, and when I recreated the file, I did not make any new records. I understand now why 'comment' called your Pling table Slots.

Question: Once those records have been created and the file populated with my providers records, can I delete the placeholder files without messing things up again?

Question: Another thing I had noticed in the Instant Web Publishing, (before being distracted by the Danish format issue), was the ability to enter data into the time in/out fields with file opened through a browser. Those fields should translate correctly into the html code and remain editable, is that your understanding?

You need to teach me how to say (write) Thank You in Danish.

John

Question: Once those records have been created and the file populated with my providers records, can I delete the placeholder files without messing things up again?

No they have to be there at all times!

Those fields should translate correctly into the html code and remain editable, is that your understanding?

You need to explain this, as it is am I not getting the meaning of it! Could I persuade make a quick snappie (screendump) to show where it is??

--sd

Søren,

I'll work on the web view a little later.

Somehow I missed how we had the portal show the correct number of days for the month. For example, Sept with 30 day, Oct with 31, etc. I've looked at all the calcs but something is awry.

John

Søren,

Never mind, I found the problem. I had the last relationship with the gBaseDate instead of the ShownDate. It looks fine now.

Now to try to get this into the browser. I'm very grateful for your help. I think I'm once again close to a useable solution.

John

One more little thing. In my previous file, I had a job type designation, physician or midlevel, with a unique assignment to each provider. I would like that designation, once assigned, to always accompany that provider for each record without having to be re-entered. Would this be another global field?

John

It looks like I'm talking to myself online.

Edited July 31, 200817 yr by Guest

It looks like I'm talking to myself online.

No - I read what you write!

Would this be another global field?

No - this means that the persons should be broken out in thier own table as well, with all their details!

--sd

Edited July 31, 200817 yr by Guest

Søren, I'm kidding, I know you read what I write and I'm very grateful.

No - this means that the persons should be broken out in thier own table as well, with all their details!

That sounds way too complicated to create for just a single field. Perhaps I could have in the entry form a field for physician, another for midlevel. And if the two fields were mutually exclusive, then I should be able to sort based on that designation, and the provider would only have to populate that field when a new month is created.

What do think?

John

I humbly dissagree, it could easily be a shortcut you later will regret you have done, think how handy such kind of structure would be in the selection of records you report upon, until now have only two selections been posible the unique person and all. But serious reporting might even have some faint hopes to group on jobs descriptions as well....

--sd

Now to get back to a couple simple questions I had earlier.

Question: In the gEmployee field , if I enter the field with the cursor and then use the drop down list, I get two names in the list. How can I avoid that? It places the name I selected together with the name already in the field.

Question: Once I get all providers user accounts set up, I need to find a way to prevent changes to the file, even by the user, after they have entered times and logged out. In other words, they cannot edit times once they have been committed and saved.

Thanks so much, John

The gEmployee is not something which should remain in the system, it needs to be a calc'field instead which gets it's data from the logging in....

--sd

Søren,

I humbly dissagree, it could easily be a shortcut you later will regret you have done, think how handy such kind of structure would be in the selection of records you report upon, until now have only two selections been posible the unique person and all. But serious reporting might even have some faint hopes to group on jobs descriptions as well....

Point well taken. If I create a table for each provider, sort of a contact list, how do I structure the relationship table. I will send you a copy of the file by private email.

John

The gEmployee is not something which should remain in the system, it needs to be a calc'field instead which gets it's data from the logging in....

You're right, the double names only happened when logged in as admin.

John

In your example file how would I modify the Calc Field "WithinSameMonth"

so that it only shows the first 15 days or days after the 15. For example (1-15) or (16 to end of month) depending on date selected.

I tried this, but I must have done something wrong as it does not seem to work.

Case ( RecordID ≥ 15 and Month ( gBaseDate ) = Month ( ShownDate ); RecordID; RecordID ≤ 15 and Month ( gBaseDate ) = Month ( ShownDate ); RecordID; "" )

Edited January 20, 200917 yr by Guest

I didn't put this example together Soren did. I'm not sure if, in 8.5, you can name objects (See my signature) :

Take a look at the attached. If this could work for you try it. If 8.5 has an object naming capability then I would place one portal below the other in a tab, name the tab and use your formula to go to that tab.

I'm sure Soren, if he reads this post, will have a more elegant way to do it.

hth

TimShtsReDoAgainMod_1-20-09.zip

Thanks and apologies to Soren.

Interesting idea using two portals.

Just out of curiosity can any let me know why the calculation in my previous post (#315136) does not work.

I'm not that great with complex calculations. Let's hope someone else can answer your question.

However, I don't see how that calculation would give you any result within a portal. I would think your approach should be through a find in a script.

Even on the layout it does not work correctly.

TestTimeSheet.fp7.zip

Ok, I believe I have solved it with the following Calc. in the WithinSameMonth field.:

Case ( Day ( gBaseDate ) ≤ 15 and Day ( ShowDate ) ≤ 15 and Month ( gBaseDate ) = Month ( ShowDate ) ; RecordID;

Day ( gBaseDate ) > 15 and Day ( ShowDate ) > 15 and Month ( gBaseDate ) = Month ( ShowDate ); RecordID; "" )