
Announcements
I have created a sharepoint list based app.
Getting right to the app - Screen 1 Records the username of individual access the app automatically and the Submit Form in Screen 1 submits the Step1 Username.
In the Sharepoint List a separate time column is created and the time is autopopulated based on the when the form with username step 1 is submitted.
=IF([Step 1 Username]<>"",NOW(),"")
Now moving to Screen 2 is the step 2 Username record and the Submit form button submits the form with datacard for Step2 username.
But what happens in the sharepoint list is it updates the Time to time when the Screen 2 submit form was submitted for both Step 1 and Step 2.
How can i prevent this from like Once Step1 time is inputted it should not update the column when the form is submitted again?