Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: Switch with multiple for loops and consequents new records
@Paul Chappell everything set up and works perfectly. Thanks. More beers added
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
@Paul Chappell by now I owe you a few beers, or whatever drink you like :) just ...to understand the instructions and adapt to my needs, let's see if I got the algorithm right.…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
till learning @Paul Chappell Thanks! As you can see I'm still learning a lot about Ninox and maybe I wasn't clear in my request. The button in the first sample database that you have sent creates…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Icons Color
@RoSoft_Steven thank you. I thought about the same solution after a few tryouts. Would be nice to be able to use something like font awesome, though :)
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Icons Color
Silly question maybe, but I haven't found any previous thread about this: is it possible to change the color of an icon? if I use the formula a icon("trash") the icon shows a blue trashcan.…
Gianluca
Gianluca
3 mths ago
2
replies
35
Get help
Re: Switch with multiple for loops and consequents new records
@Paul Chappell works like a charm, so I dare to ask for one more suggestion: if the same worker has more than one contract (separated my years), is it possibile to have a list with all the academic…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
@Fred sorry for leaving Italian names, but changing every filed would have been too long :) Thank you for your help!
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
@Paul Chappell Wonderful and wonderfully clear! I'll leave the do as server just as is, but since I'm using the Mac app I guess I'll create an alternative button without the do as server command,…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
@Paul Chappell Many Thanks!. Would you also be kind enough to explain me the steps in your calculation? Especially... what is "do as server" the "range" thing....…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: Switch with multiple for loops and consequents new records
@Fred here's a sample. If you go to Contracts Table and then select the tab "Orari", you will find 4 buttons. The red one is the one that does what I want to....almost.…
Attachments
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Switch with multiple for loops and consequents new records
Hello, for each person, I need to list all the academic years that person has been or is being hired, along with the startDate and endDate for each academic year resulting.…
Gianluca
Gianluca
3 mths ago
16
replies
106
Get help
Re: List of years/months/weeks...
@Fred yes sorry… I’ll start a new thread. I keep posting here because it’s an “evolution” of the original subject, but it’s going astray
might be my Italian attitude
anyway… the for loops…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred thank you But, correct me if I'm wrong... if the formula is: switch true do case endMonth <9: switch fieldX do case value1: for loop in range (0,1) case value2: for loop in range (1,…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred I've tried, but I can't make it work. I think the problem is where two or more loops have to be used in order to create all the records, like in this bit of the formula:…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred @Fred said: Maybe it is me but doesn't this say that the range is from 0 to 0? You are switching on cntYear and if case = 0 then run this loop which is from range(0, cntYear) with cntYear = 0?…
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred here I am again.... the original formula had to be complicated a bit in order to give different results according to when a contract starts and ends...…
Attachment
Gianluca
Gianluca
3 mths ago
Get help
Reported - view
Filter a print layout
Hi, here I am again with some silly question. I have a print layout which displays all the data of a worker. When I'm in print layout mode, I can choose if I want to print "Only this" or "All"…
Gianluca
Gianluca
4 mths ago
26
Get help
Re: Button to save a pdf when multiple print layouts are available
@RoSoft_Steven Thank you! Found them right there...dumb me!
Gianluca
Gianluca
4 mths ago
Get help
Reported - view
Re: Button to save a pdf when multiple print layouts are available
@RoSoft_Steven I've set the button after your suggestion, but I can't see anything happen nor I can find the file that has been created: are the files saved somewhere special?…
Gianluca
Gianluca
4 mths ago
Get help
Reported - view
Re: Button to save a pdf when multiple print layouts are available
@RoSoft_Steven and @Mel Charles Thank you both. I think I'll try both suggestions and then decide which one fits better :):)
Gianluca
Gianluca
4 mths ago
Get help
Reported - view
Button to save a pdf when multiple print layouts are available
Hello, i have a form and multiple print layouts (that's because from the same data in the form, I need to have many different papers created). 1. Is there a way to add different buttons the form (one…
Gianluca
Gianluca
4 mths ago
6
replies
82
Get help
Re: List of years/months/weeks...
@Fred Hello :) I've come across another need. The formula works perfectly in a button and does everything I need to, creating the list of months for the contract in use.…
Gianluca
Gianluca
5 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred smart point… actually this script should be run only once after a contract ends, so it wouldn’t be a problem. But if you run it by mistake before you need to,…
Gianluca
Gianluca
6 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Rafael Thanks :) Does it necessarily have to be in a button? can't it be put somewhere to perform the loop without any action required by the user?
Gianluca
Gianluca
6 mths ago
Get help
Reported - view
Re: List of years/months/weeks...
@Fred i tweaked it a bit to use today as EndDate in case EndDate is null (here below you can see it). Haven't tested it yet cause when I try to save the formula field,…
Gianluca
Gianluca
6 mths ago
Get help
Reported - view
1
2
3
4
5
Next
Gianluca
Gianluca
Italy
124
8
1
Joined: 22 Mar 2022
Follow
User of Filemaker Pro, Just moved to Ninox App.
Not a Pro user of any of them, I just use database apps to create small-to-medium solutions, but sometimes with complicated needs :)
Home
Learn & Share
Get help
Webinars
View all topics
Tags