Creator offline
Hello Is it possible to have an offline - like Gears on other apps - that could work with Zoho Creator? Thank you Hugo
How to Control Users Permission and Their Log Activities
Hi there I have two important needs 1. I would like to make User Permissions to one or the whole forms and views as follow : - 1 or 2 users as the admins - some users can ADD only - some users can ADD and EDIT - etc How can I do this ? 2. Is there any Automatic User Log Activities or should it be created over script ? If Over Script, can you inform me the steps ? Thank you and regards
Modify checkbox labels through Deluge scripting
In my form, my users can indicate if a requested change is for an entire week or for specific days. If they choose specific days, I have it display a checkbox field that allows them to specify which days. However, I'd like it to dynamically change the labels based on a date they chose earlier. So, for example, if they pick 10/8/2012 from the date field, the specific days should be: Monday (10/8/2012) Tuesday (10/9/2012) Wednesday (10/10/2012) etc etc. Is there any way to do this through deluge scripting?
Importing Parent records with Subform record HELP!!
I was hoping someone could explain where I'm going wrong. I have an excel file with 2 tabs relating to parent and subform. 1) "my Parent record" (named exactly the view name) With an added column with the Subform field name with records = 1 2 3 4 etc 2) "my subform record" (" ") with added column with REC ID linking relating to above 1, 2, 3, 4 etc I then go to creator then to the parent view - more settings, import excel with subform data enabled I can see both sheets on the import
How to get deluge script criteria to show the correct records in a view
I'm pretty new to zoho and deluge scripting. I have tried to do this thing that seems straightforward, but it is not working. I have a membership form and a payments received form. Members pay dues each year. I want two views: one that shows who paid dues for 2012-2013 and one that shows who did not pay dues for 2012-2013. My deluge criteria for the NOT PAID view is: show all rows from Payments [Year_Dues_Paid_For != "2012-2013"] This fails because if people paid in other years, they show up
Schedule limit
Hi - I created 10 schedules. Some are form schedules and some are custom schedules (automatic emails). I realized that they suddenly stopped working. I believe that the issue is due the limit. Does the 31 schedule limit refers to number of scheduled that are set up? Or the number of actual occurrences within 24hrs? If this 31 limit refers to the occurrences within 24hrs, can you please increase it to about 300 for my application? We planned between 100 to 300 occurrences every night. They are
For lookup list widgets, there is a built-in function that provides the record ID of the item selected in the list ?
Hi. A lookup-picklist displays a list of names to choose from. I want to know the record ID# of the selected item. Say, formA and formB. In formB there is a lookup field that import data from formA. After selection, i need to know the item's ID, cause i need to fetch from formA the value of the item (eg. ID 1, value "pippo", i need to fetch "pippo") and copy in a text field in formB. i.ve tried with: var = formB [ID == lookupfield.ID], but it's wrong. Please see this message: https://help.zoho.com/portal/en/community/topic/how-to-get-the-correct-record-id-from-a-selection-in-a-picklist-where-there-are-multiple-records-with-the-same-criteria%3f
Getting values from Zoho Invoice in a Formula Field - NOT WORKING
Here is what I have: A formula field on the form that calls a function, The function accepts the ID field of the form as the parameter. The function makes a call to Zoho Invoice Get Invoice Item API (https://invoice.zoho.com/api/items/) The function works perfectly when tested independently for the same ID values that the formula field would have passed in. However, the view on this form which has this formula field as a column, does not display any value. Regards Moiz Tankiwala Smart Training &
Conditional fields
Hi, I have a question about creating forms I'm willig to have an application that gonna contains many froms, one form is going to contain some versions, and in the other form I should display this versions, added in the first form, as a dropdown field. is it possible to do so? And, I'd like to have conditional fields, for example a field is not shown till another field is well filled Kind regards
Automation API that facilitates import of Zoho CRM Accounts into Zoho Invoice
I need Zoho CRM and Zoho Invoice working in an integrated fashion. My requirement is custom and needs to be built on top of the integration already offered by ZOHO (Zoho Accounts import into Zoho Invoice via ZSC key and display of invoice within Zoho CRM). Moreover there is a custom payment gateway implementation that I have for payment collection for my invoices. Zoho CRM only recognizes invoices of customers that have been imported in Zoho Invoice from Zoho CRM via the ZSC Key. Because of the custom
No way to find my pictures
I made some tests, containing a few pictures. Now, when my students make the test, they don't see the pictures anymore. What's going wrong?
Registration form or log-on
I embedded a registration form into my web site, but some users are reporting getting a log-on field rather than the form. The log on will accept my log-on info and go diectly to the form. lesli.adler
Alternating table row colors in HTML View?
Hello, I could use some help. I have an HTML view of meetings searched by country and city. Some of the queries will return dozens of records, and the table being all one color makes viewing the records confusing. I would like to alternate the colors of the even and odd table rows but I can't find anything to help me in doing this. I have found this link where the rows are exactly as I would like mine to be: https://creator.zoho.com/sharipriya/testing-criteria/view-embed/Testing_View/zc_HdrClr=green&zc_BdrClr=lime
Display CRM data as text
I have selected a sales order from the CRM in custom app using Creator and I want to display the details of the products ordered in the sales order as text or ideally each item as a checkbox. Thoughts?
Where form results open
My form results are opening on top of the form itself and I am not taken to the next URL. My form is at http://jaxareagolfassn.com/Championships/2012/ClubChampionship/2012ClubChampEntryForm.html but I want the user to be taken to http://jaxareagolfassn.com/Championships/2012/ClubChampionship/ClubChampReservations.htm. What am I doing wrong? Thanks, Barney
Need help with one on one relationship
I have a form PROPERTIES with the fields: Property ID, Address, Buy Price, Tax Assessment, Estimated Sale Price. My acquisition department fills this in. I have a form TAX APPEAL with the fields: Property ID, Current tax, New tax, Taxable sqft. My tax appeal department fills this in, however they need to see the Address, Tax Assessment and Estimated Sale Price in order to analyze the property. I've created a lookup on the TAX APPEAL form so that it is linked to the Property ID on the property form.
Outlook Plugin
Hi Support, Does zoho creator support outlook plugin? Please advise. Thanks. Jane
function driven link in HTML view
I have a HTML view that i have created to show me all the reports completed for the day prior, I want to be able to add a link in the HTML view that will allow me to update the status of a field in the particular record. Example: "Approved (button)" is clicked > Approval field on the form is then updated to "Approved" What I want to do with this is have in the HTML VIEW (not a zoho list view) the ability to quickly approve a large amount of records from a single screen by clicking a button. I'm not
Copying Records to Move to Another Form
I have 2 forms set up..one is for current membership and one is for 2007-2008 membership. For members that have renewed, I'd like to be able to just copy their record from 2007-2008 and paste that record into the current membership form. Is there anyway to do this?
view criteria for radio button
hi in my app there is two areas where i use radio buttons 1 area (Sale_Result)- many radiobuttons, 2 area (zakaz_vypolnen) - only one radiobutton (to deny uncheck it, if already checked, for managers) how can i make? 1-st view with checked radio in 1 area and unchecked in 2 area 2-nd view with checked radio in 1 area and checked in 2 area === in 2-nd i just use criteria ((zakaz_vypolnen == "да")) and it is enough in 1-st i use - intitial value =1 for unchecked radio in 2 area - criteria ((zakaz_vypolnen.contains("1"))
Need 3 scripts added (paid job)
I need someone who is knowledgeable in adding scripts to a Zoho Creator form to add these criteria to my form. Doesn't allow duplicate entries. Can't seem to do this based on the URL, which is what I need. Records need to automatically drop off (be deleted) once they expire, based on a date. Person submitting must put proper title to the URL or it will not submit. Please let me know if anyone out there an edit my form to do these things. Wendy
Help with API call via PHP curl
I am trying to write a php application on our website that retrieves our list of members from the creator database we have. Unfortunately the info and descriptions I've found so far are rather poor or outdated, so I am working somewhat blind in making this work even in the most recent examples I've emulated. I do successfully retrieve a ticket, and my login, password, apikey are obscured for obvious reasons. My goal is to read records from a view "PHCP_Members_Know_Location" I've already created
Generating a Sports League Season Schedule
Hello, I've been putting together a sports scheduling application for a commercial league (teams are scheduled based upon their venue and time criteria provided to us upon registration) - It works well enough as is, where the time slots are uploaded from a spreadsheet and the teams that are available for the place/time are the choice for "Team 1" and the choice for the opponent "Team 2" is at the same level of playing ability as the first team. No one team can exceed 8 games played, and no match
linking accounts
We run two separate companies, each with their own zoho account and Creator database and want to keep 'walls' between them. That being said, we would still like to push (or pull) data out of one account, across to the other (preferably as a schedule pr script, but manually if necessary). I can't find any method, question or comment on how to do so? There's one comment in the forums about 'going forward' from a couple years ago, but I can't find anything else. Seems like there should be a method
Summing subform
Hi, I have a subform where I add contacts and it sums the number of them i add in the subform, with the next formula temptotalB = 0; for each record in contactos1 { record.Sub_Total = record.contagem2; temptotalB = (temptotalB + record.Sub_Total); } input.total3 = temptotalB; the columns of the subform are contagem2 Tipo de Contacto Data de Contacto Observações: Sub_Total How can i do this for one condition, for example if a contact doesn´t
Make new CRM Modules with Creator, no Reporting over those modules
I've created 2 new modules to my CRM, Post Sales and Vehicles, to store information about Customer's vehicles and data about fixing those cars. When I tried to create new reports based on those new modules, the reporting interface shows me the standard CRM modules for report construction, by none of my Creator modules. Can't I make some Reports and Charts over my custom modules? Juan Diego
Schedule - Pdf using wrong page orientation
Hi - I created a couple of reports that look good when I exported as pdf. I set them up as landscape . The issue that I have is when I set up a schedule that distribute them via email. Pdfs are sent as portrait and they look odd. Does anybody know how to make Schedule use the correct page settings for pdfs? thanks
how to select more than one line in "lookup" field
how can i change this function so i can select more than one name? it will only let
Grouping members based on their age
Hi I have a list of members, where I have set up a calculated field that calculates the age base on the input of the year of birth. This gives me a list with different ages. However I would like to make a new calculated field that categorize, based on their age, the members into following categories, 0-29 30-39 40-49 50-59 60+ Any idea how this can be done in ZC Cheers DC
Customizing lookup dropdown contents display style.
I have a form to add records to a table. Part of this form is a lookup list displayed as a drop-down menu with data imported from a table of employees. I currently have it configured to show FirstName LastName - IDNumber. What I would like, is to add a column called PreferredName that is not required, that way, when we have someone that goes by a name other than how they are typically listed (Someone named Otto actually goes by Dale), it can be displayed as FirstName (PreferredName) LastName - IDNumber.
adding a "," format to numbers
we using the number field for "quantities", now can only display numbers with no separators like 20000 or 100000 or 3000000 this is difficult to read. we want to display like in excel 20,000 or 100,000 or 3,000,000 how to make this formatting with the comma character "," ? thanks!
Dependent fields are not updated when items from a multiselect field are removed
Hi, I have created a Multiselect field. I also have a formula field that derives it's value from the multiselect field. The formula field updates correctly when items are selected from the multiselect field. Unfortunately, when items are deselected from the multiselect field the formula field is not updated. This problem also occurs with other types of fields when I make them dependent on the multiselect field. Is this something that could be fixed? Thanks! Mike
going to a specific page
Is there a way to navigate thru an extensive list, by pages or views, instead of the "arrows". I am updating many records, and whenever I stop for the day, I must navigate by the arrows 20 times and more to get to the specific page of 200 records where I left off.
Lookup field - how do i sort the returned list?
i am using the Lookup field currently the data comes in, in the order it is inputed. how can i sort the data? i am a noobie and dont know how to script, so any answers, please keep very basic or documented well
any REFRESH button on page in zoho creator's app?
hi! there is some formulas inside my app in creator. and some calculation is fully done after saving entry in database ("save") how can i add some _refresh_button_ on app's page to make all internal calculations done before saving entry?
Important announcement about the new UI :
Since the introduction of the new UI for apps about 3 months ago, a lot of users have moved their apps to the new UI. Till date, 99.99% of the users have moved their apps to the new UI. For those who are in the old UI : All your apps will be moved to the new UI on Oct 15th, 2012. Thereafter, access to the old UI will not be available. If you would like to try the new UI now, please access any of your apps and click the link that says "Face-lift your apps with new UI" at the top. To know more about
Password-protect an application?
Hello, I am the admin on my account and I have two users (userA and userB). I also have two applications in development (appA and appB). How do I only allow userA to access appA and not appB and vice versa for userB? (What are the differences in the role of developer and user?)
Customize the height of the rows of the view
Html Hi I require a customized view of the high rows of the view inserted , to have more space on the bill, as well as the top of header. attached files
Percentage Sign in Zoho Creator Email
I am trying to insert a % sign symbol into a Zoho Creator email (e.g Tax Rate: 10.5 %) where the rate is a Zoho field. When I have tried to do this the email fails. Here;s the code I am using: ("Tax (" + propertyinfo.Tax_Rate + "%): $" + ((input.Tax.round(2)).toString()) If I take out the % sign it works fine. I have also tried using the ASCI hmtl (%) with the same results.
Sender ID of email submission
Hello, When adding a form entry via email is it possible to retrieve the sender's email address? I now hav e form with a ZC_Subject and a ZC_Content and that works. But it would be nice to be able to tell who had sent the email to the form Greetings, Rob
Next Page