Changing multiple records in a field

[JD2775]

Hi,

I have a database with a portal layout that reflects a real-time grid used at work. The portal fills with unique ID's upon a specific Group ID that is entered. One of the fields in the portal is a date field, that when clicked on autopopulates the current date and turns the cell red.

One problem we are running into is when a day of data-taking is "missed" you end up with a number of records in a grid that need to be backdated one date. So you click on let's say 15 of them with a date of 10/20/11 but then you need to click on them again individually and a calendar pops up and you change the date manually, one at a time, to 10/19/11 for the ones that were "missed".

What I am wondering, is there a way to click on all the appropriate grids and then change ALL the dates at the same time, to a different date, rather than one at a time?

I also realize that a process change is needed so if a day is missed, you click those FIRST, change all the dates (hopefully at the same time), then click on the current date cells as you normally would.

Thanks

EDIT- By the way this doesnt necessarily need to be done on the portal layout itself. If there is a way to do it in the raw data, i.e., do a Find for Group ID 250 and Date 10/20/11 and change the date to 10/19/11 that would work too.

[comment]

I have a database with a portal layout that reflects a real-time grid used at work. The portal fills with unique ID's upon a specific Group ID that is entered. One of the fields in the portal is a date field, that when clicked on autopopulates the current date and turns the cell red.

I've read this several times, trying to form a mental picture of what it describes - but it came out blank.

Still, a shot in the dark:

Got to Related Record [ Show Related Only ]

Replace Field Contents [ Datefield ; Datefield - 1 ]

[JD2775]

Sorry Comment, I'll be more specific. This is a grid that represents a flat of pots that has seed sown in the pots. 4x8 portal 32 cells. FlatID and SeedID data is preloaded into the database. When FlatID is called on this layout, the grid populates with the SeedID's in the appropriate locations. All the user is concerned with is when the seed germinates. This is used on a iPad, when the seed germinates that particular cell (SeedID) is tapped, and the date field underneath it populates and turns red, a visual cue that that cell doesnt need to be checked the following day.

If a day is missed, and it is obvious a set of cells in a grid germinated the previous day, currently the only way to change it is to tap on those cells, then re-tap on them individually to override the autodate with another date. One at a time.

There will be those in a flat that DO germinate on that current date though so you wouldnt want to wipe out all 10/20/11. That is why you would probably need to do the missed ones first, run the script or whatever, then do the current date

Does that help?

[comment]

Well, I am still only barely following this, but how about setting a global flag first - something like "click here if you have missed a day"? Then if the flag is on, any cell you touch will be set to yesterday instead of today.