LinkedIn
Twitter
I'm having trouble configuring the dynamic email settings.
The purpose of this app is to simplify the process of scheduling meetings. Users should be able to select an available date and fill out other fields with the agenda details they want to reserve for that day.
My Google Sheet, "Automation test," is the app's data source. It has two tabs: "Planos" and "Datas_Permitidas." Both are used as Data in the app.
Starting with the "Planos" tab, which is the app's main screen, it contains the following fields and is configured as follows:
- ID (Text)
- Tema da pauta (Text)
- Data (Date)
- Status (Enum)
My second tab, "Datas_Permitidas," is a hidden base for users and contains the following fields and configuration:
- ID (Text)
- Datas (Date)
- Status (Enum)
- Observaรงรตes (Text)
- Ano (Text)
This "Datas_Permitidas" tab contains a list of dates, each with two possible statuses: 'Disponรญvel' and 'Indisponรญvel'. This is where we'll find the dates that are available for users to choose when requesting a meeting.
With that in mind, my "Data" field in the 'Planos' base is configured as follows:
- Valid If: IF(OR(ISBLANK([_THIS]), [Status] = "Alterar data"), SELECT(Datas_Permitidas[Datas], [Status] = "Disponรญvel"), LIST([_THIS]))
- Editable: OR([Status] = "Alterar data", ISBLANK([Data]))
This ensures that users can only select dates with the "Disponรญvel" status when requesting a meeting.
Next, I developed a bot to automate the sending of dynamic confirmation emails. One week before the scheduled date, the bot sends a dynamic email to the requester, allowing them to confirm (Confirmar), cancel (Cancelar), or change the date(Alterar data).
I want the dynamic email to work in the following way when received:
When a user clicks 'Alterar data' in the dynamic email, the 'Data' field stays locked. They can't choose a new date.
Can we make it so that users can select a new date directly from the email when they click 'Alterar data'? Is this possible?
