New Bug Encountered: LINKTOROW([Key],"View") with Non-Existing Key Value

LINKTOROW([Key],"View") goes to a blank form if supplied a non-existing key value.

This would be helpful, by allowing you to create the record if one doesn’t already exist with that key.

However, the [Key] value is not passed to the form, and more importantly, the Key-column’s initial value is also ignored.

Screen Shot 2020-04-10 at 3.03.20 PM

This means that if your [Key] is hidden from the form the user is unable to save.

Many APIs will automatically convert a PUT (update-record) into a POST (create-record) if the provided Key is not found, and vice-versa for a POST when the Key already exists.

I think this would be a useful feature for LINKTOROW() to automatically switch to LINKTOFORM() when the provided Key does not exist, but the key-value needs to be filled in somehow.

2 Likes