Question

Change character length on a field after data already entered that exceeds

03:49 May 19, 2022

We have a couple string fields set at 500 and unlimited characters that we now want set to a character limitation of 250. There's already data in some of the fields that exceed 250. How can we possibly query and amend these fields via a BP?

1 comments

Vladimir Sokolov

09:09 May 19, 2022

Hi Susan,

If this is section object, I would tag such records using SQL (You should create tag with such name before).

This is a sample for Account object:

INSERT INTO AccountInTag

(TagId, EntityId)

select (select t.Id from AccountTag t where t.Name='LongName'),a.Id from Account a

where LEN(a.Name)>250

Then you can filter records with this tag in UI or BP

Show all comments