4 - Data Explorer
4 - Data Explorer
since ‎Nov 02, 2020
‎Nov 29, 2022

User Statistics

  • 10 Posts
  • 0 Solutions
  • 1 Kudos given
  • 0 Kudos received

User Activity

I’m trying to update a multiple select field based on info from an api. There’s 30 some values that will either be Yes or blank. If it’s yes, its works fine and puts the correct value, but gives an error if it tries to add nothing to the multi select...
How could I use a script that does this to update two fields in my table? IF(FIND(",",{Name}),TRIM(MID({Name},SEARCH(",",{Name})+1,500))) I know it works fine as a formula but I don’t want a formula field since I want to link the email to another tab...
How would I calculate days in foster care from the intake date to today but have it stop counting once the animal’s status is adopted? Ive got the intake date and adopted date but wasnt sure how the formula should be worded. an example of the info
How do I remove the timestamp from this? IF({Appt Date},DATEADD({Appt Date},-2,‘days’), BLANK())
Kudos given to