wan | Reduce requests to your server | Runtime Evironment library

If you force your project to x64 bits?

Then you CAN use the connection builder, but the test connection button will NEVER work. In fact the test connection button NEVER worked, and NEVER works for x64 bit Access.

However, WHEN you run your code, the connection should and will work.

So:

From the docs:

They are defined by using one of the keywords public, protected, or private, optionally, as of PHP 7.4, followed by a type declaration, followed by a normal variable declaration. This declaration may include an initialization, but this initialization must be a constant value.

*emphasis by me

This means, you need to initialize the property from somewhere else. For example the constructor of the class in question. E.g.:

After return ; or just return; (for void functions) the program exits from the loop and also from function. The function returns (for non-void functions). This statement applies when executing function already is not requeris.

The warning message is not related to the DB switch mechanism.

Try to change your select statement to something like:

After giving up on this I decided to reinstall one last time the whole google-cloud-sdk suite, but this time using the snap version. Installing it via snap solved the issue for me. I think this points to some issue with my environment that was bypassed thanks to the snap containerization.

So no clear answer here, but if anyone is experiencing the same problem giving a chance to snap may solve the issue as it did for me

Try this:

=arrayformula(if(A3:A<>"",iferror(vlookup(A3:A&B1,{INT(Records!B:B)&Records!A:A,Records!A:D},{3,4,5},false),),))

Taking into account of future dates and 'ABSENT':

=arrayformula(if(A3:A<>"",iferror(vlookup(A3:A&B1,{INT(Records!B:B)&Records!A:A,Records!A:D},{2,3,4,5},false),IF(A3:A<=TODAY(),"ABSENT","-")),))

Breakdown:

VLOOKUP takes the date from Col A and the name from B1 and then refers to the first {}, to compare against {INT(Records!B:B)&Records!A:A which is the whole day without the time using INT around the date/time, and the person name.

Where there is an exact match, {2,3,4,5} brings back columns 2,3,4,5 from the second array {}.

If there is an error matching IFERROR, then checks IF(A3:A<=TODAY(),"ABSENT","-"). If the day is today or before, it puts "ABSENT", otherwise "-".

if(A3:A<>""... at the start only does the VLOOKUP whilst the value in column A is not blank, otherwise ,) does nothing (the space between , and )).

ARRAYFORMULA works down the sheet.

Do you want this to happen for any cell, or just for J4?

every cell in the column, it's only 10 rows so I was going to duplicate the code for each cell.

Then perhaps the following:

You can initialize the values in an object and use them as initial state