I have a base that contains records of artwork with record#s that contain letters. D for drawings, P for Paintings and S for sculptures. The prices for all the artwork is based on a formula derived from the dimensions of the art. Drawings and paintin...
I have a number for every record in this format P01384. It starts with P00000. There are several records missing and I would like to see if there is a way to write a formula that would give me the numbers of the missing records in the sequence. Is th...
Thank you very much @Zollie!!. Would it be possible to embed formulas inside the curly braces instead. At the moment there are two columns because P and D have different formulas to calculate price. I am looking to combine the two VALUE columns into ...
Thank you so much. Not sure I understand how to proceed with the second, simpler solution. Will try to investigate more and see if I can figure it out. Incredibly grateful for your help.
@andywingrave Thank you so much for answering back. Here is the way the table is setup. No linked tables.
Example of a missing record. The scripting block sounds like a good idea. I have no scripting experience but can start looking to learn what I...
