I can’t seem to wrap my head around this one today, but I’m pretty sure it can be done.
I need to add a URL button. This button will:
Change the Billing Status field to Complete
Add new record to the same table. Two fields in the new record need to auto populate as follows:
Billing Start Date field populates to the day after the Billing End Date field from the previous record.
Billing End Date field populates to 30 days in the future from the Billing Start Date
This button will be placed in a table report for quick manager approval.
I need to place this button in a table report for the manager to approve the record without going into it. I don’t want the screen to refresh, so they can go down the whole table without having the screen reload. Is it possible for the button to only have the ability to be pressed once? I’d also include the Billing Status field in the table, so they could see that the button worked and that the status did indeed change.