TylerParker
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How can I summarize the time cards associated with a particular deliverable or project on a monthly basis?
Hi Christopher, I'd like to help. What's your main/first problem here, forming the concatenation field in the Billing table (child table) and then making sure the (child) records are assigned to the right parent in the Time Cards table? Then you want to move forward to automate this? I'm having trouble pinning down your first obstacle. Can you clarify and maybe share some sample records from your Time Cards table?Re: I need dates instead of week numbers
It would be really long... but off the top of my head, if you already have a field named [Date] and make a formula-text field called [Week #] this should work for 2019, provided your desired output is "##-2019". The bad part is typing out all the options, but this should give you ideas. Case([Date], Date(2018,12,31),"01-2019", Date(2019,1,1),"01-2019", Date(2019,1,2),"01-2019", Date(2019,1,3),"01-2019", Date(2019,1,4),"01-2019", Date(2019,1,5),"01-2019", Date(2019,1,6),"01-2019", Date(2019,1,7),"02-2019", ..., ..., null)Re: Need the total of one field to show as a value in another field
Sorry I thought everyone could click the image to enlarge to full size Name Event Count Event Total Employee 1 50 165 Employee 2 60 165 Employee 3 55 165 Total 165 The [Event Total] field is what I'm seeking to fill from the summed values in [Event Count]Need the total of one field to show as a value in another field
I'm trying to have the totals from the Hard Acceleration/Hard Braking/Speeding/Idling fields show up as the value in separate fields in the same table. I started with the Hard Acceleration Total field to illustrate. Can anyone help here? The end goal is a weighted average formula. I've made a parent table but when I make summary fields to show the average of the entire field, it only averages the field per driver, _not the entire field_.Re: Automation to add records to one table from a table whose records are created via API_AddRecord is being limited
Thanks Matt, that's what I was getting at. I'm reading on the Automation Limits page but maybe I should be looking into the Webhook limits? I didn't know that Automations relied on webhook limits underneath. The add-on does indeed only take about 2-3 seconds to run. Would extending the time accommodate webhook limits? If so, how many seconds do you think I would need to tell the code to wait before finishing if I was to create roughly records 350 with one click?Automation to add records to one table from a table whose records are created via API_AddRecord is being limited
I have a calendar add-on that uses API_AddRecord to add multiple records (employee shifts and their work assignment details) to one table all at once, in this test case I used today it was 287 records. Those records are supposed to be created in a separate table as well if they meet certain conditions. The automation works perfectly for records created via grid edit or one-by-one in the form. In the calendar, you go to a week and click "Populate Week" and all scheduled employee's shifts are created for that week. The automation still works, but what's happening is, only 10 records are being added via the automation. I takes the first 2 or so employees from each day of the week. Is there a limit like 10 records per run with API_AddRecord-related records? Does anyone know of any way to get around this? I heard that automations might not fully work with API-created records, but I also heard that a Q4 update was supposed to handle this. Thanks for any suggestionsRe: Was a record created through a form, grid edit, or API_AddRecord?
Thank you too Dan, would you mind linking me the best sources to find more information on Service Workers and how to get started using them? I've read about capabilities you've mentioned in other posts and I have a programmer that is interested in testing them out in our apps.
