July 16, 2021

willwitman · July 17, 2021, 12:40pm

Deployment Time: 01:04 PM PST

Features & Enhancements

*Item*	*Description*
Feature	Filtering is now available to all users. It is no longer in the Preview program. Learn more.
Feature	Allow pull-to-sync on wider screens. So far pull-to-sync has only been allowed on screens less than 768px wide. This change removes the width restriction, so any touch device can use pull-to-sync in contexts where it is supported: currently only top-level Table, Deck, and Card views.
Feature	Ability to set custom margins for PDF email attachments. When configuring an email task you can now choose to set custom page margins for PDF attachments. This capability is particularly useful for attachments that are more than one page. Top and bottom margins set in the template only affect the top of the first page, and the bottom of the last page, not each page in the resulting PDF. Custom margins specified here will apply to every generated page. Note: This will not affect those accounts on the old PDF renderer. Almost all accounts are on the new one, with the rest migrating over soon. Will be deployed to users gradually over a period of time.

Bug Fixes

*Item*	*Description*
Bug	A recent change introduced a regression affecting usage of `[_THISROW]` within User Settings. References like `[_THISROW].[SettingsColumn]` in a SELECT filter or LOOKUP in UserSettings would look for SettingsColumn in the table being filtered instead of in the User Settings context.

Rollbacks

*Item*	*Description*
An issue was fixed where the calendar incorrectly omitted the last date of multi-day events.	This bug fix that was deployed on 7/14/21 has been rolled back.

Preview announcements

The AppSheet Preview program lets app creators try out new app features that are not yet fully supported. Learn how to participate in the AppSheet preview program for app client features.

Filtering has been removed from the Preview program. It is now available to all.

What’s currently available in the Preview program?

*Item*	*Description*
Feature	Table view Table View now supports freezing the first column while scrolling horizontally. For details, see Freezing the first Column of a Table View - in Preview Program.
Feature	Chart Editor App Creators can now make use of our new chart editor and the new and improved charts it can create. Learn more.

Nirmal_Giri · July 18, 2021, 9:43pm

Will_Witman:

Top and bottom margins set in the template only affect the top of the first page, and the bottom of the last page, not each page in the resulting PDF. Custom margins specified here will apply to every generated page.

Thank you for adding this feature. This will be extremely useful.

Will custom margins specified in email task override the top & bottom margins in template? Which one will be given preference while generating pdf?

Can the same functionality (custom margins) be extended to creating headers & footers?

Koichi_Tsuji · July 19, 2021, 1:31am

Will_Witman:

|Feature|Ability to set custom margins for PDF email attachments.> > When configuring an email task you can now choose to set custom page margins for PDF attachments. This capability is particularly useful for attachments that are more than one page.> > Top and bottom margins set in the template only affect the top of the first page, and the bottom of the last page, not each page in the resulting PDF. Custom margins specified here will apply to every generated page.> > Note: This will not affect those accounts on the old PDF renderer. Almost all accounts are on the new one, with the rest migrating over soon.> > Will be deployed to users gradually over a period of time.

Can you share the screenshot please？

Greg_Denton · July 19, 2021, 5:57pm

Hi, in most cases the margins from the template and the ones specified in the email task are actually combined.
The exception to this is top and bottom margins in the template like mentioned in the release note.
Top and bottom margins from the template will apply to the top of the first page, and the bottom of the last page, but not to the top and bottom of each individual page if there are more than one.

There is already a default page margin added (14 pt on each side) that behaves the same way, which is why you may notice margins in the resulting PDF be larger than what you have set in the template.
This feature just lets app creators customize that 14pt margin.

We have not looked into headers and footers, but due to how PDFs are created (by rendering HTML from the template), it would likely be non-trivial. Here’s an existing feature request on the community for such a feature that you can check out - Feature to include Headers, Footers and Page Numbering in PDF reports - #2 by LeventK

Greg_Denton · July 19, 2021, 5:59pm

Hi, you’ll be able to set the margins when editing an email task in the app editor.
There’s a new toggle to enable custom margins below page size as seen in the screenshot here.

Koichi_Tsuji · July 19, 2021, 9:49pm

Hi @Greg_Denton

Thanks you for sharing the screenshot as well as explnation.

Hands-on test after this is implemented will tell us whole story, but can I ask some questions?

On google docs as template, we have page setting where we set the margins, top/bottom/right/left. Honestly speaking, even we applied margins on this page settings, the final PDF product did not respect such settings well.

I m wondering if or not this new feature will supersede the margin settings over the page settings on google doc (or any other template file, such as words, excel etc)?

Greg_Denton · July 19, 2021, 10:02pm

Hi, this feature should help with exactly what you described:

we have page setting where we set the margins, top/bottom/right/left. Honestly speaking, even we applied margins on this page settings, the final PDF product did not respect such settings well.

You can read my comment here July 16, 2021 - #4 by Greg_Denton for more info on how the custom margins should interact with margins defined in template.

Koichi_Tsuji · July 19, 2021, 10:08pm