Digital-Clay Community Forum

Is it possible to filter based on sub-string in a field.

Case in point, we have a member-id field, and we want all members that have the last digit in their member number smaller than 5 (4,3,2,1,0). This is used to randomly split the member list into two groups, but ones that we can identify later ...

Is it possible to Select All or Clear All when inside a Many to Many field?

This is extremely important, for example - where we ran into this issue - we have a Category many to many field, and an Item many to many field. When certain categories are selected, the Item list is Auto-filled to only ...

So how do I create a combination of both answers you gave?

If I create a new record, I need to - after completing the inner set fields inside the Create Item - first run an automation to create the unique field from a combination of more than one of the new fields, and have all that done inside an ...

Is it possible to define a combination of fields as unique in a table i.e. ID + Date + Email?

If so, what happens when an automation tries to Create Item into the table which will violate that - will if fail gracefully and continue to the next action, or cause an error and stop the automation from ...

I create a new automation. I select the Filter as my many to many field, and limit its value from 0 to 0. Then I add an action to Set Field of my text field to 'Any Item' (I have two other automations - one that checks this field for values 1 to 1 and then Set Field to the name of the item selected ...

I am trying to use the Count function on a Many to Many field. It seems to work if there are selected items in the field, however when I filter based on Count with value 0 (zero) trying to determine is there are no selection for the field, I don't think it works.

If Count does not return 0 for an ...

What do you mean "save the profiles at central"?

well, I need to AddDays(-10) in my example:
1) does the function work to calculate backwards?
2) how do I use the value of the numeric field and give it a negative sign?

Is it possible to permanently change the default of 1000 records for filters and table display.

Currently is we do a filter, and there are more than 1000 results, we have to manually click on the 1000 number at the bottom right corner of the results window and change the maximum number each time ...

I have a form that has two fields - one is a number value and the other a list with 'days' 'weeks' 'months'.

The user enters a number and I have to calculate a previous date based on that input.

eg: the user enter 10 days, so I have to calculate the date of 10 days before the current date. The ...