Can I create a dropdown populated with user logins?
Hi Looking through the docs and searching I haven't been able to work out how to do this; I don't think it's been asked before. Is it possible to create a dropdown that is dynamically populated with the login names/emails of users who have access to the application? I'd like someone filling in a form to select from the list of users and the form to fire off an email to the user when the form is submitted with the details of the form (I'm sure I can do this using Deluge but I don't have access
Creator - new user
I have to say, after only a couple of days using the "Creator"... it is worth every cent!
I can´t update a rec
I am trying to update a rec with the following script recibo = Recibo_de_Caf[N_mero_de_Recibo_ == input.Recibo_de_Caf.toString()]; recibo.Estado_="Anulado"; But when I "run" the app it show me the following message: What is the problem, What am I doing wrong.
magento
hello, I want to add a drop down list on home page so that user has an option to choose magento theme. thanks.
Need help in REST API via browser
Hi everyone, I've been trying to add a record to my form thru the browser using the below link... https://creator.zoho.com/api/xml/junapp/MyForm/add/?authtoken=XXXXXe&scope=creatorapi&First_Name=Me&Last_Name=Myself and always getting the error message below, anyone else has this issue? An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. cheers
Checkbox list giving duplicate entries when changing text
When I change the text of items on a checkbox list I get the following error message. I am using chrome. I clear the message and continue typing and the new text is saved properly. This is not a show stopper but is irritating.
Multiselect from lookup
Is there a way of populating a multi-select list using a lookup? We have several stock items that continuously change which are input/managed in a 'Service' form. I want to use a multi select list on another form 'Subs' that calls these items for selection. We need as we want to be able to select combinations of the current stock from the list. Either that or have a 'add new' lookup button that will great a new lookup line. Is there a way to do this or is this a limitation of creator?
Powered by broken image
I have a couple html forms embedded with iframes. The place that's supposed to have (I assume) the zoho icon is broken. It says "Powered by" and then a broken image link. The image URL is resolving to this: https://creator.zoho.com/appcreator/live/01/images/ which obviously won't work. I don't mind having the link there - but I'd like it to point to a valid image. As this seems to be a system thing, I don't think there's anything I can do to fix it. Thoughts?
Data refresh on a data list or grid
My apologies if there is an obvious answer . . . I am new to Zoho and would like to create a web app, but need to know the following before putting in the effort. Suppose I am displaying a data grid or data list from, for example, one table. When a user edits data which would reflect a change in that grid or form, how soon will the change appear on all web page displays of that data on other workstations? Is it more or less instant as with Google spreadsheets, for example? I tried a brief trial
Hiding subform formulas
I have a formula field LOGISTIC STATUS in my ASSET form. I have a form CONTRACTED ASSETS that contains the ASSET subform. I want to hide the formula fields from the subform in my CONTRACTED ASSETS form. Note, my requirement is that I want some forms to view the field and other forms to hide the formula. I do not want to turn it off for all forms. When I try the following code, I get an error. Note, I obtained the field name by viewing the form definition. How can I hide the subform formulas? hide
Field Null Validation not working
Hi All, Here is my code: varLeadTime = ((input.Coaching_Start_Date - input.Entry_Date) / (1000 * 60 * 60 * 24)); if ((varLeadTime < 7) && (input.Why_now_Compelling_event_and_timelines_ == null)) { alert "This is less than 1 week notice. Please complete the 'Additional Information' section (Why Now?) to help us prioritize."; cancel submit; } Basically, it is a calculation of how many days notice someone provides for a request. If it is less than 7 days, the user must complete
Isolating date part of date / time variable
I have a date / time variable declared in a form. I am using it's data entry from a calendar view such that both date and time info is input to the variable which is called 'sched_time'. I want to show a grid view of today's records from the form called 'Case' and have attempted to use the criteria as below in the view script. show all rows from Case [sched_time == zoho.currentdate] This does not work and no records are ever shown using this format. I have tried to use combinations of some
Using the API to access a Creator DB.
Hi. I and a coworker have spent quite a bit of time looking for info on this and haven't been able to find anything that works. Here's what we're trying to do. We signed up for the free ZOHO account. We created a DB using Creator. It consists of names and addresses. The only way we want to use ZOHO is as a front end for entering data into this DB, kinda like Access. We want to then use this DB to fuel other web pages. So, if I have an entry in this DB named "FirstName", I need an example of how
Adding Formula results in blank form page
I added this formula to my form: and it results in my form no longer loading:
"Data will be stored in Zoho Creator"?
When I caret new form in new Form Builder, last checkbox ask "Data will be stored in Zoho Creator". What it mean? Nothing happens if I uncheck or check this checkbox...
HTML page...can one view force a refresh of another view
Title speaks for itself. I have an HTML page with multiple views incorporated into it. If a record is changed in one view, can I force a refresh of another view?
Grand Summary Formula Column
Hello. I want to put a formula in a summary row, and have no formula elsewhere. Specifically I want something that does this. See how the Three-Day Average Column has 350 in the "My Movie" Summary line, and is determined by dividing 3-Day Gross / Screens. I've tried everything I can figure out to try. I won't bore you with what I have tried. What works? Title Venue Three-Day Average Screens 3-Day Gross My Movie Astor Theatre 1 567 Average Theatre 1 133 My Movie 350 2 700 Grand Summary: 2 700
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
I want to map all CRM Leads into an Array in Deluge
I want to map all CRM Leads into an Array in Deluge so that I can access each record (lead) in a FOR loop. Any suggestions? Looks like so far I can only get records by ID.
Creator App Duplication Failed
Hi Zoho Teams, We are a IT consultancy team and zoho creator paid users. We aim to promote zoho to our local SME as it's a wonderful tool. This is our app: https://creator.zoho.com/luyiheng/ucdemo It's a demo for our client. However, when we want to deploy this to our client, we could NOT DUPLICATE this app. After click "duplicate", nothing happens. Also, we could NOT EXPORT this app. Please Help! Thank you very much! Best, Yiheng
Access Request/Zoho Privacy Policy
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the user is not presented with an warning. But then, we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the user is presented with a warning that reads like below: --- By clicking 'Grant Access', you give Zoho permission to enable [MYSUBDOMAIN].[MYDOMAIN].COM to access all your user data available with Zoho
Can I make a app in Zoho Creator for my database in Zoho Reports???
I want a quick way to make apps for my database that I have created in Zoho Reports. Would like to use Zoho Creator, but cant see anyway of doing it?
Add records by status in ZohoCreator Reports
Some example function that adds record status by the creator of Zoho Reports? I want to add up all the forms that are as "Approved". Thank you.
catch post rest api response
Hello, I am using rest api to add new records to my form from my external php/javascript application: https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html The records are successfuly added, but the response is automatically downloaded to the client machine, the customer doesn't understand xml/json/csv formats, so this causes a problem. Second, I want to use that response (the ID) to add other records that have lookup to that first added record. Can anyone help me?? Thank you
Looking-up a record from another site or location
Hello, I need help on how to connect and retrieve a record from another file that is located externally, on some website or network drive, without having to load the entire file into a table in my application? Is it using API? examples would be very helpful. I read the guide with GetUrl, etc. and that was somewhat confusing. I would really appreciate some help on this. Thanks
A question about fetching sorted records
http://kbase.creator.zoho.com/records/fetch-records-within-a-range in the above document, this: rec = Contact [ID != 0] sort by Added_Time range from 1 to 5; so, my question is, if I do a for each r in rec { list.add (r.Name); }Will it add Names from the records to the list in sorted order of Added_Time?
Mobile linking in HTML view
Hi, I'm adding some dashboards to my application, from where the users are being linked to specific views and forms. This is quite simple, linking to #View:<view name>. The problem is with mobile viewers. Since Zoho Creator doesnt support Javascript (why is that anyway?!) I can't change it depending on user agent or whatsoever. How do I solve this? Thanks in advance for your help.
HTML in Variable
I am trying to create a variable for use in an email that contains HTML (for a dynamic link). The issues I am having is with the quote signs in the HTML. I cannot seem to get the variable to save with the quotes: agreementlink = ("Please sign your rental agreement by clicking the following link:<a href=\ "http://creator.zoho.com/carlgifford/vacation-rental/Rental_Agreement/record-edit/Rental_Agreement_View/" + input.RentalAgreementID + "\ ">Rental Agreement</a>"); Is there a way to do this? Thanks
Subform: Criteria rules not working correctly
Hi, Background: I have a PROJECT form that has a relationship with CUSTOMER & AGREEMENT. The AGREEMENT field has criteria where CUSTOMER_ID == input.CUSTOMER_ID. This works fine in the form. Eg When I select customer 123, I can see agreements 12 & 22. Problem: I have a PROJECT subform in my CUSTOMER form. When the user adds a new project, I expect the Agreement dropdown to show the relevant filtered agreements. However, I do not see any agreements. Eg When I view customer 123 & add a new project,
Urgent: task zoho.crm.searchRecords don't works
the taks zoho.crm.searchRecords don't works anymore in my app, i try to see crm response with this functions list test.test() { crmResp = zoho.crm.searchRecords(("Accounts"), "(CIF|=|XXXXXXX)"); return crmResp; } and show me this: [{4834=Invalid Ticket Id}]it was working 2 days ago
Sum of 3 fields depending on user login??
Would love for someone to help me out with this. I can't think of a solution and have spent SO many hours.... I am using a form, where up to 3 users can split a commission on a team. The main agent adds the file, then they add one or two agents to share commission. Then, 3 fields are calculated that shows the commission for agent 1, agent 2 and agent 3. Now, I want each agent to be able to see their commission in a view or report form. I would prefer it to show as one field only, that represents
Update for the whole application
fetch and record for update from one form to other form is fine. However, my application need to be very relative together. For example: Form A: a cost of something (I will call A) Form B: fetch A * with a user input num = B Form C: a cost of something (I will call C) Form D: fetch C * with a user input num = D Form E: fetch B + fetch D = E Fetch and Update record will work when I update value in update Form A --> auto update to the fetching A in form B. But can not update value B update Form C
Subform calculations
I’m having trouble adding a column of numbers in a subform. As an example I created a form with the new builder. It has a subform with one numeric field, a separate number field for the total and a decision box to calculate the total. I added two rows to the subform. The number field on row one is 1, the number field on row two is 2. The calculation gives me a total of 5. If I add a third row with a value of 0 then the total drops to 3. The last row is being counted twice. Here is the script for
How to create a view which self filters using user information from one form and displaying the filtered information from another?
I have two forms. One which has all the data I wish to display on our work, the other is a list of the users and their specialities and location. I want to create a form so when they log in it will show them information on all the items that are linked to their speciality and location. Both the location and the speciality apear in both forms. In the user form has the users email. I have created similar view to display for individuals who have their name on the item, this is done with the below
warehouse development
Hi guys, nice to meet you. I'm finishing the development of a company application to manage our warehouse. To create a selected list for product, i've arranged following script: lisart = List:Int(); for each y in magazzinos [(((stock_colli > 0 && deposito == doc.deposito2) && data_scadenza_lotto >= zoho.currentdate) && (protocollo_magazzino is not null))] sort by articolo { if (!lisart.contains(y.articolo)) { lisart.add(y.articolo); } } The problem is that "magazzinos" table
How to create function that returns all the selected fields in column "Email_Address" in a view?
Hi, I'm strugling with this one - I have a form where one column is "Email_Address". Now I need the user to be able to select appropriate rows in a view and on press of a button get all the email addresses to copy&paste I've been experimenting with the following code: string Get_Email_Address() { x = i.Email_Address ; Info x ; } return x ; This just lists of the email addresses in the log, but obviously returns only the last one. How do I make it to return all of them? and how do I narrow it down
Dynamic List Reference
I am creating a multiselect dynamic list and would like to include specific information from the records in the picklist. For example: Deposit: $300 Payment #1: $500 Payment #2: $600 The payment amount would come from the id reference. I am able to do this using the following code: Reservations = Rentals [ID == input.Reservation]; paymentlist = List:String(); if (Rentals[ID == input.Reservation].Deposit_Balance != 0) { paymentlist.add("Deposit: $" + Reservations.Deposit_Balance);
Due Date for Form
I am trying to create a form script in which a "due date" will be automatically populated based on the day of the week I select in a date field. For example if I enter a date that falls on a Monday the "due date" will add 11 days. If I enter a tuesday it will add 10 days, etc. Any help would be appreciated, thanks.
Form Printer Add-on for Creator
I need a way automatically fill out the fields on a paper form with data from a Zoho Creator report. The goal is to auto-generate and print a completed paper form that looks exactly like the original blank paper form, but with all the fields filled in with Zoho database data which was extracted from a Zoho report screen. This is important, because many applications require the filling out of forms where you must use the exact layout of the original blank form for the completed form. The basic steps
Is there a way to get data out of backup version of app, without restoring the backup?
Since zoho support still can't tell me why duplicate application doesn't work, I decided to just work on the original and backup. Seemed sufficient, till I realized I needed the original data from a previous backup.
Next Page