This might be covered elsewhere but I am trying to get an overview of what I can do with the forms. How advanced can I get with the user interface? Can I make buttons?
For example, let's say I have a table "Tasks" with columns A B C:
[pre]
A: Location ID
B: Task (varchar)
C: Finished (date/time)
Rows:
100 "Clean floors in kitchen" [null]
100 "Empty trash bins" [null]
[/pre]
The Location ID references a separate table.
Could I have a page that shows a list of rows from "Tasks" for a specific location assigned to the user and each task (row) has a button that says "Complete". When the user clicks "Complete", the current date/time is recorded for that row, in the Finished column. Ideally, that row would then disappear or at least, the button for "Complete" would no longer be there.
This would be preferable to having the user set the "Finished" date/time field manually.
For example, let's say I have a table "Tasks" with columns A B C:
[pre]
A: Location ID
B: Task (varchar)
C: Finished (date/time)
Rows:
100 "Clean floors in kitchen" [null]
100 "Empty trash bins" [null]
[/pre]
The Location ID references a separate table.
Could I have a page that shows a list of rows from "Tasks" for a specific location assigned to the user and each task (row) has a button that says "Complete". When the user clicks "Complete", the current date/time is recorded for that row, in the Finished column. Ideally, that row would then disappear or at least, the button for "Complete" would no longer be there.
This would be preferable to having the user set the "Finished" date/time field manually.