Jump to content

output JSON array

Recommended Posts

Hi, I want to output a parent record and its linked child records (a variable number of records) as a JSON array to display in a html page that consists of sections.  Each section contains one or more fields from either the child or parent record(s).

I would like to be able to push the data upon clicking a button.


Following is an example of what I mean. (NB: The actual Parent Table has 10 fields and the Child table has 60 fields, including some that are formula fields).


Parent table fields:

FIELD:             PID                               PF1      PF2                  PF3

TYPE                (autonumber)             text      date                 number


Child Table fields:

FIELD:              CID (autonumber)       PID                   CF2      CF3      CF4                  CF5

TYPE                (autonumber)             integer            text      date     number           checkbox

PID is an Integer field and relationship linked to same field in Parent table.

Section 1





Section 2

[CF2-record1] [CF4-record1]

[CF2-record2] [CF4-record2]

[CF2-record3] [CF4-record3]


Section 3

[CF5-record1] [PF1]

[CF5-record2] [PF1]

[CF5-record3] [PF1]




It would be much appreciated if someone can assist by providing some instructions and javascript if needed.  Many thanks!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...