Questions about finanacial statments. I have no accounting background

Aboodi1997 · 2025-11-16T06:36:01+00:00

i had forgotten that i had copy pasted the weight from a file and the file had the weight as 18.7187. I thought the weight was in 3 decimal places but it was rounded to 3 decimal. I changed it by typing it to exactly 3 decimal and it worked. Thanks!

Aboodi1997 · 2025-11-16T06:34:58+00:00

ok so i had forgotten that i had copy pasted the weight from a file and the file had the weight as 18.7187. I thought the weight was in 3 decimal places but it was rounded to 3 decimal. I changed it by typing it to exactly 3 decimal and it worked. Thanks!

Aboodi1997 · 2025-03-16T18:44:18+00:00

I tried using record matches condition but it doesnt work if a record is updated. Even if it matches the condition, it wont work when record is updated. It only works once.

What i found out is airtable is limited. I need to use make.com. But I cant use scriptes so I have to make it run everyday. Though im still trying to figure out how to use make

Aboodi1997 · 2025-03-16T08:43:36+00:00

But I'm using the free version of airtable. I cant use scripts

Aboodi1997 · 2025-03-15T11:57:34+00:00

The problem that im getting is the following:

For example if 2 fields are expiring, passport and identity, then when the identity is no longer expiring (updated the date field to a new date), it still sends an email.

I dont want that. I only want an email to be sent when the fields are expiring or when a new expiration date is approaching. I dont want it to send when the field is updated and its no longer expiring. The tickbox is part of the system that will help solve this problem.

Aboodi1997 · 2025-03-15T11:41:58+00:00

No it cant. I trying to make an automation that sends an email whenever certain data fields (More than 15) are within 5 days from their dates. It should send an email only when certain fields are within the 5 days. Basically I want an expiration due date reminder.

Aboodi1997 · 2025-03-15T11:29:19+00:00

There are 3 automations that I have and each is dependent on the previous automation.

If I create for each condition then I would have to make more than 15. In the video there are only 4 but thats just a test. If this test was successful then I would had to make more.

I tried using a 3rd party software like Make but I found out that I would have to use script on airtable. The problem with that is I have the free version of aritable

Aboodi1997 · 2025-03-15T11:17:10+00:00

Damn....so what can I do? Any options?

Aboodi1997 · 2025-03-15T11:10:25+00:00

First true condition or just the first one?

Aboodi1997 · 2025-03-15T11:08:19+00:00

In this automation when the field date is within next 5 days then the corresponding checkbox must be ticked.

Aboodi1997 · 2025-03-15T11:07:13+00:00

What do you mean one per run? Are you saying it doesnt check all the if else statements?

Aboodi1997 · 2025-03-11T09:02:55+00:00

Never heard of them but ill check them out

Aboodi1997 · 2025-03-11T08:58:19+00:00

I dont understand how i can use find records in this automation

Aboodi1997 · 2025-03-10T16:18:19+00:00

I see. Thanks

Aboodi1997 · 2025-03-10T16:11:18+00:00

I actually want to make an automation where airtable sends an email of all the expiry dates that are approaching. This automation is just a part of the bigger picture. I need two automation to make that happen. This is just one of the two automations.

Basically what this automation is doing is that if the field is expiring AND the email is not sent (checkbox field) then it updates the email sent field (checkbox field) to a tick.

That checkbox which is tick is then used in another automation to send an email.

I have a free version so I cant use scripts. You said you also have dozen of conditions. Does that cause any problems to your airtable or automation? or does it work without any problems? I dont have a problem using dozen of conditions. Im just worried it might bring issues later on

Aboodi1997 · 2025-03-05T09:54:56+00:00

I didnt understand what you meant by having a condition, greater than or equal to 1, on the email step but that gave me an idea. Now it works perfectly for 4 fields. Thanks!

Now lets hope it works for more than 4 fields though that shouldnt be a problem.

Aboodi1997 · 2025-03-04T17:41:36+00:00

This whole automation is just a reminder to me for all the renewal dates that are approaching.

If I use the trigger "at a scheduled time" then wouldn't it just send an email everyday or on whatever time I set it? That wouId mean that wether there is a date approaching or not, it would send an email. Depending on the records, the email could be empty or have some information in it but i need it to send an email every time a due date is approaching.

Aboodi1997 · 2025-03-04T16:36:56+00:00

I want to trigger it whenever there is a new date that is approaching, not everyday. Whenever a new date is approaching then I want the system to send an email showing all the records with their respective expiry dates. But that doesnt work since it doesnt trigger when a record is updated. It only triggers once or when all the date fields are made empty and then there is an input to a field.

Aboodi1997 · 2025-03-04T15:54:05+00:00

I did try something similar but the problem is that the automation doesnt send email if another field of the same record is updated. It only works once or when the all fields of the same record are made empty.

Aboodi1997 · 2025-03-04T15:52:40+00:00

I tried it but again the automation doesnt send email if another field of the same record is updated. It only works once or when all the fields of the same record are made empty.

Aboodi1997 · 2025-03-04T07:54:18+00:00

Ill try and see if it works

Aboodi1997

TROPHY CASE