blank form

[Milosensas1]

Good morning everyone,

I have a problem that is driving me crazy, when I enter a formula in the app it returns me blank, but in the test of the formulas the result is correct,

What I can be doing wrong?

Thank you

[Steve]

My crystal ball is cloudy: it's not showing me what you're doing. Can you? Screenshots appreciated.

[Milosensas1]

Yes, sorry, 

This is the formula that comes from the excel file and that works well in excel,

IFERROR(VLOOKUP(Stock!RC[1],Tabla1[[CÓDIGO JAVA]:[UBICACIÓN]],2,0),"")

In the app I get that field blank.

If I try to do the formula directly in the app I do the following,

LOOKUP([Código], Entradas, CÓDIGO JAVA, UBICACIÓN)

I introduce this in Auto Compute/App Formula, 

and in the test formula section, it returns the results fine, but in the app, that field continues to appear blank,

I do not know what else to do

Thank's

[Joseph_Seddik]

If you add a new row, you'll see that the it gets updated correctly with the calculated value. If you open a Form of an existing row and save you'll see the row gets updated.

For a particular row, the columns' app formulas are calculated at the time of row creation or upon a data change any column value in this row. 

To update all of your table rows with a newly-added formula, you can do the following:

1. Temporarily remove your expression from the app formula of your column.

2. Create a Data Change action to change this column using the same expression.

3. Launch this action on all rows of your table. 

[Milosensas1]

Hello,
Thank you very much for responding, I have done what you tell me and now it continues to appear but only in the form, neither in the table nor in the product detail,

I have done what it tells me and now it continues to appear but only in the form, neither in the table nor in the product detail,

I am doing something wrong

[Joseph_Seddik]

When you open a detail view of one of these blank records:

1. Do you see a value in the Ubicación field?

2. Do you have an action button visible inside this view?

3. What happens when you click this button?

Please post screenshots of the scenarios above. Thank you!

[Milosensas1]

If I press a blank one the following appears

The Location field does not appear although I do have it selected

If I only leave the location field in the detail, nothing appears

Thanks for the help

[Milosensas1]

Solved,

For some reason I converted that table into table format in excel, and it was giving me that error, as soon as I removed the table format in Excel, it worked perfectly.

Thanks for the help.