URL Formula Field: Press to Complete
URLRoot() & "db/" & Dbid()
& "?act=API_EDITRecord&rid=" & [Record ID#]
& "&_fid_99=" & Today()
1. I have this formula setup on my Tasks table(child). In My project table when someone goes in and click on the button Complete, it changes the status field(12) to completed and changes the Completion date(99) to today's date but instead of redirecting it back on the same project page, after clicking this button it is taking them to the view record page(it is working) but I want the user to stay on the same page after they click complete. so in an ideal world, click on the button, change the status, put the completion date and stays on the same page.
2. Second issue, my formula puts todays date but then it wipes out the next day so that date is not sticking on the task record.