Jeffpdoes - profile

Jeffpdoes · Dec 28, 2021

I’m trying to create a SWITCH formula checking for specific text within a field. For instance, if there is a field with a bunch of random numbers and then a name, I want to check for the name in that field, not match the entirety of the text in the f...

Jeffpdoes · Apr 22, 2021

When I update a record in a base, obviously the location of that record changes based on the way the view is being sorted. Is there a way to go straight to the new location when the record is updated?

Jeffpdoes · Apr 16, 2021

I have a Client Table which links to an Appointment Table. The Primary field of the Appt Table is a date field. On the Client Table, I have an Appointment Lookup field which looks up Appts that fit certain parameters. I then have an automation setu...

Jeffpdoes · Apr 14, 2021

If I have 2 automations with the same trigger, is there a danger of one automation triggering first, which would prevent the second from triggering? Here’s my situation. When I enter a deposit amount into a client’s record (“deposit” is “not empty”)...

Jeffpdoes · Apr 05, 2021

I have 2 linked tables, CLIENTS and APPOINTMENTS, where I link an APPOINTMENT record to a CLIENT record, and can have multiple APPOINTMENTS linked to a single CLIENT record. Is there a way to sort the linked appointments in the client record? For ins...

Jeffpdoes · Dec 29, 2021

Justin_Barrett: [^\\d]*$ Worked great. Thank you.

Jeffpdoes · Apr 14, 2021

I figure it out: I’ve got the A client record links to several appointment records. Then I have a lookup field that looks up the linked appointments and filters them “where Appointment is before Today”. Then an automation which triggers when the lo...

Jeffpdoes · Apr 06, 2021

Thank you. I’m having trouble getting it to work just right. Maybe you can help me fill in the gaps. I created a Rollup field using ArrayUnique(values) to collect the correct Appointments, but it is only collecting the date information, not collecti...

Jeffpdoes · Mar 11, 2021

Whew. I was making it way harder than it had to be. I saw that option in the Start Time field but neglected it in the End Time Formula field. But you already knew that. Thanks!

Jeffpdoes · Mar 10, 2021

Thank you. I’m not exactly sure what you mean. How do I change the Time Zone settings? In the meantime, I set the formula to: DATEADD({Start Time}, {Duration}-8, ‘hours’) which gives me the results I want, but I wonder if this workaround might caus...

User Statistics

User Activity

SWITCH formula If

Go to new record location

Linked Date Record displaying Wrong Date/Time

Two automations from the same trigger

Sorting Linked records within a Record

Re: SWITCH formula If

Re: Sorting Linked records within a Record

Re: Sorting Linked records within a Record

Re: Automate END TIME based on START TIME, DURATION

Re: Automate END TIME based on START TIME, DURATION