Best Of
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@brianschmidt terrific! Thanks for the detailed clarification on what does and doesn’t show up under those conditions! Very helpful indeed!
Re: Introduce yourself & get to know your peers!
Hi @Rebeca S.
Thank you for sharing these resources. There are many interesting webinars and more.
Best regards
Re: What is the longest formula you've created?
I once had to create a dashboard to help myself not forget how I created one of the most complicated formulas I ever needed. I’m sure there are more elegant ways to do what I needed, but I ended up with this to help create Deferred Revenue tools and metrics for financial modeling…this us fairly nutso, but maybe will provide some of you some chuckles :)
Re: IF THEN statement
Hi @PMOGal,
Try doing it at the row level and see if that gets what you want.
=IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "No")
Hope this helps,
Dave
Re: Triggering User when multiple automations are set up
No, it's not batched in any way, and it is supposed to be triggered by a new row being added. However the first notification, which is also triggered by a new row, has a second action that changes one of the fields to "NEW," so I think that change to the row is my culprit. I instead added the second notification as a second action within the first notification's workflow (and prior to marking the one field as "NEW"), so problem solved! :)
Re: Resource Management API - Users
Yup, easy to work around. If you take a look at the API you'll see that they don't return custom fields with the bulk users api. You have to loop through and call with the ID for each user. Here's some code that can guide you.
test.py
import requests import os import time from datetime import datetime # Save your access token for RM in your environments variables. ACCESS_TOKEN = os.environ.get('TOKEN') BASEURL = "https://api.rm.smartsheet.com" USERS_API = "/api/v1/users?per_page=100&page=1&fields=email" CUSTOM_FIELDS_URL = "/api/v1/users/{}?fields=custom_field_values" def test(): # Getting the user list user_api_result = requests.get("{}{}".format(BASEURL, USERS_API), headers={'Content-Type': 'application/json', 'auth': '{}'.format(ACCESS_TOKEN)}) user_list = user_api_result.json() for user in user_list["data"]: # Sleeping here because the API has pretty restrictive limitations and I don't want to spam GChat time.sleep(1) custom_fields_url = CUSTOM_FIELDS_URL.format(user["id"]) # Getting the custom fields for each user in turn custom_result = requests.get("{}{}".format(BASEURL, custom_fields_url), headers={'Content-Type': 'application/json', 'auth': '{}'.format(ACCESS_TOKEN)}) user_custom_fields = custom_result.json() print("User: {} has the following custom fields: {}".format(user["first_name"], user_custom_fields["custom_field_values"]["data"])) if __name__ == '__main__': test()
You'll note that the custom fields data is a list, so you'll need to loop through that or squash it with a list comprehension or something.
Have fun! 😎
Re: Introduce yourself & get to know your peers!
Welcome to the Community. 😄 We have many resources available that can be helpful as you learn how to use Smartsheet. Don't hesitate to ask any questions you may have, the Community will be happy to help.
Wishing you a great learning journey, and a nice day!
Re: Maximum size of a PDF attachment file in Brandfolder
Hello @T Kawashiri DXable,
For PDF files we recommend that you keep them under 4GB per file. 4GB is the maximum size to create a thumbnail image of the first page.
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@brianschmidt thanks! I forgot that you have the "email validation" option on the Contact field type in the form - so that is definitely a plus with that route. What I just realized that I have experienced that drove me to use the Text field type is that I did not want to reveal the other emails that are in that sheet vis-a-vis the dropdown that necessarily shows up in the Form when you use the Contact field type (big privacy concerns - especially with GDPR, etc.). Am I missing a way to hide those other emails to my form fillers when using the Contact field type on the Form? Ps. I love it when I answer questions and then end up learning exponentially from the ensuing discussions!!
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@Will Jeffords Yeah, I can see the value there. I like having the contact field be in the form. This way, as long as it's not a multi-select contact column, you can set up that form field's validation to check that the email was entered in a recognizable email format…which ultimately helps ensure any automations are able to send to the contact in that cell.