Good Day All !
I use the Page Designer Block for invoicing. How can I configure so that each time a new invoice is generated, it prints that date and time on the invoice?
Page Designer Block, Add Date and Time Printed
+2
+18Hi @bob_aycock - do you mean the date/time that the invoice record was created (rather than the time the invoice was printed)? If so, add another column to the table with a formula of:
CREATED_TIME()
If you want the “printed time”, then I think the closest you can get to this is to have a formula field of:
NOW()
This is periodically updated to the current time but note from the Airtable docs:
Returns the current date and time. (Note that the results of these functions change only when the formula is recalculated or a base is loaded. They are not updated continuously.)
So you have to close and reload the base to get it to refresh (and even then, it seems to be cached to some degree).
Either way, once you have one of the fields, add to your page design in the normal way.
JB
+2Hi @bob_aycock - do you mean the date/time that the invoice record was created (rather than the time the invoice was printed)? If so, add another column to the table with a formula of:
CREATED_TIME()
If you want the “printed time”, then I think the closest you can get to this is to have a formula field of:
NOW()
This is periodically updated to the current time but note from the Airtable docs:
Returns the current date and time. (Note that the results of these functions change only when the formula is recalculated or a base is loaded. They are not updated continuously.)
So you have to close and reload the base to get it to refresh (and even then, it seems to be cached to some degree).
Either way, once you have one of the fields, add to your page design in the normal way.
JB
I forgot all about the NOW(), that will do what I need. Thanks!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.