View My Drafts
Hi,I need to have the date automatically filled by a certain numbers of days depending on a selection made from a Choice, drop down box.So if Choice A is selected the date field box will increase by 5 days from current dateChoice B 10 daysChoice C 15 daysWould the date be still able to be overwritten?Regards
Thank you for your reply.
I have used this formula which seems to work
If(IsBlank(DataCardValue46.Selected.Value), Blank(), Today()+Switch(DataCardValue46.Selected.Value, "Self-symptomatic", 10, "Household symptomatic", 14, "Contacted by Test & Trace", 14, Blank()))
Just need to sort out how I can now send an email to a manager depending if the absence of their staff member is Covid related or not. Ideally would like to do this from the app it's self as the manager email is not captured in a SP.
Have a draft formula that's been suggested but not currently working as getting error for 'Return Date'. Return Date: DataCardValue54.SelectedDate Error Invalid argument typr. Expecting one of the following: Boolean, Text, number, option set value.
if(DataCardValue45.Value,"<a href = 'mailto:" && Office365Users.ManagerV2(DataCardValue7_6).mail && "?Subject=Absence & body =Employee Name: "&& (DataCardValue3_6.Text) &&",Covid Reason: "&& (DataCardValue46.Selected.Value) &&"Return Date: "&& (DataCardValue54.SelectedDate) && ">","<a href = 'mailto: " && Office365Users.ManagerV2(DataCardValue7_6).mail && "?Subject =Absence & body =Employee Name: "&& (DataCardValue3_6.Text) &&",Absence Reason "&& (DataCardValue44.Selected.Value) && ">")
Any assistance would be grateful
I tried your solution and still had an error. Error was field not recognised
I tried this and no error displayed
The only think now is I get
Instead of the email link to the manager??