I have a field called date. A user clicks the date field to enter the date the job was done. Iโd like it to auto populate that field with todayโs date as soon as he clicks it.
Right now he can select todayโs date from the map that automatically pops up, but I just want him to click the field in the edit form and it puts todayโs date in the field immediately.
Is there a way?
In initial value use formula now()
I had tried this and today() but this does not AUTOMATICALLY FILL IN THE DATE WHEN I CLICK THE FIELD. All it does is set the drop down map interface to todayโs date and I still have to click the map interface which is an extra, unnecessary click.
What I want is the user clicks on a date field or a date button or whatever in the form, and it sets the field immediately to todayโs date.
Right now when I click the field it shows โmm/dd/yyyyโ and then I have dropdown arrow for a map I can select to pick the date that way instead of typing it in.
The clarify this is not a NEW record, this is updating an existing record.
Hi @George_Smith,Could you mention what you mean by " drop down map interface"?
If you are referring to โcalendarโ view that pops up , then you may wish to create an action of โ'Set the value of a columnโ on the said column and set it to โTODAY()โ
The user can click on the action in detail view of the record to do the needfulโฆ
Sorry yes I meant calendar. I appreciate your answer, but I am fairly new to the app and donโt yet know how to โcreate and actionโ. Would you mind being more specific?
Ok THIS is life changing (or at least APP changing)โฆ thank you!
Any way you know of to change the order that actions display prominently in? I now have 5 action buttons but would love to be able to re-order them.
There is a small Rearrange actions link at the end of Actions.
This might also be helpful. https://help.appsheet.com/ux/capturing-information-in-forms/tracking-changes-using-change-column-typ...
Ah just found it, thank you again!
Ok since I am on a roll, any way for me to have the email icon load up an addressed email with content from a standard template?
Hello @George_Smith, Having email body template
may not exactly happen from email Icon that is associated with an Email type column (Clicking on it will open an email with โToโ address picked up from Email address in the associated email column)
However AppSheet has rich actions, workflow and reporting features through which you can send emails/SMSs/Notifications and more based on app behavior and data processed by app.
I request you to read following
help.appsheet.com - Workflow and Reports: The Essentials Workflow and Reports: The Essentials help.appsheet.com
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |