print table content from related table

[Sybille van Zuylen]

Hello,
I’m using tap forms to prepare coaching sessions.
I have a “session” table which is related to “activity” table.
Each session has several activities which are numbered in the order I want to do them.
From there, I am trying to prepare a “session summary” printout to give to the client where all activities and their descriptions are listed in the correct order.
So I made a new presentation (I’m sorry if the word is not right, I’m using the French translation).

My problem is I manage to display the “activity” table within the page, but its content is of course cropped in a way that makes it unusable.
How can I make a well designed text list of the activities related to my “session” record?

• This topic was modified 1 month, 3 weeks ago by Brendan.

[Brendan]

Hi Sybille,

On your custom layout, you can adjust the widths of the columns on your Link to Form field to make the related table look a bit nicer. You may also want to print in landscape orientation so you can get more space on the page for your columns.

What does it currently look like? Can you post a screenshot?

Thanks,

Brendan

P.S. I’m moving this topic out of the Scripting Talk forum because it doesn’t have anything to do with scripting as far as I can tell.

[Sybille van Zuylen]

Thank you for your reply.
Yes I figured I could change the column width, but my problem is that the fields I’d like to display have several lines and I can only get to see the first one.

See screenshot here: https://snipboard.io/G6RrNd.jpg

Is there a way to fetch the info from each activity and display their content as a list?

Thanks for your help!

[Daniel Leu]

I don’t know how long your objective description is, but maybe you can use markdown to format it.

Here’s a field script that fetches all the activities records and formats them as markdown.

You need to update field ids for the activity form and the respective fields. Additionally, define a summary field in your main form of type markdown.

When you update an activity record, the summary field is updated. The first line is the number and title, followed by the objective. Unfortunately, TapForm 5’s markdown implementation doesn’t support tables.

Hope this helps! Bonne chance!

function Update_Summary() {

	// define the field ids
	const activities_id = 'fld-xxx';
	const activities__number_id = 'fld-xxx';
	const activities__title_id = 'fld-xxx';
	const activities__objective_id = 'fld-xxx';
	const summary_id = 'fld-xxx';

	// get activities records
	let activities = record.getFieldValue(activities_id);
	
	let md = "# Activities\n\n";
		
	// loop over all activities and create the markdown entries
	for (activity of activities){
		let number = activity.getFieldValue(activities__number_id);
		let title = activity.getFieldValue(activities__title_id);
		let objective = activity.getFieldValue(activities__objective_id);
		
		md += `**${number}: ${title}**   
${objective}    
`;
	}
		
	// update markdown field
	record.setFieldValue(summary_id, md);
	document.saveAllChanges();
}

Update_Summary();

[Brendan]

Ya, I’m sorry, but the related table can only print a single line of the content. It doesn’t have the ability to increase the height of the row.

Daniel’s suggestion of creating a field on your parent form that contains the related data in a format that can be printed is a good idea. So you can still use the Link to Form field to enter your content, but have this other field on the parent form that is used for printing that content.

[Sybille van Zuylen]

This looks like exactly what I wanted to do, I will give it a go. Thank you so much!

[Author]

Posts