Getting JavaScript to run properly with IOL
Hi everyone, I have two tables, one that has a full list of records, and another table, [Modified Records], where a record is added to [Modified Records], which is triggered every time a record in ...
Forum Discussion
I would imagine there are four fields associated with your primary table:
Assuming [start date] and [end date] were always entered and there were no overlaps between records the script could sort the records in ascending order and fill in the missing mileages. If the [start mileage] was missing it could be filled in based on the prior record's [end mileage]. Likewise if the [end mileage] was missing it could be filled in based on the next record's [start mileage]. There would be some cases where you could not fill in missing mileages if there was a span of records where neither start or end mileages were recorded,
To implement this I would place a button atop the relevant report and when the button was clicked it would calculate the missing mileages, throw up a dialog box to confirm the changes, make the changes and reload the page, The interface might look like this in terms of a button atop the report but without the checkboxes (process all records in the report):
Process Selected Records
https://haversineconsulting.quickbase.com/db/bkfwuwx2p?a=td
[start mileage]
[ending mileage]
[start date]
[end date]
Assuming [start date] and [end date] were always entered and there were no overlaps between records the script could sort the records in ascending order and fill in the missing mileages. If the [start mileage] was missing it could be filled in based on the prior record's [end mileage]. Likewise if the [end mileage] was missing it could be filled in based on the next record's [start mileage]. There would be some cases where you could not fill in missing mileages if there was a span of records where neither start or end mileages were recorded,
To implement this I would place a button atop the relevant report and when the button was clicked it would calculate the missing mileages, throw up a dialog box to confirm the changes, make the changes and reload the page, The interface might look like this in terms of a button atop the report but without the checkboxes (process all records in the report):
Process Selected Records
https://haversineconsulting.quickbase.com/db/bkfwuwx2p?a=td