so im suppose to create an application that utilizes 2 tables, lets assume calling them “main” and “Approval”, when i tried using linktorow([Row_ID],“Approval”), the input fields of the Approval “form” does not get autofilled with the conditions of useremail() as compared to linktoview(“Approval”), is there a way i can get the form to still autofill but using linktorow method?
LINKTOROW() only opens a pre-existing Row in the view specified. This means any “autofill” action would potentially be “overwriting” the column value.
If overwriting is what you really want, you can do that using the “Reset on edit” property on any columns you wish to automatically reset on EDit. You can simply turn this ON or set an expression that decides under what conditions the “Reset” is applied. When “Reset” is activated, it will use the Initial Value expression to update the field on the Form view. Of course the LINKTOROW() function must be opening the row in a Form View in the first place!
Also, it might help to understand what you are trying to do. There may be better options.
For example, if you are automatically updating the USEREMAIL(), then it sounds like you might be trying to record WHO edited the record last. For this functionality, I like to have dedicated columns for Created By, Created DateTime, Edited By, Edited DateTime. The “Created” columns are set by Initial Value - so ONLY whent he row is added. The “Edited” columns are set with App Formulas so they are updated automatically whenever the row is edited.
I hope this helps!
3 Likes
Ah i see, let me try out the method you suggested, as soon as i confirmed the LINKTOROW() function actually ties to the correct row. Cheers!
@whlim ,
also you can use the GOTO action with the LINKTOFORM() function for form fields autofill. You will need to associate each form field with a value or expression. In some cases, this function is quite convenient.
1 Like
i am currently using LINKTOVIEW(), the only funtion right now that seems to be working as somewhere along the line LINKTOROW() is not appending the hardcoded values possibly due to row mismatch issue, but your suggestion do open up more options to experiment around and incoporate into the apps. Cheers!
@whlim
I wish you success!