About andreagiordano

andreagiordano · 09-11-2023

My idea is:If they are uploading after more than 3 hrs I want intial value of field [end] to be 1 h more than field [start]if they are uploading immediatly after trip the value of field [end] can be now() I designed this expression but it doese't see...

andreagiordano · 09-06-2023

I have data in 3 different tables ...I Used the formula sum if (=SOMMA.SE(Crediti!C:C;A:A;Crediti!D:D) This summ the credit for each user =SOMMA.SE(ViaggiSplit!C:C;A:A;ViaggiSplit!E:E) this sum the cost for the trips done by each user =SOMMA.SE('Calc...

andreagiordano · 07-26-2023

I duplicated my app to do some tests and changes. I created a new database form the older one with a different name. Strangely enough if in the Table and chose View Source it shows me the correct file (an empty file, only headers are left). But if I ...

andreagiordano · 05-04-2023

In my form from the main table if on specific field has a specific value I'm sent to the related table in order to add more informations and data. But I cannot edit the field I just saved in the related table. I have to save the parent record and the...

andreagiordano · 05-04-2023

I have a column [Tipologia viaggio] with two enum to be chosen. Once the record is saved if I edit it again and try to change the data in this colum the answer is that it cannot be saved:This columne [Tipologia viaggio] is linked to the column [Costo...

andreagiordano · 11-16-2023

Hi WMS !!! I come again on this topic ... I would like to re-design my app so that it has a more clear workflow. Where do I start from?I will try to summarize it.I manage a car that students share. I want the app to get input from students (start tim...

andreagiordano · 09-14-2023

Got it! Formula must be "less then"! I got confused with more than 3 hrs ago maybe ...If Start time is less than Now()- 3 hrs, then start + 1 hr else, now() Now is 20.20If I change start time end time changes accordingly Thanks ! @Marc_Dillon you hel...

andreagiordano · 09-13-2023

This means that when I'm uploading the values in a form Initial Value does not perform the if formula and it anly perform the formula when I open the form first time? My issue is only when I upload data for the first time ... (place km, start dat tim...

andreagiordano · 09-13-2023

I tried bracketing (Now()-"003:00:00") but doesn't work. The end time doesen't change when I set the start time at 3-4 hrs before while recording a trip . I wonder if an IF expression might work in "Initial value " like this at all. The start Column ...

andreagiordano · 09-09-2023

yea .. I understand that is an app design exercise. I will think about it and see I I can figure out another way to organize process and data. Actually this is my first app and I started it by chance (somebody suggested me) and with zero expectation....

My Stats

andreagiordano's Bio

Badges andreagiordano Earned

Recent Activity

Expression with now()-"003:00:00" does not seem to work

How to show data from 3 different Table

Duplicate app and new database ... but old data ???

Edit a field in a related table

Wonder why Cannot save data changes

Re: How to show data from 3 different Table

Re: Expression with now()-"003:00:00" does not seem to work

Re: Expression with now()-"003:00:00" does not seem to work

Re: Expression with now()-"003:00:00" does not seem to work

Re: How to show data from 3 different Table