this post was submitted on 25 Apr 2024
53 points (100.0% liked)
Technology
37603 readers
572 users here now
A nice place to discuss rumors, happenings, innovations, and challenges in the technology sphere. We also welcome discussions on the intersections of technology and society. If it’s technological news or discussion of technology, it probably belongs here.
Remember the overriding ethos on Beehaw: Be(e) Nice. Each user you encounter here is a person, and should be treated with kindness (even if they’re wrong, or use a Linux distro you don’t like). Personal attacks will not be tolerated.
Subcommunities on Beehaw:
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
What service do you recommend for writing formulas? I’m perfectly capable of writing my own, but I’m just so lazy now.
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.