THIS IS MY SHAREPOINT LIST COLUMNS
| | Date | Description of work being done | Road Number | Total Road Length | Start Point/ km | End Point/ km | Unit of Measure | Output achieved | Vehicle/Plant Registration | Hours Worked (if applicable) | Fuel | Comments (In particular to Variance, Corrective Action, Quality and any other pertinent information) |
|
THIS FORM IS BASED ON ROAD TASK AND IT COULD TAKE 1 DAY OR MORE TO COMPLETE TASK, TO AVAOID USER REPEATING ENTERING SAME DATA FOR THE SAME TASK IM TRYING TO RETRIVE DATA THAT IS PREVIOUSLY STORED ON THE LIST TO THAT THE USER DOES HAVE TO RE ENTER THAT DATA IF THEYRE STILL WORKING ON THE SAME TASK
FYI
FIRSTLY IF TOTAL ROAD LENGTH = ENDPOINT - THAT MEANS THE TASK IS COMPLTED
SECOND IF ROAD SO THE FORM MUST BE BLANK FOR NEW ENTERY FOR THE NEW ROAD TASK
SECONDLY IF THE ROAD TASK IS HAVE TO BE DONE THE FOLLOWING DAY , THE END POINT OF THE PRIVIOUS DAY MUST DISPLAY AS STARTPOINT AND THE END POINT OF NEW SUBMITTION MUST BE EMPTY AS WELL AS DATE AND OTHER COLUMNS MUST POPULATE THE FORM BY DEFAULT , SO IVE USED THIS FORMULAR ON THE ONVISIBLE PROPERTY OF THE SCREEN If(
previousSubmission.'TOTAL ROAD LENGTH' = Round(previousSubmission.'END POINT/KM', 3),
ResetForm(Form2),
Set(
previousSubmission,
Last(Filter('Internal Blading List', 'ROAD NUMBER' = Trim(DataCardValue45.Text)))
)
)
AND USE previousSubmission to display data on each datacard textbox and dropbox on the form, for example if i want to populate data from the list to textbox of Vehicle/Plant Registration , i just use the variable previousSubmission , like this previousSubmission.' Vehicle/Plant Registration ' , than data is from list on the column of Vehicle/ plant is populated on datacard textbox on the from
