Tom_David - profile

Tom_David · Jul 02, 2024

I imported (not thinking) over 1,000 .csv records into one of my Free dBases.What will happen to the excess records?

Tom_David · May 11, 2024

Are empty record fields counted as 'Unique' in the Unique total number? I expect not, but just checking.

Tom_David · May 10, 2024

Primary field 'Total' pick list choices at the bottom is blocked by the '+' sign for add records.When I hover over the area to the right of the total 312 records number in this base an area behind the '+' sign is also displayed or highlighted, but I ...

Tom_David · Feb 02, 2024

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.DATETIME_DIFF({Sell}, {Buy Date} 'days')Well, there may be a problem, but I can't see it... can anyone help with the formula to display the number of days b...

Tom_David · Aug 10, 2023

One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.Thx.

Tom_David · Jul 02, 2024

I imported over 2k records. AT is letting me 'add' more records, but I see the 'Over Limit 30-day flag' (top right of the navbar). That's cool. In this case, I only need to work with a few hundreds records so I have time to edit.It would be good (for...

Tom_David · Feb 05, 2024

That works. Thank you, Bill.Here's a similar NaN issue.Create a formula field which calculates profits using {fx buy} and {$ sell} fields AND displays the results as a % above 100% or a negative (-) % below 100%. Display results example: Buy @$10.00,...

Tom_David · Feb 02, 2024

No rush. Thx.

Tom_David · Feb 02, 2024

Isn't it always the simple things... :-). Thx.Secondly, is there a way to NOT display NaN when the end date (Sell) is missing?

Tom_David · Aug 22, 2023

Good options for future use. Thank you.

User Statistics

User Activity

1,000 Record Limit - Free Plan

Is an empty field counted as 'Unique'

'Add Record' blocks primary field display

DATETIME_DIFF({Sell}, {Buy Date} 'days')

Find records in a field NOT unique

Re: 1,000 Record Limit - Free Plan

Re: DATETIME_DIFF({Sell}, {Buy Date} 'days')

Re: DATETIME_DIFF({Sell}, {Buy Date} 'days')

Re: DATETIME_DIFF({Sell}, {Buy Date} 'days')

Re: Find records in a field NOT unique