Jump to content
  • 0

child forms on a datapage using direct links


vanderLeest

Question

I am trying to create child forms and combine them on a single report details DataPage to enable data entry and updates into related tables that have a One-to-Many Relationship with the Main Data table.

I got the idea from this YouTube video, except for the fact that I want to use Caspio direct links, not embed the child forms in an external page. The first comment on the YouTube demo is: Is it possible to combine those without using an outside website?and the reply is  “It is possible to combine them using Caspio's direct links, but that's something that our support team will need to show you.”

I asked my point of contact via email and he suggested ‘You may try to deploy child forms (use iFrame deployment code) in the Header\Footer\HTML block of the parent form. To filter a child form you may use the option of receiving the ID parameter on a page on load. ‘

Sadly this doesn’t work.  I have also tried to pick up the Id from the main page but that url shows as 

https://c4ffn695.caspio.com/dp.asp?appSession=76482739590823598589657321597597834513223740109360725456536771070521751291354582292557258285423955632065563132573471180313620233&RecordID=1113,5358,147,3,86,0,107,63,33,104,34,1,18,95,101&PageID=8&PrevPageID=2&cpipage=1&cbCurrentPageSize=25&Mod0LinkToDetails=True

And the RecordID embedded in this url does not match the primary key in the Main Table.

Does anyone have an easy implemented solution for my problem?

https://www.youtube.com/watch?v=sgIaAeZxmy8

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi vanderLeest,

This may be an old post but if you are still trying to get that done, I think this could help you.

You can have virtual fields to get the data from your users. Then with the API, you can send whatever fields to whatever table on form submit for example.

I have created some forms that all data is entered in a single form but data is being sent to multiple tables.

I hope it gives you some light.

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.

Guest
Answer this question...

×   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.

Loading...
×
×
  • Create New...