Hi Brendan (and everyone else)
I’ve created a linked form and display the inverse relationship field on it. It works perfectly but when I export the data to .csv the value in the linked field doesn’t show up – the field title does but not the content.
Please help as this is the final part of a project to get our call file data auto populated on a store checking file.
Regards
Ian
When you export the inversely-linked child form, you do get a “column” recording that the inverse relationship is shown, but TapForms doesn’t need any new data to accomplish that. At most, it’s a “note to self” on import that the inverse relationship is enabled for the form linkage.
The linked child form always has all the information TapForms needs to show the inverse linkage: the form and record UUID for the parent that links to it.
Please help as this is the final part of a project to get our call file data auto populated on a store checking file.
I’m not quite sure how to interpret this paragraph: but if you’re planning to create new records in the child form CSV to import, you need to be careful about the parent_form_id, parent_field_id, and parent_record_id, because that’s the form linkage as well as the inverse linkage.
If you’re trying to use the “inverse linkage” in the call record to identify the customer in some external application, it’ll need to understand a lot more about TapForms sqlite schema to get to the parent form record using the record’s UUIDs.
Thanks for the reply David.
I thought that was the case so have hit a stumbling block – if only the field could be referred to, I could at least return it somehow then.
OK, I’ll find an alternative way to do this.
The second element was that I import (manually) the data into excel for reporting purposes and need to know the parent forms “ID” to be able to compile the data for each store – with over 500 stores and multiple checks for each one, without it the data is meaningless.
I believe I can export the parent_record_ID and use this with a lookup in excel – not ideal but should work.
Thanks again for your help.
Ian
.
