Pricing
We resell instrumentation from different suppliers to our customers and have to import the items to Trinidad. Therefore I would get a list price in USD (I may have a discount factor to apply depending on the supplier), I have to the add various charges including S&H, Freight, Insurance, Transportation, Duties, etc and then add a markup to resell. Reselling is done in TTD or USD depending on the customer. I would therefore like to add these cost separately and also to view my estimated profit margin
Repeater in zoho??
Hi, I have a page in asp.net where i'm using repeater as input by the user. In a page i have a dropdown for departments, based on department i will get units. These units are placed in a repeater with two dropdown and textboxes and a check box too. in the bottom i have a submit button.. HOW CAN I DEVELOP THIS PAGE IN ZOHO. ACTUALLY HOW CAN I USE TYPE A REPEATER IN ZOHO. can any one please help me. Thanks MOHAMMED
Public record
Hello, I'm building an application in ZoHo creator. Now in the application someone can make an assignment for a supplier. After making an assignment the application sends an e-mail to the supplier with a link which opens the record in editing mode. The supplier should put his comment and whether he aggrees with the assignment in this record. He only has to fill in two fields. The supplier will not get his own login (user). The problem is when I open a public record in editing mode, I can change every
Dynamic picklist based on a form with a deeper form.
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Deluge script corrupt/missing
Hi, I am relatively new to deluge scripting. Has anybody has experience as follows. 1. A script with 75 lines suddenly only had 24 lines.(!!) 2.Then the previous versions of this particular script were missing or partially missing 3. Zoho support had replicated this and are investigating. Does anyone else have comments on this? Is this a rare or unique occurence?
Unable to update main table basis sub-table values
Hi I have been trying various methods to do so for the last 2-3 days. Basically, I have the following structure: 1. Main table with fields: OrderID, customername, orderstatus 2. Sub-table with fields: ShopOrderID, shopname, shopstatus OrderID and ShopOrderID are bidirectional fields linked to each other. It is a one to many relationship with multiple rows for each main row I have managed to write a function that updates shopstatus basis update in orderstatus. I wish to update orderstatus if the shopstatus
Dynamich lookupfield
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Dynamich lookupfield -
Hello, I have 4 forms: 1. Form with single line named: Label 1 2. Form with single line named: Label 2 3. Form with single line named: Label 3 4. Form with three look-upfields based on forms with Label 1, Label 2 and Label 3 5. Form with three look-upfields based on form 1, 2 and 3. Now I want to make the lookupfields in form 5 dynamic. So if in form 5 label 1 is chosen it only has to show the relevant labels 2 based on form 4. I hope someone can help me. Greatings, Erwin.
Updating parent row information basis values in child rows
Hi I have been trying to update a field in a parent row basis values that are edited in the child rows, but been unable to get it working. To elaborate: 1. Parent table has fields - OrderID (unique id), customer id, orderstatus 2. Child table has fields - ShopOrderID (bidirectional field linked to OrderID in parent table), Shop name, shopstatus Each parent row might have unlimited child rows linked to it basis the unique OrderID. I have managed to update shopstatus basis changes in orderstatus. However,
Open published form in iframe using recLinkID criteria
Hi clever people, I am trying to open a form using the recLinkID from another form which is embedded in an iframe and published (not requiring a user to be logged in). I have managed to get the form to open from a previous embedded form using: myURL = "https://creator.zohopublic.com/<username>/<appname>/form-perma/typesfrm/<encryptioncode>/recLinkID=" + thisID + "&viewLinkName=typesfrm_Report"; openUrl(myURL, "iframe", "formEmbed"); ...but the update button in the form does not work to update the
Native App Signature Problem
Good day, Im trying to retrieve the url information of a signature field but I got some problems: Sometimes I capture the signature in native app and sometimes I capture in the browser way. In the On Sucess I have this part of code imagelnk = input.SignatureField; The problem is that when I submit the form in the native app this value takes in the On Sucess 1448464101903_Signature.jpg If I check the Url of the image signature is a png file. I try replacing the string extension to match the png file,
Number of days in this month
How do you find out the number of days in the current month?
Emulating an editable grid in Forms
Hi I would like to show a row of fields similar to a spreadsheet that are editable and if possible hidden and shown depending on another field which says how many rows should be displayed. So if the user enters 5 in the other field, 5 editable rows of roughly 5 cells each should appear. I haven't seen any examples yet of this in my searches so far. Any help appreciated. Paraic
Form View not showing column
I have added a new date field to my form, and even though it is showing in the Column Properties edit columns, it doesn't actually show up in the view itself. I have tried deleting it, and re-adding it from the right hand "store" of columns, but it's still not showing.
Map ZC data to Adobe Acrobat PDF form fields
Any ideas on how this could be done? Can a Acrobat form be embedded somehow into a Record Summary? Maybe Zapier could do this?
How to disable Radio Button choices/values
Hello, I am working on a registration form which has a set of 3 radio buttons for class selections Radio_set1: Class 1 Class 2 Class 3 I would like to disable Class 1, Class 2 and Class 3 individually when certain requirements are met. I do not wish to disable the whole Radio_set1. May I know if there is a way to do this? Thank you very much.
Changing default orientation of record summary to landscape
Hi, Is it possible to change the page orientation of a record summary to landscape? Also, if I try and print a record summary, the zc orientation paramater does not work with this url: zoho.appuri/record-print/View_Invoice_History/ID Regards, Shaheed
Fetch Parent and it's Child records
Hi Need some urgent help. I have a lookup relationship from cases(child) to potential(parent) Once I associated a potential to a case, I need a script to trigger which will fetch all the related child cases for that particular potential and count them. Any help is appreciated.
How to find some data
Hello, I created one Userform1 Date : 15/11/15 Panne : Abcde Machine :15 Now i creat a userfom2 : Date : Lookup > Userform1> Date Panne : Machine : I would like on Panne and Machine.. when i select the Date i creat on userfom1 to see the data automatic In Panne and Machine on userform2 Sorry for my language i'm french ;) Thank for your help Kemel
Dropdown List Value from different Form
Hi, I have two forms FormA & FormB. In FormA there are field called Email & Country(Multi Check box) In FormB there is field called Email (Lookup to Email field in FormA) & Countries (Dropdown box) What I wanted to achieve is, when an email is selected in FormB, field Countries should populate the list of values we selected in FormA for that email. Please let me know if you need more clarification. Thank you in advance for your support.
RTF no longer has On User Input
Rich Text Fields don't have an On User Input section. I need to check the word count and display an alert warning if it is not appropriate. Without the On User Input how do I trigger the logic?
Google Sheets Script
I am trying to get my Zoho Creator form to change values in my Google Sheets file. I've been trying different scripts but cannot find any clear direction as to how to go about doing this. What I want is to have the ZC form with Work Order Number & Hours Worked fields. When the user clicks submit this will send these 2 fields to a Google Apps Script - which finds the row with the Work Order Number and then edits the Hours Worked entry. I can execute the change on scripts but I cannot figure out how
field name
i create new form but when i tried to change the file name to another name it is saved but not change the file type " decimal" i want to change name to " input " what is the problem because before i used it and changed easy
Mobile Zoho Creator - Upload Image Already On Device?
I am running into issues where an image may have been taken earlier with a smartphone camera and is currently in the "Photos" location on the phone (iOS). Why is there not a third option to select a photo already stored locally on the smartphone? In my particular application, a user may capture a photo that will later be used in the Zoho app, when it's convenient (but not necessarily while the user is actually running the app) i.e. the user would have to go back and do the photo AGAIN, just to
Include Report Template in email On Delete On Validate or Success
Including a Report Template in an email when a record is deleted can be useful as an audit trail. I understand that all the fields can individually be included in the email but that is a lot of work when a template might already have been built.
Help creating a contact search form, similar to the one available in zoho crm campaigns.
Hi, I'm looking to create an interface where i can select existing contacts. Essentially, exactly the same as you do in zoho CRM under the campaigns tab. Near the bottom is a "Contacts" heading and upon clicking "Add Existing contacts" you get a form you can search your existing contact base with and select them. I looked into the documentation, specifically towards search forms, but that example seems very complex. It also doesn't do as much as the search i previously spoke about. So, is there
zoho creator app
How can i display this type of question in zoho creator? Statement 1.Yes 2.No, Why?............ and table filed to get data?
Email masking and tracking
Hi, We have set up our CRM on Zoho Creator so we can manage our enquiries and bookings of sports bookings for football pitches, tennis courts, etc. We want to be able to track when a sports venue responds to a user. We've tried making links that go to a Zoho form for venues to accept or decline a booking. However some venues have restricted access to the internet, so these links dont always work. We also dont want the venue to get the real email address of the user, and vica versa. Like Holiday Lettings
how can I show scripts from this sample http://creator.zoho.com/sampleapps/send-pdf-link-in-email/#
how can I show scripts from this sample http://creator.zoho.com/sampleapps/send-pdf-link-in-email/#
Send Mail
Hello. I'm using the "Send Mail" function to notify my clients when a work order is generated. In the email message I'll have info from the work order fields such as: Contact Name: <%input.Contact_Name%> I have several fields and they don't always have data so in the email it would show "Contact Name: null". Some of these fields are related lookup fields and such. I know how to pull related data by using something like "a = Contacts_List[ID == input.Contacts_List];" so no issues there. What I would
Display Records in HTML Page View
I am beginning to discover more about Creator - Pages. Right now, I am attempting to develop a simple page that would show information related to projects. Below is the code I am using. The issue: I have three different projects in the form it's pulling from. It is showing the same project on three rows instead of a new project on each row. htmlpage Search() <%{ projects = Project_Information [ID != 0]; %> <table width="200" border="1" align="left" cellpadding="1" cellspacing="1"> <caption>Test</caption>
Creating a new entry in one application based on field values in another application
Hi There, I have a BAU application we use for tracking delivery and collection requests, I also have another application that tracks the repairs on any returned devices. On the BAU application we can select the service request and select "Faulty Device Collection" if we have a faulty device coming in. What I would like the BAU application to do is raise an initial entry in the Repair Tracker application, copying a numbe rof field values from the BAU app to the Repair tracker app, when I complete
NEED DEVELOPER - Have created a custom application however need help with the reporting.
Hello, we have developed a custom application for our business however when we try to print any type of report the formatting is a mess. We need help figuring out either how to handle the formatting or how we can export to Google Sheets or a different alternative and or map data to a premade report.....etc. Please help, we will gladly compensate.
Need detailed instructions on how to use relational database functions with already imported files
I am new to Zoho, and am struggling to set up our basic system. I work for an educational nonprofit and I have no real coding experience, though I had maintained databases in Access and Excel. I have two major forms imported from excel files. One is our alumni records/contact info, etc. The other is a list of college records for these alumni, by term (so one line would be for one student one term at one school). It is a basic one to many relationship, and the records are linked with a long
Populate a PDF form with data from a ZC Report Record?
Any ideas on this functionality?
Track Work in Progress
A couple questions...very grateful if anyone can help. I want to track where an item is on our factory floor. The general process is we start with an item in Receiving, it goes through QC, Inventory, Benches and then Shipping. The primary identification is the Item #. Ideally, someone creates an Item using the Item Creation Form, for examploe product number 1ST1066. Each time it enters an area an employee checks the product in to the new area. In my dreams, they open the Item Location Form,
List contains function, does it work?
Does the contains function work for lists? for instance Fetch_Records = Form1 [multi_select_lookup_field.contains(Record_ID)]; It seems this script statement is not functional. if it doesn't work, what would be the simplest workaround? The help section on this topic (see below) is not clear. According to it, we need two parameters, list.contains(str1 , str2) ? thanks for the help. ---------------------- List Function - contains This topic describes the syntax and usage of the list - contains function
Connect Creator to Invoice
I have a Creator database that has client information. Is there a way to connect this information to Invoice so that I can create invoices by looking up the clients?
cURL to add record error not a valid form, but form exists....????
I am attempting to add a record to a form but I keep getting an error stating that the form does not exist, although I know it does, and yes I'm using the linkname, not the form name in my URL. $data = array( ‘authtoken’ => xxxxxxxxxxxxxxxxxx, ‘scope’ => creatorapi, ‘names’ => bob, ‘total’ => 12.50 ); # Create a connection $url = 'https://creator.zoho.com/api/xxxxxuser/xml/test/form/this_form/record/add/'; $ch = curl_init($url); # Form data string $postString = http_build_query($data,
How to integrate zoho security with a custom user form
I have a 'Add Employee' form with Name, email and role fields.Is there a way to tie these to the zoho security thats under myapplication setting. I do not want my user going to the 'ApplicationSetting' to create users to access my app. Thank you Anand
Next Page