About Erike

Erike · 12-08-2020

Hi. I have some questions related to SQL. Maybe are naive. I have our data in MySQL. We use a CRM called espoCRM that manages that DB. EspoCRM has built-in own ORM (Object-relational mapping) We have used a BPM inside espoCRM that allowed us to devel...

Erike · 12-04-2020

Hello. I need to get an address for the correct geographical location. For this I need the street number, the town, the zip code and the state. The problem I have is with the street address. Customers provide us with an address that includes the apar...

Erike · 11-29-2020

Hello. I hope the community can help me. The problem I have is that in the expression LINKTOFILTEREDVIEW() I always get an error. The use case is very simple: I have two tables, one for orders and another for products within that order. The tables ar...

Erike · 11-25-2020

Im trying to ask the user to fill a text field if a set of given conditions. I was nor working properly for me, so I reduced the complexity of the expression to a very simple one to isolate the issue. I have defined it as follows: IF( ISBLANK([_THIS]...

Erike · 12-08-2020

In my case, it is cloud hosted.

Erike · 12-05-2020

Thanks @LeventK LeventK Unfortunately is not always 3 digits. Normally it a number from 1 to 3 digits. No street is long enough for requiring 4 digits yes

Erike · 12-05-2020

Will explore that possibility. I imagine the implications are: Need to define a new real column in the spreadshhet Add any expression required in the that spreadsheet column Define the same real column in appSheet. Thanks in advance

Erike · 12-05-2020

Your comment makes a lot of sense.

Erike · 12-04-2020

Thanks Steve. That worked perfect!! Do you have a suggestion for the second issue? Erike: When the customer writes calle Alcalá 222B 4-Izq TOP(EXTRACTNUMBERS([shippingAddressStreet]),1) returns the value 2220000000 Any suggestions on how I can solve ...

AppSheet Creators Community

My Stats

Erike's Bio

Badges Erike Earned

Recent Activity

Using SQL with ORM

Getting the street number from a street address

Selecting child Rows using LINKTOFILTEREDVIEW

Using the column Constraint

Re: Using SQL with ORM

Re: Getting the street number from a street address

Re: Getting the street number from a street address

Re: Getting the street number from a street address

Re: Getting the street number from a street address