_large.JPG)
count the number of Saturdays between two dates?
I need to count the number of Saturdays between two dates. Any ideas?
@lin
Joined on April 20, 2017
840 Points
2
Likes received
14
Conversations posted
45
Replies posted
21
Conversations followed
Conversations
%summaryView% report for notifications
Does anyone know how to change the report that populates the %summaryView% marker in notifications? Initially I thought the default table...
On Click Counter
I'm looking for a way to crate a counter that will increment the value in a field by 1 each time I push a button. I was trying to do it b...
Save daily totals from a summary report into another table to track totals over time
Let's say I have a Summary table that totals all the records in a table where [Status]="Open". These are then grouped in various ways so ...
Using webhooks, I need a date field in milliseconds from the epoch...but I get MM-DD-YYYY. Is there an easy way to get milliseconds from the epoch UTC into a formula?
There are lots of people doing the reverse from the API calls but I need to try and get it into the "Message body" of a Webhook. I can p...
Timestamp to UNIX
Is there a formula I can use to convert a date/time field to unix format. I need this for an external API call
Logging edits to a record
Is it possible to set up a multi line text field that can log every edit made to a record with the field that was touched, user who did i...
API_EditRecord with rdr to a different table where you API_GenAddRecordForm
Wanting to create a URL button that will edit a record using API_EditRecord and redirect to a new table where by using a API_GenAddRecord...
Table Relationship by day
I have a table where all employees have an overtime record for everyday of the year. I want to have a second table where I will have vaca...
% Completed button
I am looking for a button that will chance the color on a status bar based on the the number in a separate field.In other words, if I'm a...
API-Import from CSV and email notification
I have a table that mirrors another table using sync on an hourly schedule. If the value in a particular cell changes after syncing, I ha...
How do I make this work? If( IsNull([Date Complete]) and [Status]="Completed",ToDate([Date Modified]), [Date Complete])
This is the formula that I have. I don't know why it keeps throwing errors/ If( IsNull([Date Complete]) and [Status]="Completed",ToDate(...
How to create tabs in a form for better navigation
I need to create several tabs in one table form that would function in the following way: Tab 1 - will cover one area of table informatio...
Webhook bug?
So I have a webhook using API_ImportFromCSV and the trigger for this is the changing of a formula checkbox field value. Well, my webhook ...
Push a button every 30 minutes
Basically I am looking for a way to write the current date and time on all record contained in a report every 30 minutes. I know this can...
Email notification with add to calendar (OS agnostic)
I have a notification that emails out a weekly schedule. I am looking for a way to add a button to the email that will facilitate adding ...
Actions -Create record and go to it.
So I created an action that creates a child record . Is there a way to redirect to the newly created record as opposed to sitting on the ...
Spread income or cost over months
I'm looking at a way to allocate project revenue over multiple months. Lets say I have a project that starts on 6/25/17 and ends on 7/15/...
create records in a new table based on a report once a button is clicked
I have a report in table "A" with a date filter. Upon clicking a button, I want to create in table "B" as many records as the report has....
Google Distance Matrix API
I would like to see if there is a way for me to create an API that will call into Google Distance Matrix API and return the distance a wo...