I am trying to get the if function to produce a yes, no, n/a value. I use, if(is the item fuzed =Yes;Fuzed;Unfuzed) how do i get the n/a to be included?
Welcome to the Make community!
You can wrap the if function with an ifempty function.
2 Likes
ifempty(if(is the item fuzed =Yes;Fuzed;Unfuzed);n/a)
Like this adding ifempty function around if functuon will do the trick
Princy Jain
Make consultant,
For consulting support: Follow up Automated
2 Likes
It doesn’t work. What I am trying to accomplish is "if fuzed =yes;fuzed or if fuzed=no;unfuzed or if fuzed=n/a;blank. Is there a way to accomplish this? Thank you in advance.
Welcome to the Make community!
You can use the built-in function length to check the length of the string.
e.g.:
{{ if(length(5.Fuzed) = 0; "n/a"; if(5.Fuzed` = "Yes"; "Fuzed"; "Unfuzed")) }}
For more information, see string and array functions in the help center:
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate
- Discord Server – join us in live chat for fans of Make!
Help Center Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI
- How to use Regex in Make
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
1 Like