How to put check mark on Input Table and update the timestamp column

Please look at the screenshot and link. I need to put a check mark in the "OK" box and have it timestamp the "Time" box for each row. Is there some css or other way to do this?

Unfortunately the condition logic you wanted to apply will not work if using the Input Table field only similar to what you have. Calculation condition is available if calculations were to be done between the existing fields in the input table.

User guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

The alternative workaround you may want to consider is to use multiple individual input fields. This way you can create calculation conditions to get the timestamp value and put it on another field/column.

Example:

In the example image above, if the OK field is filled in, timestamp is calculated using conditions and then copied to Time field.

A more advance but can be complex for you is using the form full source code. When using the form source code, you can inject your own custom function code to trigger the timestamp script(javascript) and fill in the Time field.

I hope this help. Let us know if you need further assistance.

Good work around - Can you illustrate the steps to accomplish this.

In the example image above, if the OK field is filled in, timestamp is calculated using conditions and then copied to Time field.

Hi,

I am working on the steps,i will provide you with a solution shortly

Thank you

Hi,

Please follow the steps to use multiple individual text field to get the timestamp value and put it on another field/column

1.Drag Shortext Entry from Form elements

2.Then use the shrink functionality to shrink the size of the field and then in the CSS editor decrease the textbox height and width.

3.Then add a Date picker field from the Form elements and make it hidden , so it will not be shown to user.

4.So we will create a condition which will copy the date and time to timestamp field from the date picker field if the OK field is filled.

5.I  have created a test form to test the conditions.Feel free to clone it : https://form.jotform.com/81705669626972

If you make multiple rows will it stamp the new current time in each row? Meaning will each row reflect the actual time you entered the 1 in the OK field?

If you make multiple rows will it stamp the new current time in each row? Meaning will each row reflect the actual time you entered the 1 in the OK field?

Then we need to create another conditions for each OK field that if it is clicked then it will copy the current time.

I have modified the above test form to have multiple OK field,so now the form looks like this :

And i have added another condition which copies the current time when the second OK field is filled :

I have modified the existing test form to have multiple fields.Feel free to clone it.

https://form.jotform.com/81705669626972

Hope this helps!

I tried the test form. I waited 2 minutes between entries and both stamped the same time in the timestamp field. Both are using the time when the form was opened.

I apologize for the blunder. I also found a loophole in the workaround I suggested.

You can check the original form I used to test here https://www.jotform.com/81697609217972

The Timestamp value is being taken from a hidden Date field using calculation condition.

But unfortunately the Date field value will refresh once only -- when the form loads initially.

To refresh the timestamp, it will need to reload the form, which can be problem as it will also reset all existing value in the form.

To fix it, we will need to use a different field/widget that have running date/time value that can be used.

I will look for alternative workaround. I will post update on this thread when I have it.

Thank you.