Ricardo - profile

Ricardo · Dec 23, 2022

Hello community, how would you go about exporting a table or even base's field names and IDs? In an ideal case, I would sync on intervals a sorted list of all fields and their properties, similar to how it's shown under manage fields. Thanks!

Ricardo · Dec 14, 2022

I'm trying to detect overlaps between my records and display data from the respective other records they're overlapping with, but am struggling yet again with creating the right regular expression for the REGEX_EXTRACT. Currently I'm...Creating an id...

Ricardo · Nov 14, 2022

From a look-up field array, I’m extracting a duration h:mm, which I’m trying to convert to a duration field. The time comes out alright in a human readable format, e.g. 2:59, 4:24, 6:00, but I’m struggling to convert the string into a duration format...

Ricardo · Nov 01, 2022

Depsite @Justin_Barrett’s help last time, I still cannot figure out simple regex patterns. This time, I’m combining in a roll-up year and value and am trying to extract the value based on a date. IF( AND(Date, Values), REGEX_EXTRACT( Values, ...

Ricardo · Oct 21, 2022

Hey there, I’m looking up a duration formatted formula field from multiple records. The result of the lookup looks like this “4:24, 6:00, 6:31”. Is there a way to reference and DATETIME_FORMAT this in a formula field and get a similar output format? ...

Ricardo · Dec 23, 2022

Thanks! On marketplace and on the board, I couldn't find a ready-made solution. Do you whether such a solution exists?

Ricardo · Dec 14, 2022

Thanks for the offer. I'm not sure what's the best way to share data. I synced some sample data into a shared view. Does this do the trick?

Ricardo · Dec 14, 2022

I tried and it didn't work, this is where I got stuck. The "Overlap" (Data rollup) actually includes all and not just overlapping records. This is why I initially used the REGEX_EXTRACT together with Identifier to select relevant ones. The final for...

Ricardo · Dec 14, 2022

Thanks @Andrey_Kovalev! The innermost REGEX_REPLACE errors on the Overlap, which is a lookup of the rolled up / ARRAYJOIN(values) of the Data fields, I edited my post for clarify, I probably misplained something. After modifying the formula to Overla...

Ricardo · Dec 05, 2022

Thanks for that! I didn't realize that regex maintains the original field type/formatting.

User Statistics

User Activity

Exporting field names and IDs

Help with regular expression for REGEX_EXTRACT

Converting string to duration field (text to seconds)

Regex extract pattern

How to format time in a lookup array of durations?

Re: Exporting field names and IDs

Re: Help with regular expression for REGEX_EXTRACT

Re: Help with regular expression for REGEX_EXTRACT

Re: Help with regular expression for REGEX_EXTRACT

Re: Converting string to duration field (text to seconds)