• Content count

  • Joined

  • Last visited

About vanderLeest

  • Rank
  • Birthday March 4
  1. Automated sequence number is child form

    Thank you Mathilda, for your quick reply and detailed answer Now I see there is in principle a way to do this kind of thing. My scenario is a two child forms embedded in a main form that aims to - in one case - associate Files to an Activity and in an other case Organisations to the same activity. I want to be able to add a (hidden) sequence number to each associated file, and each associated organisation in both a submission form and in a report detail form.
  2. I wonder if someone found or came across a way to add an automated sequence number (for example, in the form of the current record count) to a child form based on a one to many relationship, for example each interested person for a specific house gets a sequence number from 1 for the first entry to n for the most recent entry. For another house the sequence start again at 1.
  3. 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,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?