Dynamic Email in Appsheet

[DaveBarnes]

Hi

I have seen several articles on how to create a dynamic email in Appsheet. From these articles I have managed to create and send an email. But my problem is ALL fields in the email are editable, I only want one field to be editable and Approval field.

So in my email I have presented a form view showing a few details about a project. The email has been sent to the appropriate approver. But they can edit all the fields in the email, not just Approved / Rejected field. How can I achieve this in a dynamic email in Appsheet. 

It is October 2024 and I am using the latest version of Appsheet, sp references to the current menus would be appreciated.

Anyone's help and guidance in this matter would be very much appreciated.

[Steve · Accepted solution]

Three options:

1. Disable the Editable? option for the columns you don't want them to modify.
2. Use an Editable_If expression to disable editing of those columns.
3. Add virtual columns for each of the values you want displayed but not edited, populated with the corresponding values, and include these virtual columns rather than the normal columns.

[DaveBarnes]

Hi

Wow!, firstly thank you for the quick response and thank you for the
explanation. This makes perfect sense. Although it will take time to set up
it should provide the perfect solution. Thank you.

Regards

*Dave Barnes*
Data Analyst
Data Team
IT Department. Unit 19a, Cobalt Business Exchange Central, Silver Fox Way
Cobalt Business Park, Newcastle upon Tyne, NE27 0QJ

<PII removed by staff>
<URL removed by staff>

Working hours
w/c 07/10/2024 - Mon to Thu (2pm)
w/c 14/10/2024 - Mon to Fri
w/c 21/10/2024 - Approx 02/12/2024 Long Term Sick
[image: Diagram Description automatically generated with medium confidence]


*Please consider the environment before printing this e-mail*

--

Please consider the environment before printing this email.
*********************************************************************
This
communication may contain information which is confidential, personal
and/or privileged. It is for the exclusive use of the intended
recipient(s).
If you are not the intended recipient(s), please note that
any distribution, forwarding, copying or use of this communication or the
information in it is strictly prohibited. If you have received it in error
please contact the sender immediately by return e-mail. Please then delete
the e-mail and any copies of it and do not use or disclose its contents to
any person.
Any personal views expressed in this e-mail are those of the
individual sender and the company does not endorse or accept responsibility
for them. Prior to taking any action based upon this e-mail message, you
should seek appropriate confirmation of its authenticity.
This message has
been checked for viruses on behalf of the company.
*********************************************************************
G4S
Limited, Registered Office: 6th Floor, 50 Broadway, London, United Kingdom.
SW1H 0DB. Registered in England No. 4992207.
G4S Corporate Services
Limited, Registered Office: 6th Floor, 50 Broadway, London, United Kingdom.
SW1H 0DB. Registered in England No. 7409677.