Show only "active" choices
I am developing a custom employment job board. I have created a webform where the HR department can create a "job posting". In the "job posting" form, HR can select active or not active for the job. When the applicant fills out the application form the "Position applying" field is a lookup field that relates to the job posting form/database explained above. Here is my question: How do I restrict the lookup field for only job postings that are marked "active?"
Fetching and displaying form data
So I have one form with supplier information, like name, location, contact, email...etc. Then I have another form with product information, like a product type (baby clothes, or adult tshirts..etc), a photo, price, and dimensions I related the forms together using a look on the product form, which looks up the suppliers name. So the plan is to goto trade shows, collect supplier information. Then take photos and capture details of all the products they are displaying. So what I need to do after, is
How to get a sum for "Total Points" based on "Points" entered for attendance and show it in the "Total Points" field on the same form.
I am a newby...so bear with me. I have a form called, "Employee Personal Data" for personal employee info. I then have a form called "Employee Attendance Record." On this form I have a field called "Points" to enter .5, 1, 1.5, 2, etc. as points for an absence. Once entered, I want the "Total Points" field on the Employee Attendance Record form to show the running total for the year for that particular person (up to 12 points total). I have a Lookup Field to pick the employee's name from the Employee
if statement at form 'on load' using lookup dropdown as criteria
cant seem to get this to work....please help if(TZ2WOF_PEs.!= "-Select-") { TZ2WOF_Select.deselect(); show TZ2WOF_PEs; TZ2WOF_Select.select.("PEs"); } fyi TZ2WOF_PEs is lookup field in dropdown mode TZ2WOF_Select is a checkbox Thanks in Advance
Stateless Forms Usage - General Questions
There is very little explanation of Stateless Form and how to manage their implementation in real-world application. There are some things I need to do that a basic report just can't do, and I can only guess that a stateless form is the only option, but then I come to find you can't do many basic things with a stateless form. Example, I have a form that gathers fuel purchases in both US and metric means. It stores date, location, odometer, and quantity. I need to be able to present the user with
Lost the ability to add new entries to dropdown linked to another table
Hi We have a form that allows the user to add new entries to another table if there is not an existing record in a dropdown list. But this seems to have gone now. Can someone explain how we can reinstate this please? Thanks
Will Pay for Zoho Specialist
To whom it may concern, I am finding it nearly impossible to complete even the most basic tasks using Zoho. This is clearly a powerful platform but I will never be able to use it without assistance. Will pay to have phone access to a Zoho specialist for one week. Regards
Custom Auto Number Updates all previous numbers
I have a form Named "Shop_Tickets", with a sub form "Work_Orders". The WO# field is the output of the following script on the sub form "On Add Row" work flow: counter = "WO" + "-" + zoho.currentdate; counter_num = 0; counter_job = Jobs[ID == input.Job].Job_Number; for each line in Work_Orders { counter_num = (counter_num + 1); line.WO = ((((counter) + "-") + (counter_job)) + "-") + (counter_num); } which is producing exactly the results I want in the format I want, However the date is not
Special Character import issue with Creator
Although I have been a long time user have not been active for a while and have been using an alternative. But the new Creator looks very interesting. I am trying to import a database of spanish language films and the accents and other special characters are importing odd: El aprend�z de investigador privado Capulina confunde al vicepresidente de una empresa con un ladr�n. Sus amigos e �dolos, los luchadores Tinieblas y Superzan acuden en su ayuda y evitan un asalto, Capulina crey�ndose el h�roe
Master Field overriding All rows of Subform field
My form as a 'Master Approval' dropbox ( Pending, Approved, Denied) as does the attached sub form. I'm asking for some help in coding my Master Approval field so that when a new choice is selected it overrides the selection in the Approval fields in each row in favor of the MASTER APPROVAL Selection. Has anyone had experience with this?
iOS Creator - Pivot Table Report View Issue - Minor
Zoho Creator v 3.5.4 for iOS in IOS (on an IPhone 6), a pivot table report that generates more then several columns is difficult to view because the "Rows Popup Tab" remains up and will stay up until the user coaxes it to go back down. Seems it should drop back down momentarily after making any scroll changes without user intervention.
Zoho - GITEX - Dubai
It was nice to see Zoho in GITEX
Build Custom Report - Access Relational Data??
I hope I'm missing something, but I have an application working great with a number of relationships between forms. Zoho does a great job in creating the underlying default report to include the relational form for access, however when you you want to create a pivot table custom report, you are not allowed to bring in the related table (form) to use these fields for the report. Why can I ONLY choose from forms, and not existing reports, to build another report that is truly meaningful, utilizing
Custom Actions - sequence by Action Name
I've created several custom actions so that when a user is at a row, and they select that row, they can access the Custom Actions. Great. HOWEVER - the custom actions appear in the order that I've created them!!!! How can I make the default sequence be alphabetical by Action Name????
Set working day at 10hours period with zohocurrentdate?
The zoho variable Zoho.Current.Time and Zoho.Current.Date is very good and I use it to input time and date as a hidden field and also how long it took to close the ticket (with last modified time): "Length" field: ((Modified_Time - Date_Time) / (1000 * 60 * 60)).round(2) What I get is a number of hours, but what if I want to limit those hours to 7am 7pm? eg when I get "Length" = 240 hours, it is since the ticket is opened, but not in real business hours from 7am to 7pm... If I open a ticket today
Possible To Easily Persist Data With Application Distribution?
Is there an easy way to persist the data in chosen forms to remain with the application during shares and copies? If a customer is going to have to do some importing upon first obtaining the application to allow for basic operation, this may be a deal-breaker for some. My application has 95% of the "items" a user will need, and all they would need to do is plug in their own price defaults. Their unique items can also be added as necessary. But I want these 30 or so items to be a part of the purchased
How to retrive date stored in table
I have one stateless form which has date field and which is storing in table. I have functionality where for particular ID i ant to retrieve data from database there i am able to retrieve all data but i am not able to retrieve date. How can i do that?
Decision Box On Report
Is there a way to make a decision field type display as a "checkmark" on a report? This seems like such an obvious option to include in basic reports design. It looks great on a form as a checkmark, but on a report listing showing a bunch of "false" and "true" entries is not very appealing when all you want to see is a checkmark, or no checkmark, and in fact it's hard to easily distinguish if it's true or not without hurting your eyes. Am I missing something?
Usage of lookup field. Form1=>2=>3. Can Form 3 get info from Form 1?
Hello Now I'm making an application like below. 1. formEntryAllUser =>Name,Email,Address ...etc basic infomation 2. formEntryLimitedUser =>Lookup to form1,some additional info 3. formEntryInfoOfLimitedUsers =>Lookup to form2,additional info necessary only for limited users Now I've finished creating these forms and reports. I want to use basic information in form 1 like name, email etc in both form and report 3. But in form 3 (there is only lookup to form 2) , I cannot get information
Need a mass update solution...
Hello all, I am a beginner here... So please be patient :) I need to do the following: I have two forms. Form A contains product informations. A few thousands or records. There is a field named "Categorie" and it is written in French... Form B only contains two fields, first the same category infos than Form A (a few hundred types) named "Cat_FR" and the translation field (in English), which is named "Cat_EN". How can I "mass edit'' the Form A to add the field "Category" (with the info from
mass update via Deluge
To mass update 5,000 records, if I use Deluge do I have to use the Iterator method? Is there any other day of doing this? Thanks.
Mass Data update to Form
Hi, I have a form like below where there are three columns like -- county , Fips, Housholds 2013. The first two columns county and fips never change. But the third column Households 2013 will be changed every year. There are around 3,000 rows of data of this form view. For now all of these columns are now connected to several forms by anyway in the entire application. below is the form view screenshot : my question is that what is the best way when I will try to update the Households 2013 column
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms. Hi. I need to do a bulk update so that when a field is ticked, another field updates. I.e. "Confirmed Status" is ticked then a text field called "Current" status would be updated with the text of "Confirmed". I have created an app to do this. It does lots of checks and the code works great in a single form as it uses the OnSuccess events and the OnChange events that happen when creating a new entry or editing
Problem following the tutorial for Zoho Creator
I'm following the tutorial for Creator in the link https://www.zoho.com/creator/help/tutorials/advanced-app-building.html However can't get past the step "Link the Product Form and the Order Form" Seems like when you click Done after following the instructions, the Fields column become blank and it is only selected up to the level of Applications > Forms rather than Applications > Forms > Fields. Not sure how to resolve this.
Zoho Creator - User Audit Detail - Information not available
Please note we are unable to extract audit realted formation from the system on DAILY basis in Zoho Creator 1. Login / Log out Details of all login users – Database wise . Where can we view the summary report (list of all login / log outdetails - userwise) at any given point of time ? 2. 2. Row-wise audit history – for all active rows in a Form i.e. - Each row created date and created user id and last modified date and last modified user against each form in a database? 3.
How can I set a custom filter for a multi-select checkbox field?
Hi Zoho Experts! I'm trying to create a custom filter/view in a report that relies on information from a field that is a mandatory, multi-select checkbox in the original form. The field is "Season" and the values in the field are "Winter" - "Spring" - "Summer" - "Fall" I need to create a custom filter/view that allows me to see all items that have both a "Fall" and a "Summer" value attributed to them (regardless of Winter and Spring). I am able to create a custom filter for one season, but I am
Programmatically Add (Insert) Child Records Upon Parent Add Event?
Is it possible to programmatically add child records [to subform] on the "add record" trigger of the parent form? For example in a basic order-entry application. There are Orders and OrderDetails. OrderDetails accepts entries of Inventory Items. For example, an order may be of a specific "type". This "type" typically includes 10 of the same Inventory items that meet a certain criteria according to "Class" or other field value. So when this "type" of order is added (initiated), I want to programmatically
Report using zoho creator
Hi, I have created one property application in zoho creator, so i want to take report by monthly wise. For Ex : Jan Feb ......... upto Dec AAA 12,00,000 3,00,000 5,00,000 BBB 23,00,000 12,00,000 9,00,000 Issue is Date Format is nt accepted this type of month value, i have one date formatted column.(Added_Date) Can you please ans for this one .........
Automatically update Zipcode
Hi , I want to update automatically zip-code in fields For ex : Location ------ OMR Zipcode ------ 600003 It's is possible in zoho creator,i think it will take from Google Map or other sources
Add Record, Only Want Some Fields Available Before Submit Button
I'm looking for a clean way that when a user wants to add a new record, a "form" ("report"?) opens up with only the key required fields available for data entry, before the Submit button is displayed. In this application, when a new record is added, the remaining 60% of fields are not required as the data for them is not yet known. I don't want the user to have to scroll through many times to get to the Save button far off-screen at the bottom. Also, along the same lines, if I have a report that
How can I allow another user ability to edit my application (add new forms etc)?
I would like to grant another user permission to edit my application, please tell me how I can do this? Thank you, Bianca.
Convert HTML to PDF with filename
Hi, When using the header option pdf = true in an HTML view is there a way to generate the PDF with a file name other than the name of the view? Any help would be appreciated.
Auto Duplication of Form Entries based on Criteria
Hello, I am currently building an Invoice Program in Zoho Creator due to Zoho invoicing not having everything that we need. I need to include the ability to allow re-occurring invoices which are duplicated every month based on the original invoice. I currently have a tick box which if ticked I would like the system to create additional entries once every month until it is stopped. Is this something that can be done? Is anyone able to give me some advice.
List in sendmail
Hello everyone: I have been using a string variable to "build" the list of email addresses that is used in the To: line of the sendmail task. See portions of code below: if ((peemail != "") && (peemail != null)) { toEmails = toEmails + "," + peemail; } and the To: line: sendmail ( To : toEmails, input.Email1 I can't take credit for this genius bit of coding as Zoho did it for me to resolve a sendmail issue I was having. This has been working for a long time and recently
Fetch, Update, and Schedules
Hello! I have a form that has a drop down called "Status" which I use to filter for reports. I'm using the Schedules feature to send a report of records once daily based on the status field. I'd like to create a second schedule to update the status field shortly after the first report is sent. Is this possible? Thanks Arlan
creator.zoho and mobilecreator.zoho
Hello. How to synchronize application from creator.zoho.com to mobilecreator.zoho.com. When user enter data at form on mobilecreator(for example in Zoho app box application), these data automatically update in Report on creator.zoho.com. And another question, I want creat my own application for Andoroid\iOs (.apk .ipa) and then upload to Apple store with own logo etc. but with application on Zoho creator. Is it available, or any ideas how to do that ?? Thanks !!
Formula update
hello, By example i would a number field witch is the subtotal and a formula with TAX and formula with Grand total I would that when my script deluge calculate the SubTotal the TAX and the GrandTotal will be update automaticlly. Is it possible ? thanks you
Display next record +1 on next Add row in SubForn
Hi I'm trying to have the next field to be = Previous record value + 1 so I can start working adding Lines every time the user hits Add new in the Item_Sub Form. Try this but only pass as result = 2 to all new records. x=(row.Number + 1); row.Number=x; I'm completely new on this code trying to learn. Your help will be greatly appreciated.
sharing
hi : i am new to zoho and so using a free version to devlop a small app by it . i have shared my app with a friend ,which appears on his account page as a shared app,but it denys access, is it because of limitation in free version ?, or i miss a setting to let him use it..? please help
Multiple notification rules, yet more than one rule is applied
Hi, I have a drop down box with the aim that when an item is selected, it will produce a custom notification via email. I set up the rule with in criteria section: Dropdown - Equals - "specific dropdown item". I have 12 rules set up - it all works apart from Rule number 1 will always send a notification out as well as what ever is selected in the form. Can you help?
Next Page