Iโm having trouble with a LINKTOFORM action not quite working as I hoped. Here is the formula:
=LINKTOFORM(โQuote Log_Formโ, โDateTimeโ, NOW(), โDescriptionโ," New Quotation Created", โUserโ, USEREMAIL(), โQuote Numberโ, [_THISROW].[Quote Number])
This is actioned when a new Quote is saved. The Log Form opens and all the data is automatically input except for the Quote Number, which is the key column for the Quote just saved. Can you see where Iโve gone wrong?
Try to remove the [_THISROW].
Thanks @Aleksi_Alkio that did work. Iโm disappointed though that the autosave setting of the form only works if you click into the last item and then out again, and not if values are entered programmatically.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |