Forum Discussion

Qrew Assistant Captain

7 years ago

Was a record created through a form, grid edit, or API_AddRecord?

I'd like to have a field that shows the following three text options: Form, Grid, API Is there code that can detect how the record was created and paste one of these three results into my desired f...

Account and realm management

APIs and custom code

App builders

JohnRogers3

Qrew Trainee

7 years ago

Create a table called source. In that table make the records have a numeric value tied to each source. 1 = API 2 = form and 3 = grid. Place the related lookup field inside of your record form where you are wanting to track how these came in. Now when they do the api edit record call add their field ID to the call and the number is value 1 to be sent over. Same with the form. And with grid edit just make an action or automation that basically states if it comes in without a source then write grid edit in source, since you only have 3 options and the other 2 are taken care of.

There is probably a simpler way, but this way would be 100% automated.

JonathanHeuer
Qrew Cadet
7 years ago
Interesting, but why would you need a new table? What about a multiple choice field with the three options:
Grid Edit (this is default value)
API (set this as part of any API call)
Form (use a form rule to change to this under appropriate circumstances)
JohnRogers3
Qrew Trainee
7 years ago
You technically wouldn't, I just did that because it is more organized incase future development your source becomes 30 instead of 3. Always build now, that which will work later without having to re-do :D!
JonathanHeuer
Qrew Cadet
7 years ago
Good point John