Does anyone know how to create a conditional, pop-up note, preferably timed or disappering when continuing ?
ie. If a cel is filled, like the last day in a month, then a note appears, as reminder to do something.
iMac, Mac OS X (10.6.8), 4Gb memory
There are no pop up notes in Numbers. You can make a table theat lists dates and events which can feed another table based on the date today and the contents of the original table. You can also Use iCal which is made to do just what you are asking to do-- they are called reminders.
There are no pop up notes in Numbers. You can make a table theat lists dates and events which can feed another table based on the date today and the contents of the original table. You can also Use iCal which is made to do just what you are asking to do-- they are called reminders.
file://localhost/Users/donaldbowers/Desktop/Screen%20shot%202012-05-22%20at%2013 .24.57.png
file://localhost/Users/donaldbowers/Desktop/Screen%20shot%202012-05-22%20at%2013 .25.33.png
Don't know if you can see the posts. I was originally thinking to trigger the 'note' when a cel is filled in but your idea of using ical instead, may present a broarder alternative as it automatically takes care of the number of days in the month and reminds me anyway. provided I switch the computer on. I've not used iCal so will experiment.
2Skip2,
If you turn the computer Numbers won't help either.
😉
Wayne
Hi Skip,
To post a screen shot, you need click the camera icon at the top of the Compose frame
then click the Choose File button. Select the file containing the image, click Choose, then click Insert image.
Regards,
Barry
Morning Wayne,
being a knowledgable Numbers/Apple fellow, can you advise how I can get time (NOW time) into a cel and stop it updating. I want to get the exact time NOW and place it on record but I don't want it to update thereafter.
Have experimented with iCal, as you suggested and found it a much better way of doing the alarm thing. Thanks for that. I was impressed (again) at the broard uses to which iCal can be used.
I only converted to Mac a couple of years ago and there is still a lot of utilities I've not even played with yet.
Yours and anyones suggestions about apple software is always very welcome.
Hi Skip,
NOW will update each time Numbers recalculates the table in which it is located.
Numbers will recakculate that table anytime you make a change in a cell on that table (or on a table to which a formula on the first table is linked to a cell on the second which changes.
The only way I know of to stop NOW from updating is to:
This repaces the formula in the cell with the value last calculated by that formula.
Regards,
Barry
Hi Barry,
I'm not sure I understand you. What compose frame ? What camera icon ? I am using 'Snow Leopard'
is it possible you have some other OS ? or is there something else I am missing. Would'nt be first time.
I usually use 'CMD+SHIFT+4' hot keys to drag a frame over the part of the screen I want to take a snap shot of, (+3 for whole screen) have it dropped onto 'Desktop' and then drag it to where I need it. If it's to an email or some other software I usually get a green/white "+" sign on screen if it can be added.
Hi Barry, Thanks for comment. Yes I know it updates that is why I asked the question, however, copying and pasteing is not really an option, unless it can be done by the software. The manual delay, however short, is long enough to caurses errors in subsequent calculations. I was hoping for a better method like changing from text to numerical or the other way round or something like.
I actually think the updating seems to have a very limited use because of the updating feature.
Regards
Barry is referring to the composition controls for THIS forum so you can post a screen shot you took on your computer:
Wayne, I think your deliberately running all over the place. How did you put the arrow on the shot ?
I can do this but I'd have to use a photo editor.
Is this device able to convey embedded formulas ?
Wayne, I think your deliberately running all over the place
I don't follow...
To put the arrow in I take a screen shot of subject, then insert the screenshot into Numbers, then add highlights or arrows or circles as needed, then take another screeshot.
I hope this helps.
Wayne
Sorry I was being a little facetious, meaning before I solve the problem in hand you grab my interest in somthing else.
Are you saying the arrow was drawn by yourself in Numbers. Something else I have not got into yet.
The picture of the arrow does not look like an overlay.
Yup... added screenshot of subject to Numbers using the Menu item "Insert > Choose", then added arrow using the Shapes menu in the Toolbar, then selected the arrow, and changed the style using the style controls in the toolbar (top left corner of image):
Done it thanks.
Now what about a way of fixing the NOW() time, software wise, so it can be used in subsequant calculations without losing or gaining time.
And by the way, I insert picture into the designated place in the Profile set up but it only shows Avartar ?
Create a conditional pop-up window/note
