OK you advanced guru's

[mentairia]

I need a way to automate the Start date and end date to autofill out the database form I have included.

I have set up all I need working. Do not worry about zones and add size at this time just get it to fill out month and year. As I already have Zone and add size working. I have tried several approaches with no results. Hope you all can help me out

Thanks All

Tony D.

FIXME.zip

[Søren Dyhr]

It isn't obvious what you want to be achieved, but as it is, do you not go easy on the number of global fields, to an extend that I would dare to say you not fully have embraced what to use this tool for and why.

Somewhat is a certain sence of structure missing...

--sd

[sbg2]

I could have sworn I replied to this thread, did you delete a post or did I not follow through with my post all the way?

Anyways, as Soren suggests you do not seem to be utilizing the full capabilities of relational databases. Normally when you start adding numbers to the end of field (Item1, Item2, Item3) the fields belong in a related table. Examine the attached example.

DateRanges.zip

[-Queue-]

I still recommend you hire a developer or at least meet with a developer in person to discuss your solution. It seems to be getting much more convoluted than should be necessary, and will only become more difficult to manipulate the more complicated you make it.

[mentairia]

I refuse to believe a person with a 152 IQ granted not chart topping but Very High! Cannot learn this whole program from trial an error and your help at times.

Let me explain why there are 1-12 on all and 1-4 on each of the 12.

1-12 is no doubt the months

1-12 on the zones is per the month as well

1-4 on each month is for ad sizes

See I need a way for

X COMPANY

june [a c e]

1/4page fullpage

July [a b c]

fullpage

So I am not truely using global fields in my solution at all. I just did on the quick sample I made. I need all of these bacause just like I showed you in the sample above I need to be able to set differnt zones and ad sizes per month and have it all on one page so if there is a way to portal that plz teach me.

Thanks

Tony D.

I am taking a look at date-range now!

[mentairia]

I am using this to extract old data only one time from an old piece of software we are using so this date range thing is one time only and not part of the solution. That being said I see a way what you did could work for me but I need some info. Is there a way to do leftword rightword on 1 field in a portal. If so how do I do it as I have often wondered how to pick data out of a portal if it all has same primary key.

Thanks

Tony D.

[Søren Dyhr]

I refuse to believe a person with a 152 IQ granted not chart topping but Very High! Cannot learn this whole program from trial an error and your help at times.

Even I with an IQ around a whopping 85 found the need to dwelve into relational database principles ...not expecting to stumble over it by accident.

You still havn't given us mere mortals a clue, what you're trying to do??? What data are storing where and why ...databases is by some called "Vessels of meaning" ...but you're throwing us all down in the darkest corner of the engine-room, where we're just asked to "polish" not WHAT to polish ...blind obedience is expected!

--sd

[mentairia]

ROFL Ok Man

first download my sample.

Step 1: I need the ability to set a start month and based off of that start month build a 12 month dynamic calender.

Step 2: I then need the ability to specify what zones and ad sizes will be used for each month.

Step 3: I need to import all data from our previous program to avoid having to data entry every contract that is still current manually. The old data has a start date and end date. All the zones and ad sizes are already set up and ready for import.

Step 4: Figure out how to make a date range create a start month in the start month field.

Step 5: Discover a way to check the boxes beside the months the add is suppose to run.

Done!

Ok just sitting here typing I thought of an idea. Is there a way to set the start month and year from the start Date. Which will create and fill out the dynamic calander. From that do a calculation that will tell me the number of months from the start date(01-01-2005) to the end date (06-30-2005)and I can just tell the program to fill out the corresponding checkboxes since my checkboxes are numbered. [Just a note no contract is longer than 12 months.]

Thanks Again

Tony D.

[mentairia]

ROFL Ok Man

first download my sample.

Step 1: I need the ability to set a start month and based off of that start month build a 12 month dynamic calender.

Step 2: I then need the ability to specify what zones and ad sizes will be used for each month.

Step 3: I need to import all data from our previous program to avoid having to data entry every contract that is still current manually. The old data has a start date and end date. All the zones and ad sizes are already set up and ready for import.

Step 4: Figure out how to make a date range create a start month in the start month field.

Step 5: Discover a way to check the boxes beside the months the add is suppose to run.

Done!

Ok just sitting here typing I thought of an idea. Is there a way to set the start month and year from the start Date. Which will create and fill out the dynamic calander. From that do a calculation that will tell me the number of months from the start date(01-01-2005) to the end date (06-30-2005)and I can just tell the program to fill out the corresponding checkboxes since my checkboxes are numbered. [Just a note no contract is longer than 12 months.] Also my sample already has solved step one and step two.

Thanks Again

Tony D.

[Søren Dyhr]

Alright this is a kind of gantt charting, perhaps you should tear this appart:

http://www.fmforums.com/forum/showtopic.php?tid/139792/

As i recall it do I make a calender via repeating fields as key-values and makes it spread the appointments over the view.

Since you're on 7Dev could custom functions be made into handling the same. But basicly is it to make a series of key values that pulls the same record into more portals resembling a calendar.

--sd

[sbg2]

Ok just sitting here typing I thought of an idea. Is there a way to set the start month and year from the start Date.

MonthName(StartDate) & " " & Year(StartDate)