How to access and use TrackVia's API or Application Scripts?

← TrackVia API & App Scripts

Can Apps Scripts Populate Link-To-Parent Fields?

I am trying to populate a Link-To-Parent fields via Apps Script and nothing happens.

If copied the format from Drop-down fields, Application User, and Application User Group fields (thinking they would all behave the same), but although the Scripts saves with no errors, and the records can be updated with no errors, the LTP field is not being populated.

If this is possible, can you provide a sample of the code that I can use?

3 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
John McGarvey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Attach a File
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Matt Cox commented  ·   ·  Flag as inappropriate

    It is possible to have an app script link a record to a parent. I did it on the child table. You just have to know the parent record ID.

    So if Parent Table 1 creates a record in Child Table 1 have an app script on Child Table 1 to create the link to Parent Table 2. (if that makes sense and is even what you are looking for)

    Below is the code I used.

    Map record = loadRecord(Parent Table Name, Parent Table Record ID Name, Parent Table Record ID Value) as Map

    currentValues[Relationship Name] = record;

    you just have to be able to create the parent record ID value using information from the child table the app script is on. You have to be creative since app scripts cannot pull in information from calculated fields.

  • Skip commented  ·   ·  Flag as inappropriate

    This would be an amazing feature!
    Any solution to automate/calculate links would be very helpful.

  • John McGarvey commented  ·   ·  Flag as inappropriate

    Hi Alex,
    Some clarification.

    I am trying to populate a LTP field (not single line) via App Script at the same time the script is creating a child record. The child record is being created fine. The LTP is to a second parent table than the one that ran the script to create the child (this would already be auto-joined).

    I tried following the format of other "drop-down" type fields (drop-downs, User fields, and User Groups) thinking the format would be the same, but I am not able to get the LTP field in the child record to populate.

    There isn't any IF condition to evaluate as the will identify the actual value to enter into the field for each child record being created.

  • Alex commented  ·   ·  Flag as inappropriate

    Hi John,

    Application User and User Group fields are links to other tables in the system so they do behave differently than your standard single line field. This may be why the fields are not working as desired when trying to use them to link to a parent record.

    The script code to reference those fields is below:

    GROUPS:
    Map group = loadRecord("XVIA_USER_GROUP", "group_name", "group name goes here") as Map

    USERS:
    Map user = loadRecord("XVIA_USER", "email", "user's email address goes here") as Map

    Additionally, the script template below can be used to auto link to parent when the parent record ID is comprised of more than one field:

    Map parent = loadRecord('parent table name', [parent field to match: currentValues['child field to match'], parent match 2: currentValues['child match 2']])
    if (parent) {
    currentValues['Link to parent'] = parent
    }

    Hope this helps!

    Alex

TrackVia API & App Scripts: App Script

Feedback and Knowledge Base

(thinking…)