Comment on What do you personally use AI for?
BlameThePeacock@lemmy.ca 6 months ago
I use it all the time to write Microsoft Excel and Microsoft PowerApps formulas. I use it to draft and re-write e-mails. I use it to come up with ideas and brainstorm.
Lenny@lemmy.zip 6 months ago
What service do you recommend for writing formulas? I’m perfectly capable of writing my own, but I’m just so lazy now.
BlameThePeacock@lemmy.ca 6 months ago
I just use Chat-GPT, I also have the capability to write my own formulas, but especially for more complex or repetitive formulas it’s faster.
Here’s one for PowerApps I asked it to extend
Patch(Timesheets, LookUp(Timesheeets, ID=SharePointIntegration.SelectedListItemID), {DataString:Concatenate(TextInput1.Text, “;”,TextInput2.Text, “;”, TextInput3.Text, “;”, TextInput1_1.Text, “;”,TextInput2_1.Text, “;”, TextInput3_1.Text, “;”, TextInput1_2.Text, “;”,TextInput2_2.Text, “;”, TextInput3_2.Text, “;”, TextInput1_3.Text, “;”,TextInput2_3.Text, “;”, TextInput3_3.Text, “;”, TextInput1_4.Text, “;”,TextInput2_4.Text, “;”, TextInput3_4.Text, “;”, TextInput1_5.Text, “;”,TextInput2_5.Text, “;”, TextInput3_5.Text, “;”, TextInput1_6.Text, “;”,TextInput2_6.Text, “;”, TextInput3_6.Text, “;”)}); Refresh(‘Timesheets’);
I just gave it the first bit and two text input fields initially and then asked it to add the remainder for me instead of hitting copy paste and changing the numbers a dozen times.
Probably saved me 5 minutes, but I do this kind of thing fairly regularly so it’s probably saving me a half-hour to an hour per week on formulas alone.