This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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?
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...
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”)...
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...
Hi Justin, you helped me out with this previously. The source material this year is formatted slightly differently, and I can't seem to get it to work. Here's an example of the source:63101156321; 05945; 5574; ; ; 5574COMBS,GORDONAnd I would like t...
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...
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...
