Hi I would like to have one counter field which will be incrementing by 1 and at perticular time inverwal the field value would get reset and increment again by 1.Any suggestion please

I suggest that you write a formula that is time dependant. You would need to tell us when the counter would start (what date) and then at what interval it will increment. Also,. let us know if you are talking about incrementing in hours or days.

Thanks for your response Mike,counter has to be incremented as soon as record is submitted. it is numeric number. it will be reset on 1st April to 1 and started incrementing again.

Johib,
Sorry, but you will need to be much more specific.
You say that the counter starts when the record is entered.  Then are you wanting to count days?  Then are you saying that is resets back to zero every April 1st.  Please take the time to clearly express your question.  Often taking to the time to clearly express the question, leads to the answer.

Mark, i need the numeric value associated with each record...for example if i submit 1st record then counter field(numeric) should be 1...and if 2nd record is submitted then counter should 2..and so on...so from 1st April 2012  to 31st March 2013 if 300 records got entered then counter's value should be 300...now on 1st April 2013 counter should be reset to 0... and when the new record is added the value of that counter should be incremented as before....like 1,2,3,4.........

OK, so now we have a real question.
I suggest that you use a summary field to count the # of records (I will call them Orders) since the beginning of the April 1st fiscal year. We will create a new table with exactly one and only 1 record in it to hold the counter. It will have a summary field which will hold the counter.

There are a few steps.

1. Set up a new table to hold the counter, called say Order Counter. Create 1 record in it and then adjust the permissions for all the Roles so no one including the admin can add any new records. It will be [record id#] of 1.

2. In the detail Orders table create a formula numeric field with a formula of 1. call it say [Link to Order Counter Summary] it will calculate to the numeric value 1.

3. Build a relationship where 1 Order Counter summary record is related to all Order Records based n that numeric field.

4. Now we weed a formula to calculate the start of the fiscal year. Lets build this in the Orders table. Call it [Fiscal Year Start]. It will be a formula date field type

5. i have not tested this but the formula would be something like this


// determine the YYYY for the current fiscal year.
var number YYYY = if(month(today())>=4, Year(today()),Year(today())-1)
// the DATE function below will be April 1st of the current fiscal year.
Date($YYYY,4,1)

6. Now go into the relationship and make a summary field by clicking on the button on the left side of the relationship. Make it count the number of Orders, but put in a condition that the [order date] is greater than or equal to the value in the field [Fiscal Year Start].

Feel free to post back if you get stuck or my formula has any syntax errors that you cannot fix. Note that as soon as you build setup above the "counter" will immediately count for all existing records, so it will retroactively give you your summary counts for the current fiscal year.

thanks a lot  Mark

So, there aren't any computer programmers at Quickbase? It would probably be worth the money to hire one and fix this glaring hole in your software. Or just keep prescribing convoluted confusing complex fixes for a simple issue.