This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Anyone else noticing an update to newly created lookup fields?
They now retain formatting and functionality of the source field.
i.e single selects will have the correct color, and filtering options of the source select field.
this seems like a huge ...
I came across an issue recently where a linked record column in table ‘A’ without the option to allow multiple linked records, still contained some records with multiple links to records in table ‘B’.
Upon researching the matter it turns out that whe...
Just learned this lesson the hard way.
Tried using the value function to extract the numeric portion of a string field containing an amount with the currency abbreviation i.e 1.23 USD.
Results got weird when calling the function on amounts in GBP
Indeed you are correct, looking at other bases, it seems like it has been around for a while.
Have you tried “migrating” existing lookup columns by simply toggling the column type to something else and back to a lookup?
I would like to do that as opp...
If the case won’t be consistent then you could use ‘lower’ in your comparison
IF(extra, IF(LOWER(LEFT(extra,3)) = "tex" , "Text Me" ,"Call Me") , "Do Not Contact")
I needed to switch the order around because lower would error when called on the blan...
I had a similar use case where i needed to track new items added to a table and find a corresponding approval record on a different table and link it if it exists, or create a new one if not. Here is a simplified version if the script I used, you sho...
Sounds similar to an issue I encountered here
Duplicating Records Creates Invalid Record Link Ask the community
I came across an issue recently where a linked record column in table ‘A’ without the option to allow multiple ...
