Linktoform Bug?

[SKETCHwade]

Hello,
I think I’ve come across a bug.
I am using a time column that is not editable has no formula or initial value.
I am using an action and linktoform to determine the columns value.
Link to form is working correctly as it shows the form with the correct column and value.
When this form is saved the data is not uploaded to the sheet though.

This is the result of the action:

The Start time is clearly 1:32 PM which is correct.

Hitting save I see this data in the spreadsheet:

The start time was not uploaded.

[Suvrutt_Gurjar]

Hi @SKETCHwade,

I believe you may wish to share the column settings of the [Start Time] column in the AppSheet editor as well as in the back end data source.

From the picture you have shared, it sounds that the app is capturing both the start and end time because the duration column [Duration] seems to have been properly updated in the backe end record. You probably have the expression of [Start Time]-[End Time] for the duration column.

Edit: Sorry, I missed that you mentioned the column is non editable. Could you please make it editable?

[Bahbus]

Suvrutt_Gurjar:

Could you please make it editable?

It needs to be editable to be able to be set in such a manner as you described. However, if you wish for it to merely not be directly editable by the user in the form, use the Context("ViewType")<>"Form" in the Show If on that column. The action will set the value, but won’t show it to them on the form (so the user can’t try to change it). The value will show up in every other view.

And, lastly, if you really, really want it to not be directly editable by the user, but DO still want to display it in the form, then follow all my steps above, and create a new Virtual Column. Set it’s app formula to [Start Time] or whatever the original column is called. And make the Virtual Column Show If the opposite: Context(“ViewType”)=“Form”. Now it’s a win-win.

[Steve · Accepted solution]

Instead of setting Editable? to OFF, set it to the expression, FALSE.