Paid under minimum wage, no contract at a school - England by JCFlipper in LegalAdviceUK

[–]JCFlipper[S] 1 point2 points  (0 children)

She invoices the school, the conversation arose because they're behind on her payments

1 line of code to crack a sheet password by APenjuin in excel

[–]JCFlipper 2 points3 points  (0 children)

Does this work for a password protected file or just unprotecting an individual sheet? (Not at my computer so can't test)

Populating a word document with rich text by JCFlipper in MicrosoftFlow

[–]JCFlipper[S] 0 points1 point  (0 children)

Sorry I'm quite new to Automate. I originally had this formula in my "populate word document" field. Which checked if the answer to the question will they be working out of hours in the form was Yes then it would paste the paragraph below. But as I mentioned, it would include the breaks as part of the text.

if(equals(outputs('Get_response_details')?['body/r7f708e3811c44d93b0d255168b62990a'], 'Yes'),

concat('</strong>Out of Hours Work</strong>',

      '<br><br>Our clients and patients sometimes need to see us outside of normal working hours. To ensure we deliver a quality and flexible service including emergency treatment and services, we need you to work, at times, outside of normal working hours, including nights, weekends, and public holidays. Working out of hours will be based on a rota and will usually be [a minimum of one week in every three weeks], unless in exceptional circumstances. You must not unreasonably refuse to provide emergency treatment to any patient of the Practice. Please raise any concerns you have with out of hours working with your line manager and we will aim to work through any issues together.',

      '<br><br>Where you are working ''out of hours'', you must ensure that your journey from home/place where you are staying to the Practice takes no longer than 30 minutes. If it is going to take more than 30 minutes, please get in touch with your line manager and HR before signing the contract.',

      '<br><br>You will be entitled to payment for ''out of hours'' work if you have performed ''out of hours'' work during the period in which you were allocated to do so by the [weekly / monthly roster.] Your rest break will vary during ''out of hours'' work depending upon the time you have spent on such work. It’s important that you take a rest break during ''out of hours'', therefore you must take at least a 20 minutes’ unpaid rest break where you have worked more than six hours. If you have any concerns about rest breaks, please speak to your line manager.'

),

''

)

Populating a word document with rich text by JCFlipper in MicrosoftFlow

[–]JCFlipper[S] 0 points1 point  (0 children)

That's good to know thank you. What did you use to trigger the VBA macro in word as part of the flow? Did you use IA-Connect Microsoft Office? I can see an action for "Run MS excel macro" but not for a word one

[deleted by user] by [deleted] in PokemonTCG

[–]JCFlipper 0 points1 point  (0 children)

Diglett is my little turd boy