Get a specified row

[toni.gennert8m3yr]

hi Guys

I need your help!! Following situation:

I created in airtable a table (name „Tagesmenu“) with this fields:

Datum Date in the format dd/mm/yyyy

Kuchen01 Name of the cake of the day

Kuchen02 Name of the day’s second cake

Suppe Soup of the day

Speziell Specialty of the day

Actually there are around 100 entries in the table.

As an example, I would like to get the row with today’s date and display Cake01, Cake02, Soup and Special.
Get the actual date works:

My further dumb blocks don’t work …
To get the row in Table Tagesmenu with the actual date don’t work:

Can someone help me? thank you very much

Kind regards
Anton

[muneer]

Two things to note here
1)
The if condition should be between the app variable and the object Datum. You are trying to retrieve the object that has Datum = app variable which is not available. So it should be
App AktuellesDatum = get property Datum of object j

The default date format of Airtable is date and time together so first check the content of Datum in object and make sure it is in similar format to your app variable.

Happy Thunking

[toni.gennert8m3yr]

Ey muneer

Thank you very very much for your reply. Today I will check your hints and inform you about the results.

Greetings from Switzerland

[muneer]

To mention a person in particular use the @ sign followed by the name and the forum will send a notification to that person so you can get better attention. Eg @toni.gennert8m3yr

[toni.gennert8m3yr]

@muneer

ok !

[toni.gennert8m3yr]

Hey muneer
Please excuse my late reply. I still have 4 grandchildren who provide action

The problem was actually the date format, which did not match the settings made. The problem is solved Thank you for your help !!!

Merry Christmas and a happy new year

[toni.gennert8m3yr]

@muneer

look at my reply. The problem is solved Thank you for your help !!!

[muneer]

Merry Christmas to you and my best regards to the grandchildren